Notesale: Turn your study into money

Document Preview

Extracts from the notes are below, to see the PDF you'll receive please use the links above

---

Online Freelance Market Place
Final Deliverable
CS619
Registration Form:
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
FileUpload1
...
MapPath("~/images/") +
Path
...
FileName));
string link = "images/" + Path
...
FileName);
string status = "ok";
string query = "insert into
users(userID,Name,password,Address,Email,MobileNo,userType,status,photo) values('" +
TextBox1
...
Text + "','" + TextBox3
...
Text +
"','" + TextBox6
...
Text + "','" + RadioButtonList1
...
connectionString);
con
...
ExecuteNonQuery();
con
...
Text = " You are registered successfully
...
Redirect("RegistrationForm
...
connectionString);
DataTable dt = new DataTable();

SqlDataAdapter da = new SqlDataAdapter(query, con);
con
...
Fill(dt);
con
...
DataSource = dt;
DataList1
...
Text;
string password = TextBox2
...
Text;
string query = "select * from users where userid='" + userid + "' and
password='" + password + "' and status='ok'";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
da
...
Close();
if (userid
...
Equals("admin") &&
userType
...
Redirect("AdminConsole
...
Rows
...
Equals("Client"))
{
Session["userid"] = userid;
Response
...
aspx");
}
else if (userType
...
Redirect("FreelancerConsole
...
Text = "Please enter correct user id or password";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
string category = DropDownList3
...
connectionString);

DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(query, con);
con
...
Fill(dt);
con
...
Rows
...
DataSource = dt;
DataList1
...
connectionString);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(query, con);
con
...
Fill(dt);
con
...
DataTextField = "category";
DropDownList1
...
DataSource = dt;
DropDownList1
...
Close();
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
}
protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void DataList1_ItemDataBound1(object sender, DataListItemEventArgs e)
{
}
protected void Button3_Click(object sender, EventArgs e)
{
Response
...
aspx");
}

}
}
_________________________________________________________________________________________

Admin Consol: |Ban User |
UserManagement:
public partial class UserManagement : System
...
UI
...
Text = Session["userid"]
...
Text + "','" + Label1
...
Text + "','Client','" +
TextBox4
...
Now + "','" + status + "')";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
SqlCommand cmd = new SqlCommand(query, con);
cmd
...
Close();
Label2
...
Redirect("AdminAccountsInformation
...
connectionString);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(query, con);
con
...
Fill(dt);
con
...
DataSource = dt;
GridView1
...
ToString();
Label1
...
connectionString);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(query, con);
con
...
Fill(dt);
con
...
Rows
...
DataSource = dt;
GridView1
...
Text = Session["userid"]
...
Text + "','" + Label1
...
Text + "','Client','" +
TextBox4
...
Now + "','" + status + "')";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
SqlCommand cmd = new SqlCommand(query, con);
cmd
...
Close();
Label2
...
Redirect("ClientAccountInformation
...
ToString();
Label3
...
Text +
"','" + DropDownList1
...
Text + "','" + txtBudget
...
Text + "','" + txtTools
...
Text + "','" + txtDescription
...
Text + "')";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
SqlCommand cmd = new SqlCommand(query, con);
cmd
...
Close();
Label4
...
SelectedDate
...
Text = date;
}
protected void Calendar2_SelectionChanged(object sender, EventArgs e)
{
string date = Calendar2
...
ToString();
Label2
...
Redirect("Client_PostProject
...
ToString();
Label1
...
connectionString);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(query, con);
con
...
Fill(dt);
con
...
DataTextField = "Title";

DropDownList1
...
DataSource = dt;

DropDownList1
...
Close();

}
}
}

protected void Button1_Click(object sender, EventArgs e)
{
string pid = DropDownList1
...
connectionString);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(query, con);
con
...
Fill(dt);
con
...
Rows
...
DataSource = dt;
DataList1
...
userID = '" +
Label1
...
connectionString);
DataTable dt = new DataTable();

SqlDataAdapter da = new SqlDataAdapter(query, con);
con
...
Fill(dt);
con
...
DataSource = dt;
DataList1
...
CommandName == "viewProfile")
{

DropDownList dlist = (DropDownList)(e
...
FindControl("DropDownList1"));
TextBox txtBid = (TextBox)(e
...
FindControl("TextBox1"));
string freelancerId = e
...
ToString();
string clientIDId = Label1
...
Redirect("viewProfile
...
CommandName == "assignProject")
{
string bidid = e
...
ToString();
DataTable dt1 = getBidInfo(bidid);//bind info

string projectTitle = dt1
...
ToString();
string freelancerId = dt1
...
ToString();
string amount = dt1
...
ToString(); ;//project amount
string clientID = Label1
...
Rows
...
Rows[0]["Duration"]
...
Now;
int duration = Convert
...
AddDays(duration);

startDate = date1
...
ToString();
Duration = duration
...
connectionString);
con
...
ExecuteNonQuery();
con
...
Redirect("Thanks
...
Redirect("Addtocart
...
CommandArgument
...
SelectedItem
...
connectionString);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(query, con);
con
...
Fill(dt);
return dt;

}

private void TransferMoney(string UserID, string Amount, string status)
{
// Accounts(AccountNumber, UserID, Password, usertype, Amount, date, status)
string companyAcct = getCompanyAcct();
string query = "insert into Accounts(AccountNumber,UserID,usertype,Amount,date,status)
values('" + companyAcct + "','" + UserID + "','client','" + Amount + "','" + DateTime
...
connectionString);
con
...
ExecuteNonQuery();
con
...
Now + "','" + status
+ "') ";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
SqlCommand cmd = new SqlCommand(query, con);
cmd
...
Close();

}

private string getAccountInfo(string clientID, string userType)
{
string query = "Select * from Accounts where userID='" + clientID + "' and usertype='" + userType
+ "'";

// string query = "select * from Client_Projects where category='" + category + "'";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
da
...
Rows
...
Rows[0]["accountNumber"]
...
connectionString);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(query, con);
con
...
Fill(dt);
string accountID = "";
if (dt
...
Count > 0)
{
accountID = dt
...
ToString();
}
return accountID;

}

