public bool funcRegister(string Name, string Surname, string City, string Phone, string Email, string Address, string Password)
{
bool boolCheck = false;
using (semantıcEntities Bitirme = new semantıcEntities())
{
USER UserCheck = (from info in Bitirme.USER
where info.Email == Email
select info).SingleOrDefault();
if (UserCheck != null)
{
boolCheck = false;
}
else
{
USER UserNew = new USER();
UserNew.Name = Name;
UserNew.Surname = Surname;
UserNew.City = City;
UserNew.Phone = Phone;
UserNew.Email = Email;
UserNew.Address = Address;
UserNew.Password = Password;
UserNew.IsActive = Convert.ToBoolean("True");
Bitirme.USER.Add(UserNew);
Bitirme.SaveChanges();
boolCheck = true;
}
}
return(boolCheck);
}
protected void grdList_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label id = (Label)grdList.Rows[e.RowIndex].FindControl("lblUserID");
TextBox name = (TextBox)grdList.Rows[e.RowIndex].FindControl("txtName");
TextBox surname = (TextBox)grdList.Rows[e.RowIndex].FindControl("txtSurname");
TextBox emailaddress = (TextBox)grdList.Rows[e.RowIndex].FindControl("txtEMailAddress");
TextBox phone = (TextBox)grdList.Rows[e.RowIndex].FindControl("txtPhone");
TextBox address = (TextBox)grdList.Rows[e.RowIndex].FindControl("txtAddress");
TextBox city = (TextBox)grdList.Rows[e.RowIndex].FindControl("txtCity");
TextBox password = (TextBox)grdList.Rows[e.RowIndex].FindControl("txtPassword");
semantıcEntities db = new semantıcEntities();
int id1 = Convert.ToInt32(id.Text);
USER m = (from x in db.USER where x.UserID == id1 && x.IsActive == true select x).SingleOrDefault();
m.Name = name.Text;
m.Surname = surname.Text;
m.Email = emailaddress.Text;
m.Phone = phone.Text;
m.Address = address.Text;
m.City = city.Text;
m.Password = password.Text;
db.SaveChanges();
USER[] m1 = (from x in db.USER where x.IsActive == true select x).ToArray();
grdList.DataSource = m1;
grdList.DataBind();
}
protected void grdList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow row = (GridViewRow)grdList.Rows[e.RowIndex];
Label lbldeleteid = (Label)row.FindControl("lblID");
semantıcEntities db = new semantıcEntities();
int id = Convert.ToInt32(lbldeleteid.Text);
USER m = (from x in db.USER where x.UserID == id && x.IsActive == true select x).SingleOrDefault();
m.IsActive = false;
db.SaveChanges();
USER[] m1 = (from x in db.USER where x.IsActive == true select x).ToArray();
grdList.DataSource = m1;
grdList.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(TextBox1.Text) || String.IsNullOrEmpty(FileUpload1.FileName))
{
//uyarı ver
}
else
{
semantıcEntities db = new semantıcEntities();
DATASET d = new DATASET();
d.IsActive = true;
d.Name = TextBox1.Text;
//d.URL = Server.MapPath()
/*
* fuImage.SaveAs(Server.MapPath("~/Dataset/" + fuImage.FileName));
* d.URL = (Server.MapPath("~/Dataset/" + fuImage.FileName));
*/
db.DATASET.Add(d);
db.SaveChanges();
}
}