protected void FindProblemToChangeAttach()
{
int problemid = Convert.ToInt32(Session["problemid"].ToString());
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
// 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
int chanid;
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
chanid = Convert.ToInt32(gvIDs);
// Check if gvIDs is not null
if (gvIDs != "")
{
ObjProblemToChange = ObjProblemToChange.Get_By_id(chanid, problemid);
if (ObjProblemToChange.Problemid != 0)
{
deleteChkBxItem.Checked = true;
}
}
}
}
protected void btnAttach_Click(object sender, EventArgs e)
{
int problemid = Convert.ToInt16(Session["problemid"].ToString());
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
// 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 chanid;
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
chanid = Convert.ToInt16(gvIDs);
// Check if gvIDs is not null
if (gvIDs != "")
{
ObjProblemToChange = ObjProblemToChange.Get_By_id(chanid, problemid);
if (ObjProblemToChange.Problemid == 0)
{
ObjProblemToChange.Changeid = chanid;
ObjProblemToChange.Problemid = problemid;
ObjProblemToChange.Insert();
}
}
}
}
lblErrorMsg.Text = "Change is Attached to Current Problems";
}
protected void btnAttach_Click(object sender, EventArgs e)
{
int problemid = Convert.ToInt16(Session["problemid"].ToString());
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
// 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 chanid;
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
chanid = Convert.ToInt16(gvIDs);
// Check if gvIDs is not null
if (gvIDs != "")
{
ObjProblemToChange = ObjProblemToChange.Get_By_id(chanid, problemid);
if (ObjProblemToChange.Problemid == 0)
{
ObjProblemToChange.Changeid = chanid;
ObjProblemToChange.Problemid = problemid;
ObjProblemToChange.Insert();
}
}
}
}
lblErrorMsg.Text = "Change is Attached to Current Problems";
}
protected void btnAttach_Click(object sender, EventArgs e)
{
///Add Exception handilng try catch change by vishal 21-05-2012
try
{
int problemid = Convert.ToInt32(Session["problemid"].ToString());
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
// 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 chanid;
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
chanid = Convert.ToInt32(gvIDs);
// Check if gvIDs is not null
if (gvIDs != "")
{
ObjProblemToChange = ObjProblemToChange.Get_By_id(chanid, problemid);
if (ObjProblemToChange.Problemid == 0)
{
ObjProblemToChange.Changeid = chanid;
ObjProblemToChange.Problemid = problemid;
ObjProblemToChange.Insert();
}
}
}
}
lblErrorMsg.Text = "Change is Attached to Current Problems";
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
protected void btnAttach_Click(object sender, EventArgs e)
{///Add Exception handilng try catch change by vishal 21-05-2012
try
{
int problemid = Convert.ToInt32(Session["problemid"].ToString());
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
// 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 chanid;
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
chanid = Convert.ToInt32(gvIDs);
// Check if gvIDs is not null
if (gvIDs != "")
{
ObjProblemToChange = ObjProblemToChange.Get_By_id(chanid, problemid);
if (ObjProblemToChange.Problemid == 0)
{
ObjProblemToChange.Changeid = chanid;
ObjProblemToChange.Problemid = problemid;
ObjProblemToChange.Insert();
}
}
}
}
lblErrorMsg.Text = "Change is Attached to Current Problems";
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
public int Update_Problem_To_Change_By_id(Problem_To_Change objProblem_To_Change)
{
return (int)ExecuteNonQuery(Sp_Problem_To_Change_Update, new object[] { objProblem_To_Change.Changeid, objProblem_To_Change.Problemid });
}
public int Insert_Problem_To_Change(Problem_To_Change ObjProblem_To_Change)
{
return (int)ExecuteNonQuery(Sp_Problem_To_Change_Insert, new object[] { ObjProblem_To_Change.Changeid, ObjProblem_To_Change.Problemid });
}
public object GenerateProblem_To_Change_mstObject(ref IDataReader returnData)
{
Problem_To_Change obj = new Problem_To_Change();
while (returnData.Read())
{
obj.Problemid = (int)returnData["Changeid"];
obj.Changeid = (int)returnData["Problemid"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateProblem_To_Change_mstCollection(ref IDataReader returnData)
{
BLLCollection<Problem_To_Change> col = new BLLCollection<Problem_To_Change>();
while (returnData.Read())
{
Problem_To_Change obj = new Problem_To_Change();
obj.Problemid = (int)returnData["ProblemId"];
obj.Changeid = (int)returnData["ChangeId"];
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
protected void FindProblemToChangeAttach()
{
int problemid = Convert.ToInt16(Session["problemid"].ToString());
foreach (GridViewRow gv in grdvwChange.Rows)
{
string gvIDs;
// 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
int chanid;
gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString();
chanid = Convert.ToInt16(gvIDs);
// Check if gvIDs is not null
if (gvIDs != "")
{
ObjProblemToChange = ObjProblemToChange.Get_By_id(chanid, problemid);
if (ObjProblemToChange.Problemid != 0)
{
deleteChkBxItem.Checked = true;
}
}
}
}