protected void RegisterBt_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Username.Text) && !string.IsNullOrEmpty(Password.Text) && !string.IsNullOrEmpty(Password2.Text) && !string.IsNullOrEmpty(Email.Text)) { using (CEntities db = new CEntities()) { Users reg = new Users(); reg.Email = Email.Text; reg.Username = Username.Text; if (Password.Text.Equals(Password2.Text)) { reg.Password = Password.Text; db.Users.Add(reg); db.SaveChanges(); Response.Write("<script language='javascript'>window.alert('You successfully registered');window.location='MainPage.aspx';</script>"); } else { lblMessagePass.Text = "Your passwords are not matching"; } } } else { lblMessage.Text = "Fields should be filled"; } }
protected void AddCust_Click(object sender, EventArgs e) { using (CEntities db = new CEntities()) { if (!string.IsNullOrEmpty(NameTxt.Text) && !string.IsNullOrEmpty(PhoneTxt.Text)) { Customer cus = new Customer(); cus.UserId = (int)Session["UserID"]; cus.Name = NameTxt.Text; cus.Mail = MailTxt.Text; cus.Phone = PhoneTxt.Text; cus.Adress = AddressTxt.Text; db.Customer.Add(cus); db.SaveChanges(); Response.Write("<script language='javascript'>window.alert('Customer is added');window.location='ListCustomer.aspx';</script>"); } else { Response.Write("<script language='javascript'>alert('Fill the required information')</script>;"); } } }
protected void UpdatePass_Click(object sender, EventArgs e) { string UId = Request.QueryString["uid"].ToString(); if (!string.IsNullOrEmpty(ConfirmPassTxt.Text) && !string.IsNullOrEmpty(NewPassTxt.Text)) { if (!ConfirmPassTxt.Text.Equals(NewPassTxt.Text)) { Response.Write("<script>alert('Passwords are not matching')</script>;"); } else { using (CEntities db = new CEntities()) { Users rec = db.Users.Where(a => a.PasswordResetId.ToString() == UId).FirstOrDefault(); if (rec != null) { rec.Password = NewPassTxt.Text; rec.PasswordResetId = null; db.SaveChanges(); Session["UserID"] = rec.Id; Session["Username"] = rec.Username; Response.Redirect("/MainPage.aspx"); } } } } }
protected void btnCalendarDetail_Click(object sender, EventArgs e) { using (CEntities db = new CEntities()) { string meetId = Request.QueryString["ID"].ToString(); Meeting meet = db.Meeting.Where(a => a.Id.ToString() == meetId).FirstOrDefault(); if (meet != null) { byte meetviaId = Convert.ToByte(dplMeetingVia.SelectedValue); byte meetdoneId = Convert.ToByte(dplMeetingDone.SelectedValue); int newCusId = Convert.ToInt16(dplCustomer.SelectedValue); if (!string.IsNullOrEmpty(txtDateStart.Text) && !string.IsNullOrEmpty(txtDateEnd.Text)) { meet.DateStart = Convert.ToDateTime(txtDateStart.Text); meet.DateEnd = Convert.ToDateTime(txtDateEnd.Text); } meet.CustomerId = newCusId; meet.MeetingDoneId = meetdoneId; meet.MeetingViaId = meetviaId; meet.Description = txtDesc.Text; meet.Whom = txtWhom.Text; db.SaveChanges(); Response.Redirect("/Calendar.aspx"); } } }
protected void UpdateProfile_Click(object sender, EventArgs e) { using (CEntities db = new CEntities()) { int userID = Convert.ToInt32(Session["UserID"]); Users rec = db.Users.Where(a => a.Id == userID).FirstOrDefault(); if (rec != null) { if (!string.IsNullOrEmpty(NewUsernameTxt.Text)) { rec.Username = NewUsernameTxt.Text; NewUsernameTxt.Text = ""; lblUsernameTxt.Text = rec.Username; } if (!string.IsNullOrEmpty(NewEMailTxt.Text)) { rec.Email = NewEMailTxt.Text; NewEMailTxt.Text = ""; lblEMailTxt.Text = rec.Email; } Response.Write("<script>alert('You updated your information successfully')</script>"); db.SaveChanges(); Session["Username"] = rec.Username; } } }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Delete") { using (CEntities db = new CEntities()) { int id = Convert.ToInt32(e.CommandArgument); Customer cus = db.Customer.Where(a => a.Id == id).FirstOrDefault(); List <Meeting> meetlist = db.Meeting.Where(a => a.CustomerId == id).ToList(); if (cus != null) { db.Customer.Remove(cus); foreach (Meeting m in meetlist) { db.Meeting.Remove(m); } db.SaveChanges(); } List_Customers(); } } }
protected void Page_Load(object sender, EventArgs e) { //changePassTxt.Text = "To change password: "******"/Login.aspx"); } else { lblUsernameTxt.Text = Session["Username"].ToString(); using (CEntities db = new CEntities()) { int userID = Convert.ToInt32(Session["UserID"]); Users rec = db.Users.Where(a => a.Id == userID).FirstOrDefault(); if (rec != null) { lblUsernameTxt.Text = rec.Username; lblEMailTxt.Text = rec.Email; } } } } }
protected void SavePassBtn_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(CurrentPasswordTxt.Text) && !string.IsNullOrEmpty(NewPassTxt.Text) && !string.IsNullOrEmpty(ConfirmPassTxt.Text)) { using (CEntities db = new CEntities()) { int userID = Convert.ToInt32(Session["UserID"]); Users rec = db.Users.Where(a => a.Id == userID).FirstOrDefault(); if (rec != null) { if (rec.Password.Equals(CurrentPasswordTxt.Text)) { if (NewPassTxt.Text.Equals(ConfirmPassTxt.Text)) { rec.Password = NewPassTxt.Text; db.SaveChanges(); Response.Write("<script>alert('Password is updated')</script>"); Response.Redirect("/Login.aspx"); } else { Response.Write("<script>alert('Passwords are not matching')</script>"); } } else { Response.Write("<script>alert('Password is wrong')</script>"); } } } } }
protected void Search_Click(object sender, EventArgs e) { List <VW_Meeting> list = null; using (CEntities db = new CEntities()) { list = db.VW_Meeting.Where(a => a.CustomerName == txtSearch.Text).ToList(); } rpt_demo.DataSource = list; rpt_demo.DataBind(); }
private void Delete() { using (CEntities db = new CEntities()) { Users rec = db.Users.Where(a => a.Username == txtLoginName.Text && a.Password == txtPassword.Text).FirstOrDefault(); if (rec != null) { db.Users.Remove(rec); db.SaveChanges(); } } }
private void NewAdd() { using (CEntities db = new CEntities()) { Users rec = new Users(); rec.Email = ""; rec.Username = ""; db.Users.Add(rec); db.SaveChanges(); } }
private List <Customer> List_Customers() { List <Customer> cuslist = null; using (CEntities db = new CEntities()) { int UId = (Int32)Session["UserID"]; cuslist = db.Customer.Where(a => a.UserId == UId).ToList(); } rpt_demo.DataSource = cuslist; rpt_demo.DataBind(); return(cuslist); }
private List <VW_Meeting> List_Meetings() { List <VW_Meeting> list = null; using (CEntities db = new CEntities()) { int UId = (Int32)Session["UserID"]; list = db.VW_Meeting.Where(a => a.UserId == UId).ToList(); } rpt_demo.DataSource = list; rpt_demo.DataBind(); return(list); }
private Users GetByID(int id) { Users rec = null; using (CEntities db = new CEntities()) { id = 1; rec = db.Users.Where(a => a.Id == id).FirstOrDefault(); if (rec != null) { } } return(rec); }
public List <NCalendar> GetVisitCalendar(string dateStart, string dateEnd) { List <NCalendar> retval = new List <NCalendar>(); DateTime? dStart = null; DateTime? dEnd = null; if (!string.IsNullOrEmpty(dateStart)) { dStart = Convert.ToDateTime(dateStart); } if (!string.IsNullOrEmpty(dateEnd)) { dEnd = Convert.ToDateTime(dateEnd).AddDays(1); } List <VW_Meeting> list = null; using (CEntities db = new CEntities()) { int UId = Convert.ToInt32(Session["UserID"]); DateTime ds = Convert.ToDateTime(dateStart); DateTime de = Convert.ToDateTime(dateEnd); list = db.VW_Meeting.Where(a => a.UserId == UId && a.DateStart >= ds && a.DateEnd <= de).ToList(); foreach (var item in list) { NCalendar tmp = new NCalendar(); tmp.id = item.Id; tmp.title = item.CustomerName; tmp.start = item.DateStart.ToString("yyyy-MM-dd HH:mm"); tmp.end = item.DateEnd.ToString("yyyy-MM-dd HH:mm"); tmp.editable = true; if (item.MeetingDoneId == 1) { tmp.color = "#FFB752";//TURUNCU } else if (item.MeetingDoneId == 2) { tmp.color = "#87B87F";//YEŞİL } else { tmp.color = "#B74635";//KIRMIZI } retval.Add(tmp); } } return(retval); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (!ISLOGIN) { Response.Redirect("/Login.aspx"); } else { string meetId = Request.QueryString["ID"].ToString(); int UId = (Int32)Session["UserID"]; dplMeetingDone.Items.Insert(0, new ListItem("Choose meeting status", "0")); dplMeetingDone.Items.Insert(1, new ListItem("Undefined", "1")); dplMeetingDone.Items.Insert(2, new ListItem("Done", "2")); dplMeetingDone.Items.Insert(3, new ListItem("Undone", "3")); dplMeetingVia.Items.Insert(0, new ListItem("Choose meeting type", "0")); dplMeetingVia.Items.Insert(1, new ListItem("Interview", "1")); dplMeetingVia.Items.Insert(2, new ListItem("Phone", "2")); dplMeetingVia.Items.Insert(3, new ListItem("E-Mail", "3")); using (CEntities db = new CEntities()) { Meeting meet = db.Meeting.Where(a => a.Id.ToString() == meetId).FirstOrDefault(); dplMeetingDone.SelectedValue = meet.MeetingDoneId.ToString(); dplMeetingVia.SelectedValue = meet.MeetingViaId.ToString(); lblDesc.Text = meet.Description; lblWhom.Text = meet.Whom; List <Customer> cuslist = db.Customer.Where(a => a.UserId == UId).ToList(); if (!cuslist.Any()) { Response.Write("<script language='javascript'>window.alert('You have to register customers');window.location='AddCustomer.aspx';</script>"); } dplCustomer.DataSource = cuslist; dplCustomer.DataTextField = "Name"; dplCustomer.DataValueField = "Id"; dplCustomer.DataBind(); } lblUsername.Text = Session["Username"].ToString(); } } }
protected void Repeater_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Delete") { using (CEntities db = new CEntities()) { int id = Convert.ToInt32(e.CommandArgument); Meeting meet = db.Meeting.Where(a => a.Id == id).FirstOrDefault(); if (meet != null) { db.Meeting.Remove(meet); db.SaveChanges(); } List_Meetings(); } } }
protected void Page_Load(object sender, EventArgs e) { string UId = Request.QueryString["uid"].ToString(); if (String.IsNullOrEmpty(Request.QueryString["uid"])) { Response.Redirect("/Login.aspx"); } else { using (CEntities db = new CEntities()) { Users rec = db.Users.Where(a => a.PasswordResetId.ToString() == UId).FirstOrDefault(); if (rec == null) { Response.AddHeader("The link is expired ", "URL=Login.aspx"); } } } }
protected void ResetPass_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(EMailTxt.Text)) { using (CEntities db = new CEntities()) { Users rec = db.Users.Where(a => a.Email == EMailTxt.Text).FirstOrDefault(); if (rec != null) { rec.PasswordResetId = Guid.NewGuid(); db.SaveChanges(); SendPasswordResetEmail(rec.Email, rec.Username, rec.PasswordResetId.ToString()); } else { Response.Write("<script>alert('User not found')</script>;"); } } } }
protected void AddMeeting_Click(object sender, EventArgs e) { using (CEntities db = new CEntities()) { if (!string.IsNullOrEmpty(txtDateStart.Text) && !string.IsNullOrEmpty(txtduration.Text)) { int UId = (Int32)Session["UserID"]; Meeting meet = new Meeting(); byte meetviaId = Convert.ToByte(dplMeetingVia.SelectedValue); byte meetdoneId = Convert.ToByte(dplMeetingDone.SelectedValue); int newCusId = Convert.ToInt16(dplCustomer.SelectedValue); int duration = Convert.ToInt32(txtduration.Text); meet.UserId = UId; meet.CustomerId = newCusId; meet.DateStart = Convert.ToDateTime(txtDateStart.Text); meet.DateEnd = meet.DateStart.AddMinutes(duration); if (!string.IsNullOrEmpty(txtDesc.Text) && !string.IsNullOrEmpty(txtWhom.Text)) { meet.Description = txtDesc.Text; meet.Whom = txtWhom.Text; } meet.MeetingViaId = meetviaId; meet.MeetingDoneId = meetdoneId; db.Meeting.Add(meet); db.SaveChanges(); Response.Write("<script language='javascript'>window.alert('Meeting is created');window.location='ListMeeting.aspx';</script>"); } else { Response.Write("<script language='javascript'>alert('Fill the required information')</script>;"); } } }
public string FirmVisitUpdateEventResize(string id, string milliseconds) { string retval = "Yetkisiz İşlem"; using (CEntities db = new CEntities()) { int ID = Convert.ToInt32(id); Meeting rec = db.Meeting.Where(a => a.Id == ID).FirstOrDefault(); if (rec != null) { rec.DateEnd = rec.DateEnd.AddMilliseconds(Convert.ToDouble(milliseconds)); db.SaveChanges(); retval = "OK"; } else { retval = "Kayıt bulunamadı!"; } return(retval); } }
public string NewVisit(string date, string duration, string customerID, string isMonth) { string retval = "NOK"; DateTime dStart = Convert.ToDateTime(date); short dDuration = Convert.ToInt16(duration); using (CEntities db = new CEntities()) { Meeting rec = new Meeting(); rec.UserId = Convert.ToInt32(Session["UserID"]); rec.CustomerId = Convert.ToInt32(customerID); rec.DateStart = dStart; rec.DateEnd = dStart.AddMinutes(dDuration); rec.MeetingViaId = 1; rec.MeetingDoneId = 1; db.Meeting.Add(rec); db.SaveChanges(); } retval = "OK"; return(retval); }
private void GoLogin() { if (!string.IsNullOrEmpty(txtLoginName.Text) && !string.IsNullOrEmpty(txtPassword.Text)) { using (CEntities db = new CEntities()) { Users rec = db.Users.Where(a => a.Email == txtLoginName.Text && a.Password == txtPassword.Text).FirstOrDefault(); if (rec != null) { Session["UserID"] = rec.Id; Session["Username"] = rec.Username; if (chkRememberMe.Checked) { Response.Cookies["Username"].Value = txtLoginName.Text; Response.Cookies["Password"].Value = txtPassword.Text; Response.Cookies["Username"].Expires = DateTime.MaxValue; Response.Cookies["Password"].Expires = DateTime.MaxValue; } else { Response.Cookies["Username"].Expires = DateTime.Now.AddDays(-1); Response.Cookies["Password"].Expires = DateTime.Now.AddDays(-1); } Response.Redirect("/MainPage.aspx"); } else { lblMessage.Text = "Could not found"; //Response.Write("<script>alert('Could not found')</script>;"); } } } }
public string FirmVisitUpdateEventDrop(string id, string milliseconds, string days) { string retval = "Yetkisiz İşlem"; using (CEntities db = new CEntities()) { int mId = Convert.ToInt32(id); //List<Meeting> list = db.Meeting.Where(a => a.CustomerId == Convert.ToInt32(id)).ToList(); Meeting m = db.Meeting.Where(a => a.Id == mId).FirstOrDefault(); if (m != null) { m.DateStart = m.DateStart.AddDays(Convert.ToInt32(days)).AddMilliseconds(Convert.ToDouble(milliseconds)); m.DateEnd = m.DateEnd.AddDays(Convert.ToInt32(days)).AddMilliseconds(Convert.ToDouble(milliseconds)); db.SaveChanges(); retval = "OK"; } else { retval = "Kayıt bulunamadı!"; } return(retval); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (!ISLOGIN) { Response.Redirect("/Login.aspx"); } else { lblUsername.Text = Session["Username"].ToString(); using (CEntities db = new CEntities()) { DateTime dts = DateTime.Now.Date; DateTime dte = DateTime.Now.Date.AddDays(2); int UId = Convert.ToInt16(Session["UserID"]); List <VW_Meeting> rec = db.VW_Meeting.Where(a => a.DateStart >= dts && a.DateStart < dte && a.UserId == UId).ToList(); rpt_demo.DataSource = rec; rpt_demo.DataBind(); } //yada //using (CEntities db = new CEntities()) //{ // int UserID = Convert.ToInt32(Session["UserID"]); // Users rec = db.Users.Where(a => a.Id == UserID).FirstOrDefault(); // if (rec != null) // { // lblUserName.Text = rec.Username; // } //} } } }