protected void Btncalldel_Click(object sender, EventArgs e) { try { #region DELETE if (HfWorkCode.Value != string.Empty) { string str = WORK_LISTMASLogicLayer.DeleteWORKLISTByID(HfWorkCode.Value.Trim()); 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:Work List Master Not Deleted"; lblmsg.ForeColor = Color.Red; } FillWorkListMaster(Session["COMP_CODE"].ToString()); clear(); } #endregion } catch (Exception) { throw; } }
protected void GvStockPriceDet_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Selecta") { #region SELECT clear(); DataTable dt = WORK_LISTMASLogicLayer.GetAllIDWiseWorklistdetails(e.CommandArgument.ToString()); if (dt.Rows.Count > 0) { HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString(); HfWorkCode.Value = dt.Rows[0]["WORK_CODE"].ToString(); TxtWorkDescrption.Text = dt.Rows[0]["WORK_NAME"].ToString(); DdlJobCategory.SelectedValue = dt.Rows[0]["JOB_CATCODE"].ToString(); BtnSave.Enabled = false; BtncallUpd.Enabled = true; Btncalldel.Enabled = true; } #endregion } } catch (Exception ex) { throw; } }
public void FillWorkListMaster(string CompCode) { try { DataTable Dt = new DataTable(); Dt = WORK_LISTMASLogicLayer.GetAllWork_List_MASDetail(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString())); DataView Dv = new DataView(Dt); if (CompCode != string.Empty) { Dv.RowFilter = "COMP_CODE=" + Session["COMP_CODE"].ToString(); } GvStockPriceDet.DataSource = Dv.ToTable();; GvStockPriceDet.DataBind(); } catch (Exception) { throw; } }
protected void BtnSave_Click(object sender, EventArgs e) { try { WORK_LISTMASLogicLayer insert = new Veera.LogicLayer.WORK_LISTMASLogicLayer(); insert.COMP_CODE = Session["COMP_CODE"].ToString(); // insert.WORK_CODE = HfWorkCode.Value; insert.WORK_NAME = TxtWorkDescrption.Text.Trim(); insert.JOB_CATCODE = DdlJobCategory.SelectedValue.ToString().Trim(); insert.INS_USERID = Session["USERNAME"].ToString(); insert.INS_DATE = ""; //insert.UPD_USERID = Session["USERNAME"].ToString(); //insert.UPD_DATE = ""; string str = WORK_LISTMASLogicLayer.InsertWORK_LISTMAS(insert); if (str.Contains("successfully")) { lblmsg.Text = "WORK LIST MASTER SAVE SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; FillWorkListMaster(Session["COMP_CODE"].ToString()); clear(); } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "WORK LIST MASTER ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : WORK LIST MASTER NOT SAVED"; lblmsg.ForeColor = Color.Red; } } catch (Exception ex) { throw; } }