protected void Button2_Click(object sender, EventArgs e)
{
Booking mybook = new Booking();
mybook.StartTime = TextBox1.Text;
mybook.EndTime = TextBox2.Text;
mybook.BookingCode = Label13.Text;
mybook.ActualStartDate = Convert.ToDateTime(TextBoxDate.Text); // Convert.ToDateTime(DropDownList4.SelectedValue + "/" + DropDownList3.SelectedValue + "/" + DropDownList5.SelectedValue);
mybook.ExpectedEndDate = Convert.ToDateTime(TextBox6.Text); // Convert.ToDateTime(DropDownList8.SelectedValue + "/" + DropDownList7.SelectedValue + "/" + DropDownList9.SelectedValue);
mybook.BookingDescription = TextBox3.Text;
TimeSpan dur = Convert.ToDateTime(TextBox2.Text) - Convert.ToDateTime(TextBox1.Text);
mybook.Duration = dur;
mybook.BookingStatus = "Pending";
myctx.Bookings.InsertOnSubmit(mybook);
myctx.SubmitChanges();
//if (DropDownList6.Text == "Other")
//{
// TextBox5.Visible = true;
// ServiceB myserb = new ServiceB();
// myserb.ServiceName = DropDownList4.Text;
// myctx.ServiceBs.InsertOnSubmit(myserb);
// myctx.SubmitChanges();
//}
//else
//{
// TextBox4.Visible = false;
//}
ExeSecrataryAssign newassign = new ExeSecrataryAssign();
var bookin = from a in myctx.Bookings
orderby a.BookingID descending
select a;
if (bookin.Count() != 0)
{
var boo = bookin.First();
newassign.bookID = boo.BookingID;
newassign.DateOfAssignment = DateTime.Now;
newassign.ExeSecrataryID = Convert.ToInt16(Label9.Text);
newassign.ServiceProviderID = Convert.ToInt16(DropDownList10.SelectedValue);
newassign.ServiceID = Convert.ToInt16(DropDownList6.SelectedValue);
myctx.ExeSecrataryAssigns.InsertOnSubmit(newassign);
myctx.SubmitChanges();
}
ServiceProviderAssignment spassign = new ServiceProviderAssignment();
spassign.ServiceProviderID = Convert.ToInt16(DropDownList10.SelectedValue);
spassign.StartDateAssigned = Convert.ToDateTime(TextBox1.Text);
spassign.ENDDATEASSIGNED = Convert.ToDateTime(TextBox2.Text);
DateTime dt = Convert.ToDateTime(TextBoxDate.Text);//Convert.ToDateTime(DropDownList4.SelectedValue + "/" + DropDownList3.SelectedValue + "/" + DropDownList5.SelectedValue);
DateTime ed = Convert.ToDateTime(TextBox6.Text);
spassign.StartDateAssigned = dt;
spassign.ENDDATEASSIGNED = ed;
myctx.ServiceProviderAssignments.InsertOnSubmit(spassign);
myctx.SubmitChanges();
Response.Write("<script>alert('Your Booking has been done successfully');</script>");
Response.Redirect("~\\Executive Secratary\\SchedualOfBookedService.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
Booking mybook = new Booking();
mybook.BookingCode = Label11.Text;
mybook.StartTime = TextBoxST.Text;
mybook.EndTime = TextBoxED.Text;
mybook.ActualStartDate = Convert.ToDateTime(TextBox4.Text);
mybook.ExpectedEndDate = Convert.ToDateTime(TextBox5.Text);
// mybook.BookingDescription = .Text;
mybook.BookingDescription = BookingDL.SelectedValue;
TimeSpan dur = Convert.ToDateTime(TextBoxED.Text) - Convert.ToDateTime(TextBoxST.Text);
mybook.Duration = dur;
mybook.BookingStatus = "Pending";
myctx.Bookings.InsertOnSubmit(mybook);
myctx.SubmitChanges();
var bookID = from id in myctx.Bookings
orderby id.BookingID descending
select id;
if (bookID.Count() != 0)
{
var IDb = bookID.First();
}
//if (DropDownListServices.Text == "Other")
//{
// TextBox3.Visible = true;
// ServiceB myserb1 = new ServiceB();
// myserb1.ServiceName = DropDownListServices.SelectedValue;
// myctx.ServiceBs.InsertOnSubmit(myserb1);
// myctx.SubmitChanges();
//}
//else
//{
// TextBox3.Visible = false;
//}
SupervisorAssign newassign = new SupervisorAssign();
var bookin = from a in myctx.Bookings
orderby a.BookingID descending
select a;
if (bookin.Count() != 0)
{
var boo = bookin.First();
newassign.bookID = boo.BookingID;
newassign.DateOfAssignment = DateTime.Now;
newassign.supervisorID = Convert.ToInt16(Label30.Text);
newassign.ServiceProviderID = Convert.ToInt16(DropDownList1.SelectedValue);
newassign.ServiceID = Convert.ToInt16(DropDownListServices.SelectedValue);
newassign.ExecID = Convert.ToInt16(BookingDL.SelectedValue);
myctx.SupervisorAssigns.InsertOnSubmit(newassign);
myctx.SubmitChanges();
}
ServiceProviderAssignment spassign = new ServiceProviderAssignment();
spassign.ServiceProviderID = Convert.ToInt16(DropDownList1.SelectedValue);
spassign.StartTime = TimeSpan.Parse(TextBoxST.Text);
spassign.EndTime = TimeSpan.Parse(TextBoxED.Text);
DateTime dt = Convert.ToDateTime(TextBox4.Text);
DateTime ed = Convert.ToDateTime(TextBox5.Text);
spassign.StartDateAssigned = dt;
spassign.ENDDATEASSIGNED = ed;
myctx.ServiceProviderAssignments.InsertOnSubmit(spassign);
myctx.SubmitChanges();
//ServiceB myserb = new ServiceB();
//myserb.ServiceName = DropDownListServices.Text;
//myctx.ServiceBs.InsertOnSubmit(myserb);
//myctx.SubmitChanges();
//var emp = from a in myctx.Employees
// where a.EmployeeType == "Executive"
// select new { name = a.FirstName + " " + a.LastName, a.EID };
//if (emp.Count() != 0)
//{
// BookingDL.DataSource = emp;
// BookingDL.DataTextField = "name";
// BookingDL.DataValueField = "EID";
// BookingDL.DataBind();
//}
Response.Redirect("~\\SupervisorFolder\\Service Provider Schedule.aspx");
}
