private void GetRecords(int Id)
{
DataTable table = BAL_location.GetCMSByCMSId(Id);
{
txtLocationName.Text = Convert.ToString(table.Rows[0]["LocationName"]);
txtLocationdetails.Text = Convert.ToString(table.Rows[0]["LocationDetails"]);
txtPhoneNumber.Text = Convert.ToString(table.Rows[0]["Phonenumber"]);
txtCellNumber.Text = Convert.ToString(table.Rows[0]["Cellnumber"]);
txtEmailAddress.Text = Convert.ToString(table.Rows[0]["EmailAddress"]);
}
}
protected void btnInActive_Click(object sender, EventArgs e)
{
if (BAL_location.ActivateRecords(ReturnIds(), 2) == true)
{
ShowMessage("Record Deactivated succefully");
FillGrid();
}
else
{
ShowMessage("Error in record deactivation.");
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (BAL_location.DeleteRecords(ReturnIds()) == true)
{
ShowMessage("Record Deleted Successfully.");
FillGrid();
}
else
{
ShowMessage("Error in record deletion.");
}
}
protected void imgbtn_Insert_Click(object sender, EventArgs e)
{
if (ValidateInput() == false)
{
Page.Validate("AddCategory");
if (Page.IsValid == true)
{
txtLocationName.Text = Server.HtmlEncode(txtLocationName.Text);
if (!string.IsNullOrEmpty(lblMode.Text))
{
if (BAL_location.UpdateCMS(Convert.ToInt32(lblMode.Text), txtLocationName.Text, txtLocationdetails.Text, txtPhoneNumber.Text, txtCellNumber.Text, txtEmailAddress.Text, "0") == true)
{
ShowMessage("Record Updated Susseccfully.");
FillGrid();
ClearInput();
}
else
{
ShowMessage("Error in record updation.");
}
}
else
{
if (BAL_location.InsertCMS(txtLocationName.Text, txtLocationdetails.Text, txtPhoneNumber.Text, txtCellNumber.Text, txtEmailAddress.Text, "0") == true)
{
ShowMessage("Record Inserted Susseccfully.");
FillGrid();
ClearInput();
}
else
{
ShowMessage("Error in record insertion.");
}
}
}
else
{
ShowMessage("Some Required Field Missing");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = BAL_location.GetCMSByCMSId(-10);
ddlBranchName.DataSource = dt;
ddlBranchName.DataValueField = dt.Columns["LocationId"].ToString();
ddlBranchName.DataTextField = dt.Columns["LocationName"].ToString();
ddlBranchName.DataBind();
if (Session["AccountDetail"] == null)
{
Response.Redirect("~/AdminLogin.aspx");
}
else
{
FillGrid();
}
}
}
private void FillGrid()
{
int TotalCount;
gvAdminList.PageIndex = gvIndex;
DataTable table = BAL_location.GetCMSInfo(gvAdminList.PageIndex, gvAdminList.PageSize, gvAdminList.OrderBy, out TotalCount);
gvAdminList.VirtualItemCount = TotalCount;
gvAdminList.DataSource = table;
gvAdminList.DataBind();
if (gvAdminList.Rows.Count > 0)
{
lblsearch2.Visible = true;
ddlPerpage.Visible = true;
lable123.Visible = true;
}
else
{
lblsearch2.Visible = false;
ddlPerpage.Visible = false;
lable123.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["AccountDetail"] != null)
{
FillGrid(1);
//get the brach information
DataTable dt = BAL_location.GetCMSByCMSId(-10);
ddlBranchName.DataSource = dt;
ddlBranchName.DataValueField = dt.Columns["LocationId"].ToString();
ddlBranchName.DataTextField = dt.Columns["LocationName"].ToString();
ddlBranchName.DataBind();
ddlBranchName.Items.Insert(0, new ListItem("All", "0"));
chkIsClosed.Checked = false;
}
else
{
Response.Redirect("~/AdminLogin.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
log.Debug("Into IsPostBack");
imgCarPhoto.Src = "~/getcarimage.aspx";
////get the brach information
//DataTable dtLocation = BAL_location.GetCMSByCMSId(0);
//string strBranchinformation = dtLocation.Rows[0]["LocationName"].ToString();
//hdnId.Value = dtLocation.Rows[0]["LocationId"].ToString();
DataTable dt = BAL_location.GetCMSByCMSId(0);
DataRow tdr = dt.NewRow();
tdr[0] = "0";
tdr[1] = "Please select";
dt.Rows.InsertAt(tdr, 0);
ddlChooseBranch.DataSource = dt;
ddlChooseBranch.DataValueField = dt.Columns["LocationId"].ToString();
ddlChooseBranch.DataTextField = dt.Columns["LocationName"].ToString();
ddlChooseBranch.DataBind();
Session["branchname"] = ddlChooseBranch.SelectedItem.Text;
DataTable dtBrachtiming = BAL_branchtime.GetTiming(ddlChooseBranch.SelectedItem.Value);
ViewState["LocationData"] = dtBrachtiming;
ddlAvailabletimeslot.Items.Clear();
ddlChoosedate.Items.Clear();
// date selection
//ddlChoosedate.Items.Add(new ListItem("Please select date", "-1"));
DataTable dtApDate = new DataTable();
dtApDate.Columns.Add("ApDate", Type.GetType("System.DateTime"));
DataTable dtAppBlockDate = new DataTable();
dtAppBlockDate = BALBlockedAppointments.SelectBlockAppointment("appstatus", 0, int.Parse(ddlChooseBranch.SelectedItem.Value));
ViewState["BlockDate"] = dtAppBlockDate;
for (int selecteddate = 0; selecteddate < 14; selecteddate++)
{
foreach (DataRow dr in dtBrachtiming.Rows)
{
if (dr["WorkingHoursFrom"].ToString() != dr["WorkingHoursTo"].ToString())
{
//select the date using the week
string strDay = dr["WorkingDay"].ToString();
DateTime currentdate = System.DateTime.Now;
currentdate = currentdate.AddDays(selecteddate);
//Response.Write("<br>" + currentdate.Date.DayOfWeek.ToString().ToLower() + " " + strDay.ToString().ToLower());
//check the blockdate
Boolean Isblocked = false;
foreach (DataRow item in dtAppBlockDate.Rows)
{
//if (Convert.ToDateTime(item["appdate"].ToString()) == currentdate)
if (Convert.ToDateTime(item["appdate"].ToString()).ToShortDateString() == currentdate.ToShortDateString())
{
if (item["op"].ToString().ToLower() == "Restrict".ToLower())
{
Isblocked = true;
}
}
}
if (currentdate.Date.DayOfWeek.ToString().ToLower() == strDay.ToLower())
{
if (!Isblocked)
{
if (Session["branchname"].ToString().ToLower() == "swansea")
{
if (currentdate.CompareTo(DateTime.Parse("02/12/2013")) <= 0)
{
DataRow drAp = dtApDate.NewRow();
drAp["ApDate"] = currentdate.ToShortDateString();
dtApDate.Rows.Add(drAp);
}
}
else
{
DataRow drAp = dtApDate.NewRow();
drAp["ApDate"] = currentdate.ToShortDateString();
dtApDate.Rows.Add(drAp);
}
}
}
}
}
}
DataView dvAp = dtApDate.DefaultView;
dvAp.Sort = "Apdate ASC";
foreach (DataRowView item in dvAp)
{
ddlChoosedate.Items.Add(new ListItem(((DateTime)item[0]).ToShortDateString(), ((DateTime)item[0]).Date.ToShortDateString()));
}
ddlChoosedate.Items.Insert(0, new ListItem("Please select date", "-1"));
//timing selection
ddlAvailabletimeslot.Items.Insert(0, new ListItem("Please select time", "-1"));
}
ddlAvailabletimeslot.Visible = true;
spanBooked.Visible = false;
hlCarButton.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = BAL_location.GetCMSByCMSId(-10);
ddlBranchName.DataSource = dt;
ddlBranchName.DataValueField = dt.Columns["LocationId"].ToString();
ddlBranchName.DataTextField = dt.Columns["LocationName"].ToString();
ddlBranchName.DataBind();
//load the previous value in dropdown
dt = BAL_branchtime.GetTiming(ddlBranchName.SelectedItem.Value);
foreach (DataRow item in dt.Rows)
{
string[] strFrom = item["WorkingHoursFrom"].ToString().Split(' ');
string[] strTo = item["WorkingHoursTo"].ToString().Split(' ');
switch (item["WorkingDay"].ToString())
{
case "Monday":
ddlMondayFrom.SelectedValue = strFrom[0];
ddlMondayFromAMPM.SelectedValue = strFrom[1];
ddlMondayTo.SelectedValue = strTo[0];
ddlMondayToAMPM.SelectedValue = strTo[1];
break;
case "Tuesday":
ddlTuesdayFrom.SelectedValue = strFrom[0];
ddlTuesdayFromAMPM.SelectedValue = strFrom[1];
ddlTuesdayTo.SelectedValue = strTo[0];
ddlTuesdayToAMPM.SelectedValue = strTo[1];
chkBranchClosedTue.Checked = Convert.ToBoolean(item["IsClosed"]);
break;
case "Wednesday":
ddlWednesdayFrom.SelectedValue = strFrom[0];
ddlWednesdayFromAMPM.SelectedValue = strFrom[1];
ddlWednesdayTo.SelectedValue = strTo[0];
ddlWednesdayToAMPM.SelectedValue = strTo[1];
chkBranchClosedWed.Checked = Convert.ToBoolean(item["IsClosed"]);
break;
case "Thursday":
ddlThursdayFrom.SelectedValue = strFrom[0];
ddlThursdayFromAMPM.SelectedValue = strFrom[1];
ddlThursdayTo.SelectedValue = strTo[0];
ddlThursdayToAMPM.SelectedValue = strTo[1];
chkBranchClosedThu.Checked = Convert.ToBoolean(item["IsClosed"]);
break;
case "Friday":
ddlFridayFrom.SelectedValue = strFrom[0];
ddlFridayFromAMPM.SelectedValue = strFrom[1];
ddlFridayTo.SelectedValue = strTo[0];
ddlFridayToAMPM.SelectedValue = strTo[1];
chkBranchClosedFri.Checked = Convert.ToBoolean(item["IsClosed"]);
break;
case "Saturday":
ddlSaturdayFrom.SelectedValue = strFrom[0];
ddlSaturdayFromAMPM.SelectedValue = strFrom[1];
ddlSaturdayTo.SelectedValue = strTo[0];
ddlSaturdayToAMPM.SelectedValue = strTo[1];
chkBranchClosedSat.Checked = Convert.ToBoolean(item["IsClosed"]);
break;
case "Sunday":
ddlSundayFrom.SelectedValue = strFrom[0];
ddlSundayFromAMPM.SelectedValue = strFrom[1];
ddlSundayTo.SelectedValue = strTo[0];
ddlSundayToAMPM.SelectedValue = strTo[1];
chkBranchClosedSun.Checked = Convert.ToBoolean(item["IsClosed"]);
break;
}
}
}
}
