protected void btnDelete_click(object sender, EventArgs e) { try { if (HfGROUP_CODE.Value != string.Empty) { string str = GROUP_MASLogicLayer.DeleteGROUP_MASDetailsByID(HfGROUP_CODE.Value); if (str.Contains("successfully")) { lblmsg.Text = "Record Deleted Successfully"; lblmsg.ForeColor = Color.Green; } else if (str.Contains("Cannot")) { lblmsg.Text = "Cannot Delete This Record It Used by Other Data"; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "Error:Group Master Not Deleted"; lblmsg.ForeColor = Color.Red; } clear(); FillGrid(); UserRights(); } } catch (Exception) { throw; } }
protected void TxtAccountGroupName_TextChanged(object sender, EventArgs e) { try { DataTable DtGroup = new DataTable(); DtGroup = GROUP_MASLogicLayer.GetAllGROUP_MASDetials_DDL(); if (TxtAccountGroupName.Text != string.Empty && TxtAccountGroupName.Text != null) { DataView Dv = new DataView(DtGroup); Dv.RowFilter = "GROUP_NAME='" + TxtAccountGroupName.Text.Trim().ToString() + "'"; DataTable DtView = Dv.ToTable(); if (DtView.Rows.Count > 0) { HfGroupCode.Value = DtView.Rows[0]["GROUP_CODE"].ToString(); } } else { HfGroupCode.Value = null; } } catch (Exception) { throw; } }
public void FillGrid() { try { DataTable Dt = new DataTable(); Dt = GROUP_MASLogicLayer.GetAllGROUP_MASDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString())); GvGroupMaster.DataSource = Dt; GvGroupMaster.DataBind(); } catch (Exception) { throw; } }
protected void BtncallUpd_Click(object sender, EventArgs e) { try { if (BtncallUpd.Text == "UPDATE") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModel1", "ShowModel1()", true); } else { GROUP_MASLogicLayer insert = new GROUP_MASLogicLayer(); //insert.GROUP_CODE = TxtGroupCode.Text.Trim().ToUpper(); insert.GROUP_NAME = TxtGroupName.Text.Trim().ToUpper(); insert.GROUP_TYPE = DdlGroupType.SelectedValue.Trim().ToUpper(); insert.GROUP_ORD = TxtGroupOrder.Text.Trim().ToUpper(); insert.GROUP_CODE = HfGROUP_CODE.Value.Trim(); if (BtncallUpd.Text.Trim().ToUpper() == "SAVE") { string str = GROUP_MASLogicLayer.InsertGROUPMASTERDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "MASTER GROUP DETAIL ADD SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; clear(); FillGrid(); UserRights(); } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "GROUP CODE ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } } } } catch (Exception) { throw; } }
protected void GvGroupMaster_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Deletea") { clear(); DataTable dt = GROUP_MASLogicLayer.GetGROUP_CODEWISEGROUP_MASDetials(e.CommandArgument.ToString()); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; //TxtGroupCode.Text = dt.Rows[0]["GROUP_CODE"].ToString(); TxtGroupName.Text = dt.Rows[0]["GROUP_NAME"].ToString(); DdlGroupType.SelectedValue = dt.Rows[0]["GROUP_TYPE"].ToString(); TxtGroupOrder.Text = dt.Rows[0]["GROUP_ORD"].ToString(); HfGROUP_CODE.Value = dt.Rows[0]["GROUP_CODE"].ToString(); } btnSave.Visible = false; btnDelete.Visible = true; Btncalldel.Visible = true; BtncallUpd.Visible = false; ControllerDisable(); } if (e.CommandName == "Edita") { clear(); DataTable dt = GROUP_MASLogicLayer.GetGROUP_CODEWISEGROUP_MASDetials(e.CommandArgument.ToString()); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; //TxtGroupCode.Text = dt.Rows[0]["GROUP_CODE"].ToString(); TxtGroupName.Text = dt.Rows[0]["GROUP_NAME"].ToString(); DdlGroupType.SelectedValue = dt.Rows[0]["GROUP_TYPE"].ToString(); TxtGroupOrder.Text = dt.Rows[0]["GROUP_ORD"].ToString(); HfGROUP_CODE.Value = dt.Rows[0]["GROUP_CODE"].ToString(); } BtncallUpd.Text = "UPDATE"; // btnSave.Text = "UPDATE"; if (Session["UPDATE"] != null) { if (Session["UPDATE"].ToString() == "Y") { ControllerEnable(); } else { ControllerDisable(); } } btnSave.Visible = true; BtncallUpd.Visible = true; Btncalldel.Visible = false; UserRights(); } if (e.CommandName == "Viewa") { clear(); DataTable dt = GROUP_MASLogicLayer.GetGROUP_CODEWISEGROUP_MASDetials(e.CommandArgument.ToString()); if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; //TxtGroupCode.Text = dt.Rows[0]["GROUP_CODE"].ToString(); TxtGroupName.Text = dt.Rows[0]["GROUP_NAME"].ToString(); DdlGroupType.SelectedValue = dt.Rows[0]["GROUP_TYPE"].ToString(); TxtGroupOrder.Text = dt.Rows[0]["GROUP_ORD"].ToString(); HfGROUP_CODE.Value = dt.Rows[0]["GROUP_CODE"].ToString(); } ControllerDisable(); btnSave.Visible = false; Btncalldel.Visible = false; BtncallUpd.Visible = false; UserRights(); // btnDelete.Visible = true; // btnSave.Text = "UPDATE"; } } catch (Exception) { throw; } }
protected void btnSave_click(object sender, EventArgs e) { try { GROUP_MASLogicLayer insert = new GROUP_MASLogicLayer(); //insert.GROUP_CODE = TxtGroupCode.Text.Trim().ToUpper(); insert.GROUP_NAME = TxtGroupName.Text.Trim().ToUpper(); insert.GROUP_TYPE = DdlGroupType.SelectedValue.Trim().ToUpper(); insert.GROUP_ORD = TxtGroupOrder.Text.Trim().ToUpper(); insert.GROUP_CODE = HfGROUP_CODE.Value.Trim(); if (btnSave.Text.Trim().ToUpper() == "SAVE") { string str = GROUP_MASLogicLayer.InsertGROUPMASTERDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "MASTER GROUP DETAIL ADD SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; clear(); FillGrid(); UserRights(); } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "GROUP CODE ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : GROUP MASTER DETAIL NOT SAVED"; lblmsg.ForeColor = Color.Red; } } else { string str = GROUP_MASLogicLayer.UpdateGROUPMASTERDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "GROUP MASTER DETAIL UPDATE SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; clear(); FillGrid(); UserRights(); } else if (str.Contains("Already")) { lblmsg.Text = "GROUP CODE ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : GROUP MASTER DETAIL NOT SAVED"; lblmsg.ForeColor = Color.Red; } } } catch (Exception) { throw; } }