protected void Update()
{
int Slaid = Convert.ToInt32(Request.QueryString[0]);
objSla = objSla.Get_By_id(Slaid);
if (objSla.Slaid != 0)
{
int siteid = objSla.Siteid;
objSite = objSite.Get_By_id(siteid);
if (objSite.Siteid != 0)
{
lblSite.Text = objSite.Sitename;
}
txtSlaName.Text = objSla.Slaname.ToString().Trim();
txtDescription.Text = objSla.Description.ToString().Trim();
objSlaPriority = objSlaPriority.Get_By_id(objSla.Slaid);
if (objSlaPriority.Priorityid != 0)
{
objPriority = objPriority.Get_By_id(objSlaPriority.Priorityid);
if (objPriority.Priorityid != 0)
{
lblPriority.Text = objPriority.Name.ToString().Trim();
drphr.SelectedValue = Convert.ToString(objSlaPriority.Resolutionhours);
drpMin.SelectedValue = Convert.ToString(objSlaPriority.Resolutionmin);
txtDays.Text = Convert.ToString(objSlaPriority.Resolutiondays);
}
}
}
}
string GetSLAName(int slaid)
{
string SLAname = "";
objSLA = objSLA.Get_By_id(slaid);
if (objSLA.Slaid != 0)
{
SLAname = objSLA.Slaname;
}
return SLAname;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
bool FlagEscalateLevel1 = true;
bool FlagEscalateLevel2 = true;
bool FlagEscalateLevel3 = true;
lblErrorTimeSelect.Text = "";
if (txtDays.Text == "0" && drphr.SelectedValue == "0" && drpMin.SelectedValue == "0")
{
lblErrorTimeSelect.Text = Resources.MessageResource.errResTime.ToString();
}
else
{
if (chkLevel1.Checked == true)
{
if (radio1Level1.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel1 = calculateTotalminutesLevel1();
if (varTotalTimeLevel1 > varTotalTime)
{
FlagEscalateLevel1 = false;
}
}
if (radio2Level1.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel1 = calculateTotalminutesLevel1();
//if (varTotalTimeLevel1 < varTotalTime)
//{
// FlagEscalateLevel1 = false;
//}
}
}
if (chkLevel2.Checked == true)
{
if (radio1Level2.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel2 = calculateTotalminutesLevel2();
if (varTotalTimeLevel2 > varTotalTime)
{
FlagEscalateLevel2 = false;
}
}
if (radio2Level2.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel2 = calculateTotalminutesLevel2();
//if (varTotalTimeLevel2 < varTotalTime)
//{
// FlagEscalateLevel2 = false;
//}
}
}
if (chkLevel3.Checked == true)
{
if (radio1Level3.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel3 = calculateTotalminutesLevel3();
if (varTotalTimeLevel3 > varTotalTime)
{
FlagEscalateLevel3 = false;
}
}
if (radio2Level3.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel3 = calculateTotalminutesLevel3();
//if (varTotalTimeLevel3 < varTotalTime)
//{
// FlagEscalateLevel3 = false;
//}
}
}
int Slaid = Convert.ToInt32(Request.QueryString[0]);
objSla = objSla.Get_By_id(Slaid);
if (objSla.Slaid != 0)
{
if (FlagEscalateLevel1 == true && FlagEscalateLevel2 == true && FlagEscalateLevel3 == true)
{
if (chkLevel1.Checked == true)
{
UpdateLevel1Escalate(Slaid);
}
else
{
UncheckedLevel1Escalate(Slaid);
}
if (chkLevel2.Checked == true)
{
UpdateLevel2Escalate(Slaid);
}
else
{
UncheckedLevel2Escalate(Slaid);
}
if (chkLevel3.Checked == true)
{
UpdateLevel3Escalate(Slaid);
}
else
{
UncheckedLevel3Escalate(Slaid);
}
if (objSla.Slaname == txtSlaName.Text.ToString().Trim())
{
objSla.Description = txtDescription.Text.ToString().Trim();
objSlaPriority = objSlaPriority.Get_By_id(objSla.Slaid);
if (objSlaPriority.Slaid != 0)
{
objSlaPriority.Resolutiondays = Convert.ToInt32(txtDays.Text);
objSlaPriority.Resolutionhours = Convert.ToInt32(drphr.SelectedValue);
objSlaPriority.Resolutionmin = Convert.ToInt32(drpMin.SelectedValue);
objSla.Update();
objSlaPriority.Update();
Response.Redirect("~/admin/ViewSla.aspx");
}
}
else
{
SLA_mst objSLa1 = new SLA_mst();
objSLa1 = objSla.Get_By_SLAName(txtSlaName.Text.ToString().Trim(), objSla.Siteid);
if (objSLa1.Slaid == 0)
{
objSla.Slaname = txtSlaName.Text.ToString().Trim();
objSla.Description = txtDescription.Text.ToString().Trim();
objSlaPriority = objSlaPriority.Get_By_id(objSla.Slaid);
if (objSlaPriority.Slaid != 0)
{
objSlaPriority.Resolutiondays = Convert.ToInt32(txtDays.Text);
objSlaPriority.Resolutionhours = Convert.ToInt32(drphr.SelectedValue);
objSlaPriority.Resolutionmin = Convert.ToInt32(drpMin.SelectedValue);
objSla.Update();
objSlaPriority.Update();
Response.Redirect("~/admin/ViewSla.aspx");
}
}
else
{
lblErrorMsg.Text = Resources.MessageResource.errSLAExist.ToString();
}
}
}
else
{
if (FlagEscalateLevel1 == false)
{
lblErrorMsg.Text = Resources.MessageResource.strLevel1.ToString();
}
if (FlagEscalateLevel2 == false)
{
lblErrorMsg.Text = Resources.MessageResource.strLevel2.ToString();
}
if (FlagEscalateLevel3 == false)
{
lblErrorMsg.Text = Resources.MessageResource.strLevel3.ToString();
}
}
}
else
{
lblErrorMsg.Text = Resources.MessageResource.errOccured.ToString();
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
bool FlagEscalateLevel1 = true;
bool FlagEscalateLevel2 = true;
bool FlagEscalateLevel3 = true;
lblErrorTimeSelect.Text = "";
if (txtDays.Text == "0" && drphr.SelectedValue == "0" && drpMin.SelectedValue == "0")
{
lblErrorTimeSelect.Text = Resources.MessageResource.errResTime.ToString();
}
else
{
if (chkLevel1.Checked == true)
{
if (radio1Level1.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel1 = calculateTotalminutesLevel1();
if (varTotalTimeLevel1 > varTotalTime)
{
FlagEscalateLevel1 = false;
}
}
if (radio2Level1.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel1 = calculateTotalminutesLevel1();
//if (varTotalTimeLevel1 < varTotalTime)
//{
// FlagEscalateLevel1 = false;
//}
}
}
if (chkLevel2.Checked == true)
{
if (radio1Level2.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel2 = calculateTotalminutesLevel2();
if (varTotalTimeLevel2 > varTotalTime)
{ FlagEscalateLevel2 = false; }
}
if (radio2Level2.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel2 = calculateTotalminutesLevel2();
//if (varTotalTimeLevel2 < varTotalTime)
//{
// FlagEscalateLevel2 = false;
//}
}
}
if (chkLevel3.Checked == true)
{
if (radio1Level3.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel3 = calculateTotalminutesLevel3();
if (varTotalTimeLevel3 > varTotalTime)
{ FlagEscalateLevel3 = false; }
}
if (radio2Level3.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel3 = calculateTotalminutesLevel3();
//if (varTotalTimeLevel3 < varTotalTime)
//{
// FlagEscalateLevel3 = false;
//}
}
}
int Slaid = Convert.ToInt32(Request.QueryString[0]);
objSla = objSla.Get_By_id(Slaid);
if (objSla.Slaid != 0)
{
if (FlagEscalateLevel1 == true && FlagEscalateLevel2 == true && FlagEscalateLevel3 == true)
{
if (chkLevel1.Checked == true)
{
UpdateLevel1Escalate(Slaid);
}
else
{
UncheckedLevel1Escalate(Slaid);
}
if (chkLevel2.Checked == true)
{
UpdateLevel2Escalate(Slaid);
}
else
{
UncheckedLevel2Escalate(Slaid);
}
if (chkLevel3.Checked == true)
{
UpdateLevel3Escalate(Slaid);
}
else
{
UncheckedLevel3Escalate(Slaid);
}
if (objSla.Slaname == txtSlaName.Text.ToString().Trim())
{
objSla.Description = txtDescription.Text.ToString().Trim();
objSlaPriority = objSlaPriority.Get_By_id(objSla.Slaid);
if (objSlaPriority.Slaid != 0)
{
objSlaPriority.Resolutiondays = Convert.ToInt32(txtDays.Text);
objSlaPriority.Resolutionhours = Convert.ToInt32(drphr.SelectedValue);
objSlaPriority.Resolutionmin = Convert.ToInt32(drpMin.SelectedValue);
objSla.Update();
objSlaPriority.Update();
Response.Redirect("~/admin/ViewSla.aspx");
}
}
else
{
SLA_mst objSLa1 = new SLA_mst();
objSLa1 = objSla.Get_By_SLAName(txtSlaName.Text.ToString().Trim(), objSla.Siteid);
if (objSLa1.Slaid == 0)
{
objSla.Slaname = txtSlaName.Text.ToString().Trim();
objSla.Description = txtDescription.Text.ToString().Trim();
objSlaPriority = objSlaPriority.Get_By_id(objSla.Slaid);
if (objSlaPriority.Slaid != 0)
{
objSlaPriority.Resolutiondays = Convert.ToInt32(txtDays.Text);
objSlaPriority.Resolutionhours = Convert.ToInt32(drphr.SelectedValue);
objSlaPriority.Resolutionmin = Convert.ToInt32(drpMin.SelectedValue);
objSla.Update();
objSlaPriority.Update();
Response.Redirect("~/admin/ViewSla.aspx");
}
}
else
{
lblErrorMsg.Text = Resources.MessageResource.errSLAExist.ToString();
}
}
}
else
{
if (FlagEscalateLevel1 == false)
{
lblErrorMsg.Text = Resources.MessageResource.strLevel1.ToString();
}
if (FlagEscalateLevel2 == false)
{
lblErrorMsg.Text = Resources.MessageResource.strLevel2.ToString();
}
if (FlagEscalateLevel3 == false)
{
lblErrorMsg.Text = Resources.MessageResource.strLevel3.ToString();
}
}
}
else
{
lblErrorMsg.Text = Resources.MessageResource.errOccured.ToString();
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
// Declare local variable varsiteid,FlagInsertSla and FlagStatus
int varsiteid;
ServiceWindow_mst objservicewindow = new ServiceWindow_mst();
varsiteid = Convert.ToInt16(drpSites.SelectedValue);
int count = objservicewindow.Get_ServiceWindow_By_Siteid(varsiteid);
if (count >= 1)
{
int FlagInsertSla;
int FlagStatus;
bool FlagEscalateLevel1 = true;
bool FlagEscalateLevel2 = true;
bool FlagEscalateLevel3 = true;
lblErrorTimeSelect.Text = "";
if (txtDays.Text == "0" && drphr.SelectedValue == "0" && drpMin.SelectedValue == "0")
{
lblErrorTimeSelect.Text = Resources.MessageResource.errResTime.ToString();
}
else
{
if (chkLevel1.Checked == true)
{
if (radio1Level1.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel1 = calculateTotalminutesLevel1();
if (varTotalTimeLevel1 > varTotalTime)
{
FlagEscalateLevel1 = false;
}
}
if (radio2Level1.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel1 = calculateTotalminutesLevel1();
if (varTotalTimeLevel1 == 0)
{
FlagEscalateLevel1 = false;
}
}
}
if (chkLevel2.Checked == true)
{
if (radio1Level2.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel2 = calculateTotalminutesLevel2();
if (varTotalTimeLevel2 > varTotalTime)
{
FlagEscalateLevel2 = false;
}
}
if (radio2Level2.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel2 = calculateTotalminutesLevel2();
if (varTotalTimeLevel2 == 0)
{
FlagEscalateLevel2 = false;
}
}
}
if (chkLevel3.Checked == true)
{
if (radio1Level3.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel3 = calculateTotalminutesLevel3();
if (varTotalTimeLevel3 > varTotalTime)
{
FlagEscalateLevel3 = false;
}
}
if (radio2Level3.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel3 = calculateTotalminutesLevel3();
if (varTotalTimeLevel3 == 0)
{
FlagEscalateLevel3 = false;
}
}
}
// get sitetd from dropdown to variable varsiteid
// Check SLA Definition is exist in database with same name and site
objSla = objSla.Get_By_SLAName(txtSlaName.Text.ToString().Trim(), varsiteid);
// Check SLA Priority definition is exist in databse with siteid and priorityid
objSlaPriority = objSlaPriority.Get_By_Siteid(varsiteid, Convert.ToInt16(drpPriority.SelectedValue));
// if both objSla.Siteid and objSlaPriority.Slaid is zero then,No SLA Definition is exist in database
if (objSla.Siteid == 0 && objSlaPriority.Slaid == 0)
{
if (FlagEscalateLevel1 == true && FlagEscalateLevel2 == true && FlagEscalateLevel3 == true)
{
objSla.Siteid = varsiteid;
objSla.Slaname = txtSlaName.Text.ToString().Trim();
objSla.Createdatetime = DateTime.Now.ToString();
objSla.Enable = true;
objSla.Description = txtDescription.Text.ToString().Trim();
// Call objSla.Insert() to insert records in database
FlagInsertSla = objSla.Insert();
// If FlagInsertSla is 1 then record insert in database successfully
if (FlagInsertSla == 1)
{
// Call Function objSla.Get_By_SLAName() to get Slaid of created sla
objSla = objSla.Get_By_SLAName(txtSlaName.Text.ToString().Trim(), varsiteid);
if (objSla.Siteid != 0)
{
// declare local variable FlagInsertPriority
int FlagInsertPriority;
objSlaPriority.Slaid = objSla.Slaid;
objSlaPriority.Siteid = varsiteid;
objSlaPriority.Priorityid = Convert.ToInt16(drpPriority.SelectedValue);
objSlaPriority.Resolutiondays = Convert.ToInt16(txtDays.Text);
objSlaPriority.Resolutionhours = Convert.ToInt16(drphr.SelectedValue);
objSlaPriority.Resolutionmin = Convert.ToInt16(drpMin.SelectedValue);
// Call function objSlaPriority.Insert() to insert records in SLA_Priority_mst
FlagInsertPriority = objSlaPriority.Insert();
// if FlagInsertPriority is not zero then records insert successfully
if (FlagInsertPriority != 0)
{
//lblErrorMsg.Text = Resources.MessageResource.errSLADef.ToString();
if (chkLevel1.Checked == true)
{
InsertIntoLevel1(objSla.Slaid);
}
if (chkLevel2.Checked == true)
{
InsertIntoLevel2(objSla.Slaid);
}
if (chkLevel3.Checked == true)
{
InsertIntoLevel3(objSla.Slaid);
}
Clear();
Response.Redirect("~/admin/viewsla.aspx");
//CheckDefaultValueForEscalation();
}
else
{
// Call objSla.Delete to delete record from SLA_mst to delete sla definition,because some error occurred in SLA_Priority_mst
objSla.Delete(objSla.Slaid);
// Display Error message some error occurred
lblErrorMsg.Text = Resources.MessageResource.errOccured.ToString();
}
}
}
}
else
{
if (FlagEscalateLevel1 == false)
{
lblErrorMsg.Text = Resources.MessageResource.strLevel1.ToString();
}
if (FlagEscalateLevel2 == false)
{
lblErrorMsg.Text = Resources.MessageResource.strLevel2.ToString();
}
if (FlagEscalateLevel3 == false)
{
lblErrorMsg.Text = Resources.MessageResource.strLevel3.ToString();
}
}
}
else
{
lblErrorMsg.Text = Resources.MessageResource.errSLAExist.ToString();
}
}
}
else
{
lblErrorMsg.Text = "Service Window not set for this Site,Set the Service Window for this Site";
}
}
protected void Update()
{
int Slaid = Convert.ToInt32(Request.QueryString[0]);
objSla = objSla.Get_By_id(Slaid);
if (objSla.Slaid!=0)
{
int siteid = objSla.Siteid;
objSite = objSite.Get_By_id(siteid);
if (objSite.Siteid !=0)
{
lblSite.Text = objSite.Sitename;
}
txtSlaName.Text = objSla.Slaname.ToString().Trim();
txtDescription.Text = objSla.Description.ToString().Trim();
objSlaPriority = objSlaPriority.Get_By_id(objSla.Slaid);
if (objSlaPriority.Priorityid!=0)
{
objPriority= objPriority.Get_By_id(objSlaPriority.Priorityid);
if (objPriority.Priorityid!=0)
{
lblPriority.Text = objPriority.Name.ToString().Trim();
drphr.SelectedValue = Convert.ToString(objSlaPriority.Resolutionhours);
drpMin.SelectedValue = Convert.ToString(objSlaPriority.Resolutionmin);
txtDays.Text = Convert.ToString(objSlaPriority.Resolutiondays);
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
// Declare local variable varsiteid,FlagInsertSla and FlagStatus
int varsiteid;
ServiceWindow_mst objservicewindow = new ServiceWindow_mst();
varsiteid = Convert.ToInt16(drpSites.SelectedValue);
int count = objservicewindow.Get_ServiceWindow_By_Siteid(varsiteid);
if (count >= 1)
{
int FlagInsertSla;
int FlagStatus;
bool FlagEscalateLevel1 = true;
bool FlagEscalateLevel2 = true;
bool FlagEscalateLevel3 = true;
lblErrorTimeSelect.Text = "";
if (txtDays.Text == "0" && drphr.SelectedValue == "0" && drpMin.SelectedValue == "0")
{
lblErrorTimeSelect.Text = Resources.MessageResource.errResTime.ToString();
}
else
{
if (chkLevel1.Checked == true)
{
if (radio1Level1.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel1 = calculateTotalminutesLevel1();
if (varTotalTimeLevel1 > varTotalTime)
{ FlagEscalateLevel1 = false; }
}
if (radio2Level1.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel1 = calculateTotalminutesLevel1();
if (varTotalTimeLevel1 ==0)
{ FlagEscalateLevel1 = false; }
}
}
if (chkLevel2.Checked == true)
{
if (radio1Level2.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel2 = calculateTotalminutesLevel2();
if (varTotalTimeLevel2 > varTotalTime)
{ FlagEscalateLevel2 = false; }
}
if (radio2Level2.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel2 = calculateTotalminutesLevel2();
if (varTotalTimeLevel2 == 0)
{ FlagEscalateLevel2 = false; }
}
}
if (chkLevel3.Checked == true)
{
if (radio1Level3.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel3 = calculateTotalminutesLevel3();
if (varTotalTimeLevel3 > varTotalTime)
{ FlagEscalateLevel3 = false; }
}
if (radio2Level3.Checked == true)
{
int varTotalTime = calculateTotalminutes();
int varTotalTimeLevel3 = calculateTotalminutesLevel3();
if (varTotalTimeLevel3 == 0)
{ FlagEscalateLevel3 = false; }
}
}
// get sitetd from dropdown to variable varsiteid
// Check SLA Definition is exist in database with same name and site
objSla = objSla.Get_By_SLAName(txtSlaName.Text.ToString().Trim(), varsiteid);
// Check SLA Priority definition is exist in databse with siteid and priorityid
objSlaPriority = objSlaPriority.Get_By_Siteid(varsiteid, Convert.ToInt16(drpPriority.SelectedValue));
// if both objSla.Siteid and objSlaPriority.Slaid is zero then,No SLA Definition is exist in database
if (objSla.Siteid == 0 && objSlaPriority.Slaid == 0)
{
if (FlagEscalateLevel1 == true && FlagEscalateLevel2 == true && FlagEscalateLevel3 == true)
{
objSla.Siteid = varsiteid;
objSla.Slaname = txtSlaName.Text.ToString().Trim();
objSla.Createdatetime = DateTime.Now.ToString();
objSla.Enable = true;
objSla.Description = txtDescription.Text.ToString().Trim();
// Call objSla.Insert() to insert records in database
FlagInsertSla = objSla.Insert();
// If FlagInsertSla is 1 then record insert in database successfully
if (FlagInsertSla == 1)
{
// Call Function objSla.Get_By_SLAName() to get Slaid of created sla
objSla = objSla.Get_By_SLAName(txtSlaName.Text.ToString().Trim(), varsiteid);
if (objSla.Siteid != 0)
{
// declare local variable FlagInsertPriority
int FlagInsertPriority;
objSlaPriority.Slaid = objSla.Slaid;
objSlaPriority.Siteid = varsiteid;
objSlaPriority.Priorityid = Convert.ToInt16(drpPriority.SelectedValue);
objSlaPriority.Resolutiondays = Convert.ToInt16(txtDays.Text);
objSlaPriority.Resolutionhours = Convert.ToInt16(drphr.SelectedValue);
objSlaPriority.Resolutionmin = Convert.ToInt16(drpMin.SelectedValue);
// Call function objSlaPriority.Insert() to insert records in SLA_Priority_mst
FlagInsertPriority = objSlaPriority.Insert();
// if FlagInsertPriority is not zero then records insert successfully
if (FlagInsertPriority != 0)
{
//lblErrorMsg.Text = Resources.MessageResource.errSLADef.ToString();
if (chkLevel1.Checked == true)
{
InsertIntoLevel1(objSla.Slaid);
}
if (chkLevel2.Checked == true)
{
InsertIntoLevel2(objSla.Slaid);
}
if (chkLevel3.Checked == true)
{
InsertIntoLevel3(objSla.Slaid);
}
Clear();
Response.Redirect("~/admin/viewsla.aspx");
//CheckDefaultValueForEscalation();
}
else
{
// Call objSla.Delete to delete record from SLA_mst to delete sla definition,because some error occurred in SLA_Priority_mst
objSla.Delete(objSla.Slaid);
// Display Error message some error occurred
lblErrorMsg.Text = Resources.MessageResource.errOccured.ToString();
}
}
}
}
else
{
if (FlagEscalateLevel1 == false)
{
lblErrorMsg.Text = Resources.MessageResource.strLevel1.ToString();
}
if (FlagEscalateLevel2 == false)
{
lblErrorMsg.Text = Resources.MessageResource.strLevel2.ToString();
}
if (FlagEscalateLevel3 == false)
{
lblErrorMsg.Text = Resources.MessageResource.strLevel3.ToString();
}
}
}
else
{
lblErrorMsg.Text = Resources.MessageResource.errSLAExist.ToString();
}
}
}
else
{
lblErrorMsg.Text = "Service Window not set for this Site,Set the Service Window for this Site";
}
}
public int Update_SLA_mst_By_id(SLA_mst objSLA)
{
return (int)ExecuteNonQuery(Sp_SLA_Update, new object[] { objSLA.Slaname, objSLA.Slaid, objSLA.Siteid, objSLA.Enable, objSLA.Createdatetime, objSLA.Description });
}
public int Insert_SLA_mst(SLA_mst objSLA)
{
return (int)ExecuteNonQuery(Sp_SLA_Insert, new object[] { objSLA.Slaname, objSLA.Slaid, objSLA.Siteid, objSLA.Enable, objSLA.Createdatetime, objSLA.Description });
}
public object GenerateSLA_mstObject(ref IDataReader returnData)
{
SLA_mst obj = new SLA_mst();
while (returnData.Read())
{
DateTime Mydatetime = new DateTime();
obj.Slaid = (int)returnData["Slaid"];
obj.Siteid = (int)returnData["Siteid"];
obj.Slaname = (string)returnData["Slaname"];
obj.Description = (string)returnData["Description"];
obj.Enable = (bool)returnData["Enable"];
Mydatetime = (DateTime)returnData["Createdatetime"];
obj.Createdatetime = Mydatetime.ToString();
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateSLA_mstCollection(ref IDataReader returnData)
{
BLLCollection<SLA_mst> col = new BLLCollection<SLA_mst>();
while (returnData.Read())
{
SLA_mst obj = new SLA_mst();
obj.Slaid = (int)returnData["Slaid"];
obj.Siteid = (int)returnData["Siteid"];
obj.Slaname = (String)returnData["Slaname"];
obj.Description = (string)returnData["description"];
obj.Enable = (bool)returnData["Enable"];
DateTime Mydatetime = new DateTime();
Mydatetime = (DateTime)returnData["Createdatetime"];
obj.Createdatetime = Mydatetime.ToString();
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
