protected void btnsave_Click(object sender, EventArgs e) { string msg; int flag = 0; DataTable dtJoining = new DataTable(); dtJoining = objBLL.Get_JoiningType_List(null); dtJoining.DefaultView.RowFilter = HiddenFlag.Value != "Add" ? "Joining_Type= '" + txtJoiningType.Text.Trim() + "' AND ID<> '" + txtJoiningTypeID.Text.Trim() + "'" : "Joining_Type= '" + txtJoiningType.Text.Trim() + "'"; if (dtJoining.DefaultView.Count > 0) { msg = String.Format("alert('Joining Type already exists!')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true); flag = 1; string hidemodal = String.Format("showModal('divadd')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true); } if (flag != 1) { dtJoining.DefaultView.RowFilter = HiddenFlag.Value != "Add" ? "JCode= '" + txtJoiningCode.Text.Trim() + "' AND ID<> '" + txtJoiningTypeID.Text.Trim() + "'" : "JCode= '" + txtJoiningCode.Text.Trim() + "'"; if (dtJoining.DefaultView.Count > 0) { msg = String.Format("alert('Joining code already exists!')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true); flag = 1; string hidemodal = String.Format("showModal('divadd')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true); } else { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("JCode", typeof(Int32))); DataRow dr; if (chkPBillConsidered.Checked == true) { foreach (GridViewRow row in GVOffPBill.Rows) { if ((row.Cells[1].FindControl("chkPbillAssigned") as CheckBox).Checked == true) { dr = dt.NewRow(); dr["JCode"] = GVOffPBill.DataKeys[row.RowIndex].Value; dt.Rows.Add(dr); } } } if (HiddenFlag.Value == "Add") { int retval = objBLL.InsertJoiningType(txtJoiningType.Text, txtJoiningCode.Text, chkSeniorityConsidered.Checked, chkVessselPBill_Considered.Checked, chkServiceConsidered.Checked, chkPBillConsidered.Checked, dt, Convert.ToInt32(Session["USERID"]), chkOperatorExp.Checked, chkWatchKeeping.Checked); } else { int retval = objBLL.EditJoiningType(Convert.ToInt32(txtJoiningTypeID.Text.Trim()), txtJoiningType.Text, txtJoiningCode.Text, chkSeniorityConsidered.Checked, chkVessselPBill_Considered.Checked, chkServiceConsidered.Checked, chkPBillConsidered.Checked, dt, Convert.ToInt32(Session["USERID"]), chkOperatorExp.Checked, chkWatchKeeping.Checked); } BindJoiningType(); string hidemodal = String.Format("hideModal('divadd')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true); } } }