protected void btnSubmit_Click(object sender, EventArgs e)
{
string Email = "";
foreach (GridViewRow gv in grdvwEscalate.Rows)
{
string ID;
// Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
// If deleteChkBxItem is Checked then ,mapped Current site to this user
if (deleteChkBxItem.Checked)
{
int varId;
// Get the Site Id from variable of Label type declare in GridView of grdvwSite
ID = ((Label)gv.FindControl("id")).Text.ToString();
varId = Convert.ToInt32(ID);
// Check if gvIDs is not null
if (ID != "")
{
EscalateEmail_mst obj = new EscalateEmail_mst();
obj = objEscalateEmail.Get_By_id(varId);
Email = Email + obj.Email.ToString() + "," ;
}
}
}
Session["UsersEmail"] = Email.ToString();
string myScript;
myScript = "<script language=javascript>javascript:window.close();</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string Email = "";
foreach (GridViewRow gv in grdvwEscalate.Rows)
{
string ID;
// Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
// If deleteChkBxItem is Checked then ,mapped Current site to this user
if (deleteChkBxItem.Checked)
{
int varId;
// Get the Site Id from variable of Label type declare in GridView of grdvwSite
ID = ((Label)gv.FindControl("id")).Text.ToString();
varId = Convert.ToInt32(ID);
// Check if gvIDs is not null
if (ID != "")
{
EscalateEmail_mst obj = new EscalateEmail_mst();
obj = objEscalateEmail.Get_By_id(varId);
Email = Email + obj.Email.ToString() + ",";
}
}
}
Session["UsersEmail"] = Email.ToString();
string myScript;
myScript = "<script language=javascript>javascript:window.close();</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
}
protected void BindContractData()
{
int contractid = Convert.ToInt32(Request.QueryString[0]);
objContract = objContract.Get_By_id(contractid);
if (objContract != null)
{
txtContractName.Text = objContract.Contractname + " " + "Renewed";
txtdesc.Text = objContract.Description;
drpVendor.SelectedValue = Convert.ToString(objContract.Vendorid);
colContractToAssetMapping = objContractToAsset.Get_All_By_contractid(objContract.Contractid);
foreach (ContractToAssetMapping obj in colContractToAssetMapping)
{
Asset_mst objA = new Asset_mst();
objA = objA.Get_By_id(obj.Assetid);
colAsset.Add(objA);
}
ListAsset.DataTextField = "computername";
ListAsset.DataValueField = "Assetid";
ListAsset.DataSource = colAsset;
ListAsset.DataBind();
}
objContractNotfy = objContractNotfy.Get_By_id(contractid);
if (objContractNotfy.Contractid != 0)
{
EscalateEmail_mst objEscalateEmail = new EscalateEmail_mst();
chkLevel1.Checked = true;
txtBeforeDays.Text = objContractNotfy.Beforedays.ToString();
string varEmail = objContractNotfy.Sentto;
string[] arrEmail = varEmail.Split((",").ToCharArray());
for (int i = 0; i < arrEmail.Length - 1; i++)
{
if (arrEmail[i] != "," && arrEmail[i] != " ")
{
objEscalateEmail = objEscalateEmail.Get_By_Emailid(arrEmail[i]);
for (int j = listLevel1.Items.Count - 1; j >= 0; j--)
{
if (Convert.ToInt32(listLevel1.Items[j].Value) == objEscalateEmail.Id)
{
listLevel1.Items[j].Selected = true;
}
}
}
}
}
}
protected void BindContractData()
{
int contractid = Convert.ToInt16(Request.QueryString[0]);
objContract = objContract.Get_By_id(contractid);
if (objContract != null)
{
txtContractName.Text = objContract.Contractname + " " + "Renewed";
txtdesc.Text = objContract.Description;
drpVendor.SelectedValue = Convert.ToString(objContract.Vendorid);
colContractToAssetMapping = objContractToAsset.Get_All_By_contractid(objContract.Contractid);
foreach (ContractToAssetMapping obj in colContractToAssetMapping)
{
Asset_mst objA = new Asset_mst();
objA = objA.Get_By_id(obj.Assetid);
colAsset.Add(objA);
}
ListAsset.DataTextField = "computername";
ListAsset.DataValueField = "Assetid";
ListAsset.DataSource = colAsset;
ListAsset.DataBind();
}
objContractNotfy = objContractNotfy.Get_By_id(contractid);
if (objContractNotfy.Contractid != 0)
{
EscalateEmail_mst objEscalateEmail = new EscalateEmail_mst();
chkLevel1.Checked = true;
txtBeforeDays.Text = objContractNotfy.Beforedays.ToString();
string varEmail = objContractNotfy.Sentto;
string[] arrEmail = varEmail.Split((",").ToCharArray());
for (int i = 0; i < arrEmail.Length - 1; i++)
{
if (arrEmail[i] != "," && arrEmail[i] != " ")
{
objEscalateEmail = objEscalateEmail.Get_By_Emailid(arrEmail[i]);
for (int j = listLevel1.Items.Count - 1; j >= 0; j--)
{
if (Convert.ToInt16(listLevel1.Items[j].Value) == objEscalateEmail.Id)
{
listLevel1.Items[j].Selected = true;
}
}
}
}
}
}
protected void Emailgrdvw_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
resetcontrols();
int emailid, count;
string email, id;
id = Convert.ToString(Emailgrdvw.Rows[e.RowIndex].Cells[0].Text);
email = ((TextBox)Emailgrdvw.Rows[e.RowIndex].Cells[1].Controls[0].FindControl("txtEmail")).Text;
emailid = Convert.ToInt32(id);
objemail = objemail.Get_By_id(emailid);
count = objemail.Check_Emailid(email);
if (objemail.Email == email)
{
objemail.Email = email;
objemail.Update();
Emailgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else if (email == "")
{
lblerrmsg.Text = "Email should not be empty";
}
else if ((count == 0) && (email != ""))
{
objemail.Email = email;
objemail.Update();
Emailgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else
{
Emailgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.erralready.ToString();
}
}
protected void BindContractData()
{
int contractid = Convert.ToInt32(Request.QueryString[0]);
objContract = objContract.Get_By_id(contractid);
if (objContract != null)
{
string dd;
string mm;
string yy;
txtContractName.Text = objContract.Contractname;
txtdesc.Text = objContract.Description.ToString();
string[] tempdate = objContract.Activefrom.ToString().Split(("/").ToCharArray());
string StrData = tempdate[2].ToString();
string[] temp1 = StrData.Split((" ").ToCharArray());
if (Convert.ToInt32(tempdate[1]) < 10)
{
dd = "0" + tempdate[1];
}
else
{
dd = tempdate[1];
}
if (Convert.ToInt32(tempdate[0]) < 10)
{
mm = "0" + tempdate[0];
}
else
{
mm = tempdate[0];
}
string vardateFrom = dd + "/" + mm + "/" + temp1[0];
txtActiveFrom.Text = vardateFrom;
string[] tempdate1 = objContract.Activeto.ToString().Split(("/").ToCharArray());
string StrData1 = tempdate1[2].ToString();
string[] temp2 = StrData1.Split((" ").ToCharArray());
if (Convert.ToInt32(tempdate1[1]) < 10)
{
dd = "0" + tempdate1[1];
}
else
{
dd = tempdate1[1];
}
if (Convert.ToInt32(tempdate1[0]) < 10)
{
mm = "0" + tempdate1[0];
}
else
{
mm = tempdate1[0];
}
string vardateTo = dd + "/" + mm + "/" + temp2[0];
txtActiveTo.Text = vardateTo;
drpVendor.SelectedValue = Convert.ToString(objContract.Vendorid);
colContractToAssetMapping = objContractToAsset.Get_All_By_contractid(objContract.Contractid);
foreach (ContractToAssetMapping obj in colContractToAssetMapping)
{
Asset_mst objA = new Asset_mst();
objA = objA.Get_By_id(obj.Assetid);
colAsset.Add(objA);
}
ListAsset.DataTextField = "computername";
ListAsset.DataValueField = "Assetid";
ListAsset.DataSource = colAsset;
ListAsset.DataBind();
}
objContractNotfy = objContractNotfy.Get_By_id(contractid);
if (objContractNotfy.Contractid != 0)
{
EscalateEmail_mst objEscalateEmail = new EscalateEmail_mst();
chkLevel1.Checked = true;
txtBeforeDays.Text = objContractNotfy.Beforedays.ToString();
string varEmail = objContractNotfy.Sentto;
string[] arrEmail = varEmail.Split((",").ToCharArray());
for (int i = 0; i < arrEmail.Length - 1; i++)
{
if (arrEmail[i] != "," && arrEmail[i] != " ")
{
objEscalateEmail = objEscalateEmail.Get_By_Emailid(arrEmail[i]);
for (int j = listLevel1.Items.Count - 1; j >= 0; j--)
{
if (Convert.ToInt32(listLevel1.Items[j].Value) == objEscalateEmail.Id)
{
listLevel1.Items[j].Selected = true;
}
}
}
}
}
}
public int Update_EscalateEmail_mst_By_id(EscalateEmail_mst objEscalateEmail_mst)
{
return (int)ExecuteNonQuery(sp_EscalateEmail_mst_Update, new object[] { objEscalateEmail_mst.Id, objEscalateEmail_mst.Email });
}
public int Insert_EscalateEmail_mst(EscalateEmail_mst objEscalateEmail_mst)
{
return (int)ExecuteNonQuery(sp_EscalateEmail_mst_Insert, new object[] { objEscalateEmail_mst.Email });
}
public object GenerateEscalateEmail_mstObject(ref IDataReader returnData)
{
EscalateEmail_mst obj = new EscalateEmail_mst();
while (returnData.Read())
{
obj.Id = (int)returnData["Id"];
obj.Email = (string)returnData["Email"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateEscalateEmail_mstCollection(ref IDataReader returnData)
{
BLLCollection<EscalateEmail_mst> col = new BLLCollection<EscalateEmail_mst>();
while (returnData.Read())
{
EscalateEmail_mst obj = new EscalateEmail_mst();
obj.Id = (int)returnData["Id"];
obj.Email = (string)returnData["Email"];
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
protected void Emailgrdvw_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
resetcontrols();
int emailid, count;
string email, id;
id = Convert.ToString(Emailgrdvw.Rows[e.RowIndex].Cells[0].Text);
email = ((TextBox)Emailgrdvw.Rows[e.RowIndex].Cells[1].Controls[0].FindControl("txtEmail")).Text;
emailid = Convert.ToInt16(id);
objemail = objemail.Get_By_id(emailid);
count=objemail.Check_Emailid(email);
if (objemail.Email == email)
{
objemail.Email = email;
objemail.Update();
Emailgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else if (email == "")
{
lblerrmsg.Text = "Email should not be empty";
}
else if ((count == 0) && (email != ""))
{
objemail.Email = email;
objemail.Update();
Emailgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else
{
Emailgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.erralready.ToString();
}
}
protected void BindContractData()
{
int contractid = Convert.ToInt16(Request.QueryString[0]);
objContract = objContract.Get_By_id(contractid);
if (objContract != null)
{
string dd;
string mm;
string yy;
txtContractName.Text = objContract.Contractname;
txtdesc.Text = objContract.Description.ToString();
string[] tempdate = objContract.Activefrom.ToString().Split(("/").ToCharArray());
string StrData = tempdate[2].ToString();
string[] temp1 = StrData.Split((" ").ToCharArray());
if (Convert.ToInt16(tempdate[1]) < 10)
{
dd = "0" + tempdate[1];
}
else
{
dd = tempdate[1];
}
if (Convert.ToInt16(tempdate[0]) < 10)
{
mm = "0" + tempdate[0];
}
else
{
mm = tempdate[0];
}
string vardateFrom = dd + "/" + mm + "/" + temp1[0];
txtActiveFrom.Text = vardateFrom;
string[] tempdate1 = objContract.Activeto.ToString().Split(("/").ToCharArray());
string StrData1 = tempdate1[2].ToString();
string[] temp2 = StrData1.Split((" ").ToCharArray());
if (Convert.ToInt16(tempdate1[1]) < 10)
{
dd = "0" + tempdate1[1];
}
else
{
dd = tempdate1[1];
}
if (Convert.ToInt16(tempdate1[0]) < 10)
{
mm = "0" + tempdate1[0];
}
else
{
mm = tempdate1[0];
}
string vardateTo = dd + "/" + mm + "/" + temp2[0];
txtActiveTo.Text = vardateTo;
drpVendor.SelectedValue = Convert.ToString(objContract.Vendorid);
colContractToAssetMapping = objContractToAsset.Get_All_By_contractid(objContract.Contractid);
foreach (ContractToAssetMapping obj in colContractToAssetMapping)
{
Asset_mst objA = new Asset_mst();
objA = objA.Get_By_id(obj.Assetid);
colAsset.Add(objA);
}
ListAsset.DataTextField = "computername";
ListAsset.DataValueField = "Assetid";
ListAsset.DataSource = colAsset;
ListAsset.DataBind();
}
objContractNotfy = objContractNotfy.Get_By_id(contractid);
if (objContractNotfy.Contractid!=0)
{
EscalateEmail_mst objEscalateEmail = new EscalateEmail_mst();
chkLevel1.Checked = true;
txtBeforeDays.Text = objContractNotfy.Beforedays.ToString();
string varEmail = objContractNotfy.Sentto;
string[] arrEmail = varEmail.Split((",").ToCharArray());
for (int i = 0; i < arrEmail.Length - 1; i++)
{
if (arrEmail[i] != "," && arrEmail[i] != " ")
{
objEscalateEmail = objEscalateEmail.Get_By_Emailid(arrEmail[i]);
for (int j = listLevel1.Items.Count - 1; j >= 0; j--)
{
if (Convert.ToInt16(listLevel1.Items[j].Value) == objEscalateEmail.Id)
{
listLevel1.Items[j].Selected = true;
}
}
}
}
}
}
