protected void DisplayServiceWindow(int varSiteId)
{
objSerWindow = objSerWindow.Get_By_id(varSiteId);
if (objSerWindow.Siteid != 0)
{
objSerHours = objSerHours.Get_By_id(objSerWindow.Servicewindowid);
if (objSerHours.Servicewindowid != 0)
{
if (objSerHours.Starthour == 0 && objSerHours.Startmin == 15 && objSerHours.Endhour == 23 && objSerHours.Endmin == 45)
{
rdbtn24hr.Checked = true;
rdbtnSelect.Checked = false;
}
else
{
rdbtn24hr.Checked = false;
rdbtnSelect.Checked = true;
drpStarthour.SelectedValue = Convert.ToString(objSerHours.Starthour);
drpStartmin.SelectedValue = Convert.ToString(objSerHours.Startmin);
drpEndhr.SelectedValue = Convert.ToString(objSerHours.Endhour);
drpEndmin.SelectedValue = Convert.ToString(objSerHours.Endmin);
}
}
colServiceDay = objSerDay.Get_All_By_Id(objSerWindow.Servicewindowid);
foreach (ServiceDay_mst service in colServiceDay)
{
string varServiceDay;
varServiceDay = service.Weekday.ToString();
if (varServiceDay == "Monday")
{
if (service.Isworking == true)
{
chkMonday.Checked = true;
}
else
{
chkMonday.Checked = false;
}
}
if (varServiceDay == "Tuesday")
{
if (service.Isworking == true)
{
chkTuesday.Checked = true;
}
else
{
chkTuesday.Checked = false;
}
}
if (varServiceDay == "Wednesday")
{
if (service.Isworking == true)
{
chkWednesday.Checked = true;
}
else
{
chkWednesday.Checked = false;
}
}
if (varServiceDay == "Thursday")
{
if (service.Isworking == true)
{
chkThursday.Checked = true;
}
else
{
chkThursday.Checked = false;
}
}
if (varServiceDay == "Friday")
{
if (service.Isworking == true)
{
chkFriday.Checked = true;
}
else
{
chkFriday.Checked = false;
}
}
if (varServiceDay == "Saturday")
{
if (service.Isworking == true)
{
chkSaturday.Checked = true;
}
else
{
chkSaturday.Checked = false;
}
}
if (varServiceDay == "Sunday")
{
if (service.Isworking == true)
{
chkSunday.Checked = true;
}
else
{
chkSunday.Checked = false;
}
}
}
}
else
{
DefaultSetting();
}
}
public int Update_Servicehours_mst_By_id(Servicehours_mst objServicehours)
{
return (int)ExecuteNonQuery(Sp_Servicehours_Update, new object[] { objServicehours.Startmin, objServicehours.Starthour, objServicehours.Servicewindowid, objServicehours.Endmin, objServicehours.Endhour });
}
public object GenerateServicehours_mstObject(ref IDataReader returnData)
{
Servicehours_mst obj = new Servicehours_mst();
while (returnData.Read())
{
obj.Servicewindowid = (int)returnData["Servicewindowid"];
obj.Starthour = (int)returnData["Starthour"];
obj.Startmin = (int)returnData["Startmin"];
obj.Endhour = (int)returnData["Endhour"];
obj.Endmin = (int)returnData["Endmin"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
public int Insert_Servicehours_mst(Servicehours_mst objServicehours)
{
return (int)ExecuteNonQuery(Sp_Servicehours_Insert, new object[] { objServicehours.Startmin, objServicehours.Starthour, objServicehours.Servicewindowid, objServicehours.Endmin, objServicehours.Endhour });
}
protected void DisplayServiceWindow(int varSiteId)
{
objSerWindow = objSerWindow.Get_By_id(varSiteId);
if (objSerWindow.Siteid != 0)
{
objSerHours = objSerHours.Get_By_id(objSerWindow.Servicewindowid);
if (objSerHours.Servicewindowid != 0)
{
if (objSerHours.Starthour == 0 && objSerHours.Startmin == 15 && objSerHours.Endhour == 23 && objSerHours.Endmin == 45)
{
rdbtn24hr.Checked = true;
rdbtnSelect.Checked = false;
}
else
{
rdbtn24hr.Checked = false;
rdbtnSelect.Checked = true;
drpStarthour.SelectedValue = Convert.ToString(objSerHours.Starthour);
drpStartmin.SelectedValue = Convert.ToString(objSerHours.Startmin);
drpEndhr.SelectedValue = Convert.ToString(objSerHours.Endhour);
drpEndmin.SelectedValue = Convert.ToString(objSerHours.Endmin);
}
}
colServiceDay = objSerDay.Get_All_By_Id(objSerWindow.Servicewindowid);
foreach (ServiceDay_mst service in colServiceDay)
{
string varServiceDay;
varServiceDay = service.Weekday.ToString();
if (varServiceDay == "Monday")
{
if (service.Isworking == true)
{
chkMonday.Checked = true;
}
else
{
chkMonday.Checked = false;
}
}
if (varServiceDay == "Tuesday")
{
if (service.Isworking == true)
{
chkTuesday.Checked = true;
}
else
{
chkTuesday.Checked = false;
}
}
if (varServiceDay == "Wednesday")
{
if (service.Isworking == true)
{
chkWednesday.Checked = true;
}
else
{
chkWednesday.Checked = false;
}
}
if (varServiceDay == "Thursday")
{
if (service.Isworking == true)
{
chkThursday.Checked = true;
}
else
{
chkThursday.Checked = false;
}
}
if (varServiceDay == "Friday")
{
if (service.Isworking == true)
{
chkFriday.Checked = true;
}
else
{
chkFriday.Checked = false;
}
}
if (varServiceDay == "Saturday")
{
if (service.Isworking == true)
{
chkSaturday.Checked = true;
}
else
{
chkSaturday.Checked = false;
}
}
if (varServiceDay == "Sunday")
{
if (service.Isworking == true)
{
chkSunday.Checked = true;
}
else
{
chkSunday.Checked = false;
}
}
}
}
else
{
DefaultSetting();
}
}
