protected void LogInBtn_Click(object sender, EventArgs e)
{
Members m = new Members();
MembersServer ms = new MembersServer();
m.memberMail = Mail.Text.ToString();
m.memberPass = Pass.Text.ToString();
if (!ms.IsMailExist(m))
{
if (!ms.Login(m))
{
//string strSql = "SELECT * FROM Members WHERE MemberMail='" + m.memberMail.Trim() + "'";
DataSet ds = ms.ShowMember(m.memberMail.Trim());
//ds = Connect.GetDataSet(strSql, "Members");
m.memberFname = ds.Tables["Members"].Rows[0]["MemberFname"].ToString();
m.MemberLname = ds.Tables["Members"].Rows[0]["MemberLname"].ToString();
m.memberMail = ds.Tables["Members"].Rows[0]["MemberMail"].ToString();
m.memberGender = ds.Tables["Members"].Rows[0]["MemberGender"].ToString();
m.memberHobies = ds.Tables["Members"].Rows[0]["MemberHobbies"].ToString();
m.memberPass = ds.Tables["Members"].Rows[0]["MemberPass"].ToString();
m.memberPic = ds.Tables["Members"].Rows[0]["MemberPic"].ToString();
m.memberManager = bool.Parse(ds.Tables["Members"].Rows[0]["MemberManager"].ToString());
Session["Member"] = m;
Response.Redirect("../pages/Main.aspx");
}
else
{
lblError.Text = "הסיסמא או המייל לא נכונים";
}
}
else
{
lblError.Text = "המייל שהוקלד לא קיים במערכת";
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
GridViewRow r1 = e.Row;
string mail = r1.Cells[2].Text;
MembersServer ms = new MembersServer();
string pic = ms.PicUrl(mail);
((Image)r1.FindControl("MemberImage")).ImageUrl = "../MembersImg/" + pic + "";
}
for (int i = 0; i < GridView1.Rows.Count; i++)
{
if (GridView1.Rows[i].Cells[9].FindControl("DeleteBtn") is Image)
{
((Image)GridView1.Rows[i].Cells[9].FindControl("DeleteBtn")).Attributes.Add("onclick", "DeleteRed('" + GridView1.Rows[i].Cells[2].Text + "')");
}
}
for (int i = 0; i < GridView1.Rows.Count; i++)
{
if (GridView1.Rows[i].Cells[8].FindControl("ImageUpdate") is Image)
{
((Image)GridView1.Rows[i].Cells[9].FindControl("ImageUpdate")).Attributes.Add("onclick", "UpdateRed('" + GridView1.Rows[i].Cells[2].Text.Trim() + "')");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Members m1 = (Members)Session["Member"];
MembersServer ms = new MembersServer();
DataSet ds = GetData(m1);
GridView1.DataSource = ds;
GridView1.DataBind();
GridView1.Attributes.Add("style", "margin-top:20px; direction:rtl");
}
public void fill(string mail)
{
MembersServer ms = new MembersServer();
DataSet ds = ms.ShowMember(mail);
Members m = CreateMember(ds);
txtfName.Text = m.memberFname.ToString().Trim();
txtlName.Text = m.MemberLname.ToString().Trim();
txtMail.Text = m.memberMail.ToString().Trim();
txtPass.Text = m.memberPass.ToString().Trim();
txtPass.Attributes.Add("value", m.memberPass.ToString().Trim());
txtRePass.Attributes.Add("value", m.memberPass.ToString().Trim());
txtRePass.Text = m.memberPass.ToString().Trim();
txtDate.Text = m.memberDate.ToShortDateString().Trim();
}
public static DataSet GetData(Members m1)
{
DataSet ds = new DataSet();
MembersServer ms = new MembersServer();
if (m1.memberManager)
{
ds = ms.ShowAll();
}
else
{
ds = ms.ShowMember(m1.memberMail);
}
return(ds);
}
protected void btnSend_Click(object sender, EventArgs e)
{
string photoName = "";
if (photoUpload.HasFile)
{
photoUpload.SaveAs(Server.MapPath("/MembersImg/" + photoUpload.FileName));
photoName = photoUpload.FileName;
}
else
{
photoName = "ferrarisym.jpg";
}
Members m = new Members();
DateTime date1 = Date1();
MembersServer ms = new MembersServer();
m.memberFname = txtfName.Text.ToString();
m.MemberLname = txtlName.Text.ToString();
m.memberPass = txtPass.Text.ToString();
m.cityId = int.Parse(cities.SelectedItem.Value.Trim());
m.memberGender = rbtGender.SelectedItem.Text.ToString().Trim();
m.memberHobies = cbxHobbies.SelectedItem.Text.ToString().Trim();
m.memberPic = photoName;
m.memberDate = date1;
m.memberMail = txtMail.ToString();
if (!ms.IsMailExist(m))
{
ms.Register(m);
Session["Member"] = m;
Response.Redirect("../pages/Main.aspx");
}
else
{
lblEror.Text = "המייל כבר קיים במערכת";
}
}
protected void Page_Load(object sender, EventArgs e)
{
MembersServer.DeleteMember(Request.QueryString["mail"].ToString());
Response.Redirect("../pages/Main.aspx");
}
