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 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 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 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 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 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 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>;");
}
}
}
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();
}
}
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 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);
}
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);
}
}
