protected void grdvwSla_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int SLAid;
SLAid = Convert.ToInt16(grdvwSla.Rows[e.RowIndex].Cells[0].Text);
objSlaPriority.Delete(SLAid);
objSla.Delete(SLAid);
BindGrid();
}
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 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";
}
}