private void FillGrid()
{
gvAdminList.DataSource = null;
DataTable table = BAL_BookAppointment.GetAppointment("0", "0", "0", int.Parse(ddlBranchName.SelectedItem.Value));
gvAdminList.DataSource = table;
gvAdminList.DataBind();
}
protected void gvAdminList_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
// get the categoryID of the clicked row
int categoryID = Convert.ToInt32(e.CommandArgument);
// Delete the record
//BAL_BookAppointment.UpdateAppointment(categoryID.ToString(), "", "", "", "", "", "", "1", "delete", "");
BAL_BookAppointment.UpdateAppointment(categoryID.ToString(), "1", "1", "1", "1", "1/1/1900", "1 PM", "1", "delete", "", 0);
//FillGrid();
Response.Redirect("appointmentlist.aspx");
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
string strAppointmentId = hdnAppointmentId.Value;
string strCustomerName = "";
string phonenumber = "";
string emailaddress = "0";
string zipcode = "";
string carplate = "";
BAL_BookAppointment.UpdateAppointment(strAppointmentId, strCustomerName, phonenumber, emailaddress, zipcode, ddlChoosedate.SelectedItem.Text.ToString(), ddlAvailabletimeslot.SelectedItem.Text.ToString(), "0", carplate, "0", 0);
lblMessage.Text = "Appointment Updated";
FillGrid();
this.mdlPopup.Show();
}
protected void btnBookanAppointment_click(object sender, EventArgs e)
{
if (Page.IsValid)
{
string strCustomerName = txtCustomerName.Text.Trim();
string phonenumber = txtPhone.Text.Trim();
string emailaddress = txtEmail.Text.Trim();
string zipcode = txtZipcode.Text.Trim();
string carplate = txtRegistration.Text.Trim();
string carValuation = lblCarValuation.Text.Trim();
BAL_BookAppointment.UpdateAppointment("0", strCustomerName, phonenumber, emailaddress, zipcode, ddlChoosedate.SelectedItem.Text.ToString(), ddlAvailabletimeslot.SelectedItem.Text.ToString(), "0", carplate, carValuation, int.Parse(ddlBranchName.SelectedItem.Value));
try { Utilities.RemoveFollowup(txtEmail.Text.Trim().ToLower()); }
catch (Exception ex)
{
}
lblError.Text = "Appointment booking succesfully";
}
}
protected void hlCarButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
trError.Visible = false;
if (Session["userdata"] != null)
{
string strCustomerName = Convert.ToString(Session["CustomerName"]);
string phonenumber = Convert.ToString(Session["Phonenumber"]);
string emailaddress = Convert.ToString(Session["EmailAddress"]);
string zipcode = Convert.ToString(Session["PostCode"]);
string carplate = Convert.ToString(Session["CarPlate"]);
string carValuation = Convert.ToString(Session["Valuation"]);
//Response.Write("Customer Name" + strCustomerName + "<br> Phone number" + phonenumber + " <br> Email " + emailaddress + " <br> Zipcode" + zipcode + "<br> CarPlate" + carplate);
BAL_BookAppointment.UpdateAppointment("0", strCustomerName, phonenumber, emailaddress, zipcode, ddlChoosedate.SelectedItem.Text.ToString(), ddlAvailabletimeslot.SelectedItem.Text.ToString(), "0", carplate, carValuation, int.Parse(ddlChooseBranch.SelectedItem.Value));
Session["appdate"] = ddlChoosedate.SelectedItem.Text;
Session["apptime"] = ddlAvailabletimeslot.SelectedItem.Text;
/*email send code*/
//Appointment Confirmation Email
String strCustFileName = Server.MapPath("~/MailContent") + "\\appconfirmation.html";
if (Session["branchname"] != null)
{
if (Session["branchname"].ToString().ToLower().Trim() == "bridgend")
{
strCustFileName = Server.MapPath("~/MailContent") + "\\bridgend-appconfirmation.html";
}
else if (Session["branchname"].ToString().ToLower().Trim() == "bristol")
{
strCustFileName = Server.MapPath("~/MailContent") + "\\bristol-appconfirmation.html";
}
else if (Session["branchname"].ToString().ToLower().Trim() == "cardiff")
{
strCustFileName = Server.MapPath("~/MailContent") + "\\cardiff-appconfirmation.html";
}
else if (Session["branchname"].ToString().ToLower().Trim() == "swindon")
{
strCustFileName = Server.MapPath("~/MailContent") + "\\swindon-appconfirmation.html";
}
}
System.IO.StreamReader srCustHTML = new System.IO.StreamReader(strCustFileName);
System.Text.StringBuilder sbMessage = new System.Text.StringBuilder(srCustHTML.ReadToEnd());
srCustHTML.Close();
sbMessage.Replace("@title", Convert.ToString(Session["saluation"]));
sbMessage.Replace("@surname", Convert.ToString(Session["Lastname"]));
sbMessage.Replace("@valuation", Convert.ToString(Session["CarValuation"]));
sbMessage.Replace("@apptime", Convert.ToString(Session["apptime"]).Replace(" ", string.Empty));
sbMessage.Replace("@appdate", Convert.ToString(Session["appdate"]));
sbMessage.Replace("@branch", Convert.ToString(Session["branchname"]));
sbMessage.Replace("@carnumber", Convert.ToString(Session["CarPlate"]));
sbMessage.Replace("@registration", ((clsCarselection)(Session["userdata"])).Registration);
sbMessage.Replace("@vehicle", ((clsCarselection)(Session["userdata"])).Model);
sbMessage.Replace("@mileage", ((clsCarselection)(Session["userdata"])).cs2_CurrentMileage);
sbMessage.Replace("@footerValue", BAL_CMS.GetDetailsByLinkName("Home Page Footer"));
string brnchEmailAddress = string.Empty;
string ccEmail = string.Empty;
switch (Session["branchname"].ToString().ToLower().Trim())
{
case "bridgend":
sbMessage.Replace("@officenumber", ConfigurationManager.AppSettings["Bridgend_Phone"].ToString());
sbMessage.Replace("@address", ConfigurationManager.AppSettings["Bridgend_Address"].ToString());
brnchEmailAddress = ConfigurationManager.AppSettings["adminEmailAddress"].ToString();
ccEmail = ConfigurationManager.AppSettings["Cardiff_Email"].ToString();
break;
case "cardiff":
brnchEmailAddress = ConfigurationManager.AppSettings["Cardiff_Email"].ToString();
sbMessage.Replace("@officenumber", ConfigurationManager.AppSettings["Cardiff_Phone"].ToString());
sbMessage.Replace("@address", ConfigurationManager.AppSettings["Cardiff_Address"].ToString());
ccEmail = ConfigurationManager.AppSettings["adminEmailAddress"].ToString();
break;
case "swansea":
brnchEmailAddress = ConfigurationManager.AppSettings["Swansea_Email"].ToString();
sbMessage.Replace("@officenumber", ConfigurationManager.AppSettings["Swansea_Phone"].ToString());
sbMessage.Replace("@address", ConfigurationManager.AppSettings["Swansea_Address"].ToString());
ccEmail = ConfigurationManager.AppSettings["adminEmailAddress"].ToString();
break;
case "newport":
brnchEmailAddress = ConfigurationManager.AppSettings["Newport_Email"].ToString();
sbMessage.Replace("@officenumber", ConfigurationManager.AppSettings["Newport_Phone"].ToString());
sbMessage.Replace("@address", ConfigurationManager.AppSettings["Newport_Address"].ToString());
ccEmail = ConfigurationManager.AppSettings["adminEmailAddress"].ToString();
break;
case "bristol":
brnchEmailAddress = ConfigurationManager.AppSettings["Bristol_Email"].ToString();
sbMessage.Replace("@officenumber", ConfigurationManager.AppSettings["Bristol_Phone"].ToString());
sbMessage.Replace("@address", ConfigurationManager.AppSettings["Bristol_Address"].ToString());
ccEmail = ConfigurationManager.AppSettings["adminEmailAddress"].ToString();
break;
case "gloucester":
brnchEmailAddress = ConfigurationManager.AppSettings["gloucester_email"].ToString();
sbMessage.Replace("@officenumber", ConfigurationManager.AppSettings["gloucester_phone"].ToString());
sbMessage.Replace("@address", ConfigurationManager.AppSettings["gloucester_address"].ToString());
ccEmail = ConfigurationManager.AppSettings["adminEmailAddress"].ToString();
break;
case "swindon":
brnchEmailAddress = ConfigurationManager.AppSettings["swindon_email"].ToString();
sbMessage.Replace("@officenumber", ConfigurationManager.AppSettings["swindon_phone"].ToString());
sbMessage.Replace("@address", ConfigurationManager.AppSettings["swindon_address"].ToString());
ccEmail = ConfigurationManager.AppSettings["adminEmailAddress"].ToString();
break;
default:
brnchEmailAddress = "";
sbMessage.Replace("@officenumber", "01452835619");
sbMessage.Replace("@address", "");
ccEmail = ConfigurationManager.AppSettings["adminEmailAddress"].ToString();
break;
}
log.Debug("Sending appointment emails");
Utilities.SendMail(ConfigurationManager.AppSettings["adminEmailAddress"], brnchEmailAddress, "Appointment Confirmation Email " + ((clsCarselection)(Session["userdata"])).CarPlate, sbMessage.ToString(), ccEmail);
//Utilities.SendMail("*****@*****.**", "*****@*****.**", "Appointment Confirmation Email " + ((clsCarselection)(Session["userdata"])).CarPlate, sbMessage.ToString());
Utilities.SendMail(ConfigurationManager.AppSettings["adminEmailAddress"], Convert.ToString(Session["EmailAddress"]), "Appointment Confirmation Email " + ((clsCarselection)(Session["userdata"])).CarPlate, sbMessage.ToString(), string.Empty);
/*email send code*/
Utilities.RemoveFollowup(emailaddress);
Response.Redirect("~/appointment_confirmation.aspx");
lblError.Text = "Appointment booking succesfully";
}
else
{
trError.Visible = true;
lblError.Text = "Please contact your Administrator";
}
}
}