private DataTable getBidInfo(string bid)
{

string query = "Select * from Freelancer_Bids where bidID='" + bid + "'";

// string query = "select * from Client_Projects where category='" + category + "'";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
da
...
Close();
return dt;

}

protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
{

}

protected void DataList1_ItemDataBound1(object sender, DataListItemEventArgs e)
{

}
}
}

Client Consol: | Review Projects|
ReviewProjects:
public partial class ReviewProjects : System
...
UI
...
ToString();
Label1
...
connectionString);
cmd = new SqlCommand();
con
...
Fill(dt);
gridviewFiles
...
DataBind();
cmd
...
Dispose();
con
...
Text;
string
string
string
string
string
string

ProjectID = DropDownList1
...
Text;
Stars = DropDownList3
...
Text;
Status = DropDownList2
...
connectionString);
con
...
ExecuteNonQuery();
con
...
Text = " Saved successfully ";

}
protected void FileDownload_Clicked(object sender, EventArgs e)
{
try
{
var element = (LinkButton)sender;
String filename = element
...
ToString();
String filepath = Server
...
Clear();
Response
...
ClearContent();
Response
...
Flush();
Response
...
End();
}
catch (Exception ex)
{
}
}

private void bindProjectTitle(string userID)
{

string query = "select distinct projectTitle from UploadProjects where
ClientID='" + userID + "'";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
da
...
Close();
DropDownList1
...
DataValueField = "projectTitle";

DropDownList1
...
DataBind();
con
...
connectionString);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(query, con);
con
...
Fill(dt);
con
...
Rows
...
Rows[0]["fid"]
...
ToString();
getReviews(userid);
getAssignProjects(userid);
}
}

private void getReviews(string userid)
{
string query = "select * from Project_Review where fid='" + userid + "' ";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
da
...
Close();

GridView2
...
DataBind();
}

private void getAssignProjects(string userid)
{
string query = "select * from AssignProjects where fid='" + userid + "' ";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
da
...
Close();
GridView1
...
DataBind();
}

}

Freelancer Consol: | View Profile|
FreelancerProfile:
protected void Page_Load(object sender, EventArgs e)
{
string userid = "";
if (Session["userid"] != null)
{
userid = Session["userid"]
...
Text = userid;
}
string query = "select * from users where userid='" + userid + "'";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
da
...
Close();
if (dt
...
Count > 0)
{
GridView1
...
DataBind();
}
else
{

}

}
}
}

Freelancer Consol: | Assignment Management|
Freelancer_UploadAssignment:
public partial class Freelancer_UploadAssignments : System
...
UI
...
ToString();
Label1
...
MapPath("~/Files/" + FileUpload1
...
SaveAs(filePath);
lblInfo
...
GetFileName(FileUpload1
...
ToString();
con = new SqlConnection(DatabaseClass
...
Open();
cmd
...
CommandType = System
...
CommandType
...
CommandText = "sp_AddFiles";
//projectTitle,ClientID,FID,FileName,filePath,date,status
String FileName = TextBox1
...
Text;
string ClientID = getClientID(projectTitle);
string FID = Label1
...
Parameters
...
Parameters
...
Parameters
...
Parameters
...
Parameters
...
Now);
cmd
...
AddWithValue("@filePath", FileUpload1
...
Parameters
...
ExecuteNonQuery();//insert data
cmd
...
Dispose();
con
...
Text = "Saved successfully
...
Text = ex
...
ToString();
}
}

private void bindProjectTitles(string fid)
{

string query = "select distinct projectTitle from AssignProjects where fid='"
+ fid + "' ";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
da
...
Close();
DropDownList1
...
DataValueField = "projectTitle";
DropDownList1
...
DataBind();
con
...
connectionString);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(query, con);
con
...
Fill(dt);
con
...
Rows
...
Rows[0]["ClientID"]
...
Web
...
Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["userid"] != null)
{
Label1
...
ToString();
string amount= showAmount(Label1
...
Text = "Your Total Balance :" + amount;
}
}
private string

showAmount(string userid) {

string query = "select sum(amount) from Accounts where userid='"+userid+"'";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
SqlCommand cmd = new SqlCommand(query, con);
string amount= cmd
...
ToString();
con
...
Text + "','" + Label1
...
Text + "','Client','" +
TextBox4
...
Now + "','" + status + "')";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
SqlCommand cmd = new SqlCommand(query, con);
cmd
...
Close();
Label2
...
Redirect("FreelancerAccountInformation
...
Web
...
Page
{
protected void Page_Load(object sender, EventArgs e)
{
string userid = "";
if (Session["userid"] != null)
{
userid = Session["userid"]
...
Text = userid;
}
string query = "select * from FreeLancer_Skills where userid='" + userid +
"'";
SqlConnection con = new SqlConnection(DatabaseClass
...
Open();
da
...
Close();
if (dt
...
Count > 0)
{
GridView1
...
DataBind();
}
else
{

}
}
protected void Button1_Click(object sender, EventArgs e)
{
string query = "insert into FreeLancer_Skills values('" + Label10
...
Text + "','" + TextBox2
...
Text + "','" +
DateTime
...
connectionString);
con
...
ExecuteNonQuery();
con
...
Text = " Your skills are saved successfully ";
}
}
}

_____________________________Ended________________________________



---