protected void dgDetailPO_RowDeleting(object sender, GridViewDeleteEventArgs e) { if (CommonClasses.ValidRights(int.Parse(right.Substring(4, 1)), this, "For Delete")) { if (!ModifyLog(((Label)(dgDetailPO.Rows[e.RowIndex].FindControl("lblIWM_CODE"))).Text)) { try { string cpom_code = ((Label)(dgDetailPO.Rows[e.RowIndex].FindControl("lblIWM_CODE"))).Text; if (CommonClasses.CheckUsedInTran("INSPECTION_S_MASTER", "INSM_IWM_CODE", "AND ES_DELETE=0", cpom_code)) { PanelMsg.Visible = true; lblmsg.Text = "You can't delete this record, it is used in Material Inspection"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } else { bool flag = CommonClasses.Execute1("UPDATE INWARD_MASTER SET ES_DELETE = 1 WHERE IWM_CODE='" + Convert.ToInt32(cpom_code) + "'"); if (flag == true) { DataTable dtq = CommonClasses.Execute("SELECT IWD_REV_QTY,IWD_I_CODE,IWD_CPOM_CODE FROM INWARD_DETAIL where IWD_IWM_CODE=" + cpom_code + " "); for (int i = 0; i < dtq.Rows.Count; i++) { CommonClasses.Execute("update SUPP_PO_DETAILS set SPOD_INW_QTY=SPOD_INW_QTY-" + dtq.Rows[i]["IWD_REV_QTY"] + " where SPOD_I_CODE='" + dtq.Rows[i]["IWD_I_CODE"] + "' and SPOD_SPOM_CODE='" + dtq.Rows[i]["IWD_CPOM_CODE"] + "'"); //CommonClasses.Execute("UPDATE ITEM_MASTER SET I_CURRENT_BAL=I_CURRENT_BAL-" + dtq.Rows[i]["IWD_REV_QTY"] + " where I_CODE='" + dtq.Rows[i]["IWD_I_CODE"] + "'"); } DataTable dtchallan = new DataTable(); dtchallan = CommonClasses.Execute("SELECT * FROM CHALLAN_STOCK_LEDGER where CL_DOC_TYPE='IWIAP' AND CL_DOC_ID='" + cpom_code + "'"); for (int z = 0; z < dtchallan.Rows.Count; z++) { CommonClasses.Execute("UPDATE CHALLAN_STOCK_LEDGER SET CL_CON_QTY=CL_CON_QTY +" + Convert.ToDouble(dtchallan.Rows[z]["CL_CQTY"].ToString()) + " where CL_DOC_TYPE='OutSUBINM' AND CL_P_CODE='" + dtchallan.Rows[z]["CL_P_CODE"].ToString() + "' AND CL_CH_NO='" + dtchallan.Rows[z]["CL_CH_NO"].ToString() + "' AND CL_I_CODE='" + dtchallan.Rows[z]["CL_I_CODE"].ToString() + "' "); } CommonClasses.Execute(" DELETE FROM CHALLAN_STOCK_LEDGER where CL_DOC_TYPE='IWIAP' AND CL_DOC_ID='" + cpom_code + "'"); //flag = CommonClasses.Execute1("DELETE FROM STOCK_LEDGER WHERE STL_DOC_NO='" + cpom_code + "' and STL_DOC_TYPE='IWIM'"); //if (flag == true) //{ // flag = CommonClasses.Execute1("DELETE FROM GIN_STOCK_LEDGER WHERE GL_DOC_ID='" + cpom_code + "' and GL_DOC_TYPE='IWIM'"); //} //CommonClasses.WriteLog("Material Inward ", "Delete", "Material Inward", cpom_code, Convert.ToInt32(cpom_code), Convert.ToInt32(Session["CompanyId"]), Convert.ToInt32(Session["CompanyCode"]),(Session["Username"].ToString()), Convert.ToInt32(Session["UserCode"])); CommonClasses.WriteLog("Material Inward ", "Delete", "Material Inward", cpom_code, Convert.ToInt32(cpom_code), Convert.ToInt32(Session["CompanyId"]), (Session["Username"].ToString()), Convert.ToInt32(Session["UserCode"])); PanelMsg.Visible = true; lblmsg.Text = "Record deleted successfully"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); } } } catch (Exception Ex) { CommonClasses.SendError("Material Inward", "dgDetailPO_RowDeleting", Ex.Message); } } else { PanelMsg.Visible = true; lblmsg.Text = "Record used by another person"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } LoadInward(); } else { PanelMsg.Visible = true; lblmsg.Text = "You have no rights to delete"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); //ShowMessage("#Avisos", "You Have No Rights To Delete", CommonClasses.MSG_Erro); return; } }
protected void dgDetailServicePO_RowCommand(object sender, GridViewCommandEventArgs e) { try { #region View if (e.CommandName.Equals("View")) { if (CommonClasses.ValidRights(int.Parse(right.Substring(1, 1)), this, "For View")) { if (!ModifyLog(e.CommandArgument.ToString())) { string type = "VIEW"; string cpom_code = e.CommandArgument.ToString(); Response.Redirect("~/Transactions/ADD/ServicePurchaseOrder.aspx?c_name=" + type + "&cpom_code=" + cpom_code, false); } else { PanelMsg.Visible = true; lblmsg.Text = "Record Used By Another Person"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } else { PanelMsg.Visible = true; lblmsg.Text = "You have no rights to View"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } #endregion #region Modify else if (e.CommandName.Equals("Modify")) { if (CommonClasses.ValidRights(int.Parse(right.Substring(2, 1)), this, "For Modify")) { if ((CommonClasses.Execute("select count(*) as counted from SERVICE_PO_MASTER where SRPOM_CANCEL_PO=1 and ES_DELETE=0 and SRPOM_CODE='" + e.CommandArgument.ToString() + "'")).Rows[0][0].ToString() == "0") { if (!ModifyLog(e.CommandArgument.ToString())) { string type = "MODIFY"; string cpom_code = e.CommandArgument.ToString(); DataTable dt = CommonClasses.Execute("select isnull(SRPOM_POST,0) as SRPOM_POST,isnull(SRPOM_P_AMEND_CODE,0) as SRPOM_P_AMEND_CODE from SERVICE_PO_MASTER where SRPOM_CODE='" + cpom_code + "' "); if (dt.Rows.Count > 0) { if (Convert.ToBoolean(dt.Rows[0]["SRPOM_POST"].ToString()) == true) { PanelMsg.Visible = true; lblmsg.Text = "This PO is posted and can not be modified"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } //else if (Convert.ToInt32(dt.Rows[0]["SRPOM_P_AMEND_CODE"]) != 0) //{ // PanelMsg.Visible = true; // lblmsg.Text = "You Can't Modify Because These PO Is Amend"; // return; //} else { if (CommonClasses.CheckUsedInTran("INWARD_MASTER,INWARD_DETAIL", "IWD_CPOM_CODE", "AND IWD_CPOM_CODE=SRPOM_CODE and INWARD_MASTER.ES_DELETE=0", cpom_code)) { PanelMsg.Visible = true; lblmsg.Text = "You can't delete this record, it is used in Inward Master"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } else { Response.Redirect("~/Transactions/ADD/ServicePurchaseOrder.aspx?c_name=" + type + "&cpom_code=" + cpom_code, false); } } } } } else { PanelMsg.Visible = true; lblmsg.Text = "You Can't Modify Because it is cancelled"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } else { PanelMsg.Visible = true; lblmsg.Text = "You have no rights to Modify"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } #endregion #region Print else if (e.CommandName.Equals("Print")) { if (CommonClasses.ValidRights(int.Parse(right.Substring(5, 1)), this, "For Print")) { if ((CommonClasses.Execute("select count(*) as counted from SERVICE_PO_MASTER where SRPOM_CANCEL_PO=1 and ES_DELETE=0 and SRPOM_CODE='" + e.CommandArgument.ToString() + "'")).Rows[0][0].ToString() == "0") { if (!ModifyLog(e.CommandArgument.ToString())) { string cpom_code = e.CommandArgument.ToString(); string PoType = ""; DataTable dtAuth = CommonClasses.Execute("Select SRPOM_AUTHR_FLAG,SRPOM_TYPE,PO_T_SHORT_NAME from SERVICE_PO_MASTER,PO_TYPE_MASTER where PO_T_CODE=SRPOM_TYPE and SRPOM_CODE='" + cpom_code + "'"); string AuthoFlag = ""; if (dtAuth.Rows[0]["SRPOM_AUTHR_FLAG"].ToString() == "False") { AuthoFlag = "true"; } //if (dtAuth.Rows[0]["SRPOM_TYPE"].ToString() == "-2147483647") if (dtAuth.Rows[0]["PO_T_SHORT_NAME"].ToString().Contains("IMPORT")) { PoType = "Export PO"; } else { PoType = "Domestic PO"; } Response.Redirect("~/RoportForms/ADD/ServiceOrderPrint.aspx?cpom_code=" + cpom_code + "&AuthoType=" + AuthoFlag + "&PoType=" + PoType, false); } //else //{ // PanelMsg.Visible = true; // lblmsg.Text = "Record used by another person"; // return; //} } else { PanelMsg.Visible = true; lblmsg.Text = "You Can't Modify Because it is cancelled"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } else { PanelMsg.Visible = true; lblmsg.Text = "You have no rights to Print"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } #endregion #region Authorize else if (e.CommandName.Equals("Authorize")) { if ((CommonClasses.Execute("select count(*) as counted from SERVICE_PO_MASTER where SRPOM_CANCEL_PO=1 and ES_DELETE=0 and SRPOM_CODE='" + e.CommandArgument.ToString() + "'")).Rows[0][0].ToString() == "0") { int index = Convert.ToInt32(e.CommandArgument); string qe_code = ((Label)dgDetailServicePO.Rows[index].FindControl("lblCPOM_CODE")).Text; CommonClasses.Execute("update SERVICE_PO_MASTER set SRPOM_AUTHR_FLAG=1 where SRPOM_CODE=" + qe_code + ""); CommonClasses.WriteLog("Service Purchase Order ", "Authorize", "Service Purchase Order", qe_code, Convert.ToInt32(qe_code), Convert.ToInt32(Session["CompanyId"]), Convert.ToInt32(Session["CompanyCode"]), (Session["Username"].ToString()), Convert.ToInt32(Session["UserCode"])); } else { PanelMsg.Visible = true; lblmsg.Text = "You Can't Modify Because it is cancelled"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } #endregion #region Post else if (e.CommandName.Equals("Post")) { if ((CommonClasses.Execute("select count(*) as counted from SERVICE_PO_MASTER where SRPOM_CANCEL_PO=1 and ES_DELETE=0 and SRPOM_CODE='" + e.CommandArgument.ToString() + "'")).Rows[0][0].ToString() == "0") { if (!ModifyLog(e.CommandArgument.ToString())) { string cpom_code = e.CommandArgument.ToString(); if (CommonClasses.Execute1("update SERVICE_PO_MASTER set SRPOM_POST=1 where SRPOM_CODE='" + cpom_code + "'")) { CommonClasses.WriteLog("Service Purchase Order ", "Post", "Service Purchase Order", cpom_code, Convert.ToInt32(cpom_code), Convert.ToInt32(Session["CompanyId"]), Convert.ToInt32(Session["CompanyCode"]), (Session["Username"].ToString()), Convert.ToInt32(Session["UserCode"])); LoadServicePO(); PanelMsg.Visible = true; lblmsg.Text = "Record Posted"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } else { PanelMsg.Visible = true; lblmsg.Text = "Record Not Posted"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } //else //{ // PanelMsg.Visible = true; // lblmsg.Text = "Record used by another person"; // return; //} } else { PanelMsg.Visible = true; lblmsg.Text = "You Can't Modify Because it is cancelled"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } #endregion #region Amend else if (e.CommandName.Equals("Amend")) { //string cpom_code = e.CommandArgument.ToString(); //DataTable dt = CommonClasses.Execute("select isnull(SRPOM_POST,0) as SRPOM_POST from SERVICE_PO_MASTER where SRPOM_CODE='" + cpom_code + "' "); //if (dt.Rows.Count > 0) //{ // if (Convert.ToBoolean(dt.Rows[0]["SRPOM_POST"].ToString()) == false) // { // PanelMsg.Visible = true; // lblmsg.Text = "First Post This PO"; // ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); // return; // } // else // { // if (!ModifyLog(e.CommandArgument.ToString())) // { // string type = "AMEND"; // Session["AMEND"] = "AMEND"; // Response.Redirect("~/Transactions/ADD/ServicePurchaseOrder.aspx?c_name=" + type + "&cpom_code=" + cpom_code, false); // } // //else // //{ // // PanelMsg.Visible = true; // // lblmsg.Text = "Record used by another person"; // // return; // //} // } //} if ((CommonClasses.Execute("select count(*) as counted from SERVICE_PO_MASTER where SRPOM_CANCEL_PO=1 and ES_DELETE=0 and SRPOM_CODE='" + e.CommandArgument.ToString() + "'")).Rows[0][0].ToString() == "0") { string cpom_code = e.CommandArgument.ToString(); if (!ModifyLog(e.CommandArgument.ToString())) { DataTable dt = CommonClasses.Execute("select SRPOD_SPOM_CODE,SRPOM_IS_SHORT_CLOSE, sum(SRPOD_ORDER_QTY) AS SRPOD_ORDER_QTY,sum(SRPOD_INW_QTY) AS SRPOD_INW_QTY FROM SERVICE_PO_MASTER,SERVICE_PO_DETAILS WHERE SRPOM_CODE=SRPOD_SPOM_CODE AND SRPOM_CODE='" + cpom_code + "' AND SRPOM_POST=1 Group BY SRPOD_SPOM_CODE,SRPOM_IS_SHORT_CLOSE"); if (dt.Rows.Count > 0) { double ORDER_QTY = Convert.ToDouble(dt.Rows[0]["SRPOD_ORDER_QTY"].ToString()); double INW_QTY = Convert.ToDouble(dt.Rows[0]["SRPOD_INW_QTY"].ToString()); string IS_SHORT_CLOSE = dt.Rows[0]["SRPOM_IS_SHORT_CLOSE"].ToString(); //if (ORDER_QTY - INW_QTY == 0 || INW_QTY == 0 || IS_SHORT_CLOSE == "True") //if (IS_SHORT_CLOSE == "True" || INW_QTY == 0) //{ string type1 = "AMEND"; Session["AMEND"] = "AMEND"; Response.Redirect("~/Transactions/ADD/ServicePurchaseOrder.aspx?c_name=" + type1 + "&cpom_code=" + cpom_code, false); return; //} //else if (INW_QTY > 0) //{ // PanelMsg.Visible = true; // lblmsg.Text = "Couldn't Amend, This is Open Purchase order."; // ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); // return; //} } else { PanelMsg.Visible = true; lblmsg.Text = "First Post This PO"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } else { PanelMsg.Visible = true; lblmsg.Text = "Record used by another person"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } else { PanelMsg.Visible = true; lblmsg.Text = "You Can't Modify Because it is cancelled"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } #endregion #region ShortClose else if (e.CommandName.Equals("ShortClose")) { if ((CommonClasses.Execute("select count(*) as counted from SERVICE_PO_MASTER where SRPOM_CANCEL_PO=1 and ES_DELETE=0 and SRPOM_CODE='" + e.CommandArgument.ToString() + "'")).Rows[0][0].ToString() == "0") { if (!ModifyLog(e.CommandArgument.ToString())) { string cpom_code = e.CommandArgument.ToString(); DataTable dt = CommonClasses.Execute("select isnull(SRPOM_IS_SHORT_CLOSE,0) as SRPOM_IS_SHORT_CLOSE,SRPOM_POST from SERVICE_PO_MASTER where SRPOM_CODE='" + cpom_code + "' AND SRPOM_IS_SHORT_CLOSE=0"); if (dt.Rows.Count > 0) { if ((dt.Rows[0]["SRPOM_POST"]).ToString() == "True") { //DataTable DtInw = CommonClasses.Execute("SELECT MAX (SRPOD_INW_QTY) as SRPOD_INW_QTY FROM SERVICE_PO_MASTER,SERVICE_PO_DETAILS WHERE SRPOM_CODE=SRPOD_SPOM_CODE AND SERVICE_PO_MASTER.ES_DELETE=0 AND SRPOM_CODE='" + cpom_code + "'"); //double INW_QTY = Convert.ToDouble(DtInw.Rows[0]["SRPOD_INW_QTY"].ToString()); //if (INW_QTY > 0) //{ bool Res = CommonClasses.Execute1("UPDATE SERVICE_PO_MASTER SET SRPOM_IS_SHORT_CLOSE=1 WHERE SRPOM_CODE='" + cpom_code + "'"); if (Res == true) { CommonClasses.WriteLog("Service Purchase Order ", "ShortClose", "Service Purchase Order", cpom_code, Convert.ToInt32(cpom_code), Convert.ToInt32(Session["CompanyId"]), Convert.ToInt32(Session["CompanyCode"]), (Session["Username"].ToString()), Convert.ToInt32(Session["UserCode"])); PanelMsg.Visible = true; lblmsg.Text = "Short Close Successfully"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } //} //else //{ // PanelMsg.Visible = true; // lblmsg.Text = "Can Not Short Close Pending for Inward"; // ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); // return; //} } else { PanelMsg.Visible = true; lblmsg.Text = "First Post This PO"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } else { PanelMsg.Visible = true; lblmsg.Text = "Allready Short Closed"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } } else { PanelMsg.Visible = true; lblmsg.Text = "You Can't Modify Because it is cancelled"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } #endregion #region CancelPO else if (e.CommandName.Equals("CancelPO")) { if (!ModifyLog(e.CommandArgument.ToString())) { string cpom_code = e.CommandArgument.ToString(); //if (CommonClasses.CheckUsedInTran("INWARD_MASTER,INWARD_DETAIL", "IWD_CPOM_CODE", "AND IWD_CPOM_CODE=SRPOM_CODE and INWARD_MASTER.ES_DELETE=0", cpom_code)) //{ // PanelMsg.Visible = true; // lblmsg.Text = "You Can't Cancel This PO, It Is Used In Inward Master"; // ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); // return; //} //else //{ if (CommonClasses.Execute1("update SERVICE_PO_MASTER set SRPOM_CANCEL_PO=1 where SRPOM_CODE='" + cpom_code + "'")) { CommonClasses.WriteLog("Service Purchase Order ", "CancelPO", "Service Purchase Order", cpom_code, Convert.ToInt32(cpom_code), Convert.ToInt32(Session["CompanyId"]), Convert.ToInt32(Session["CompanyCode"]), (Session["Username"].ToString()), Convert.ToInt32(Session["UserCode"])); LoadServicePO(); PanelMsg.Visible = true; lblmsg.Text = "PO Canceled"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } else { PanelMsg.Visible = true; lblmsg.Text = "PO Canceled"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } //} } } #endregion } catch (Exception Ex) { CommonClasses.SendError("Service Po Transaction", "dgDetailServicePO_RowCommand", Ex.Message); } }
protected void dgState_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { if (CommonClasses.ValidRights(int.Parse(right.Substring(4, 1)), this, "For Delete")) { if (!ModifyLog(((Label)(dgState.Rows[e.RowIndex].FindControl("lblL_CODE"))).Text)) { string s_code = ((Label)(dgState.Rows[e.RowIndex].FindControl("lblL_CODE"))).Text; string s_name = ((Label)(dgState.Rows[e.RowIndex].FindControl("lblL_NAME"))).Text; if (CommonClasses.CheckUsedInTran("CASH_BOOK_ENTRY", "C_NAME", "AND ES_DELETE=0", s_code)) { PanelMsg.Visible = true; lblmsg.Text = "You can't delete this record because it has used in Cash Book Entry"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); //ShowMessage("#Avisos", "You cant delete this record it has used in city master", CommonClasses.MSG_Warning); } else if (CommonClasses.CheckUsedInTran("CASH_BOOK_ENTRY", "C_L_CODE", "AND ES_DELETE=0", s_code)) { PanelMsg.Visible = true; lblmsg.Text = "You can't delete this record because it has used in Cash Book Entry"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); //ShowMessage("#Avisos", "You cant delete this record it has used in city master", CommonClasses.MSG_Warning); } else { bool flag = CommonClasses.Execute1("UPDATE ACCOUNT_LEDGER SET ES_DELETE = 1 WHERE L_CODE='" + Convert.ToInt32(s_code) + "'"); if (flag == true) { CommonClasses.WriteLog("Account Ledger Master", "Delete", "Account Ledger Master", s_code, Convert.ToInt32(s_code), Convert.ToInt32(Session["CompanyId"]), Convert.ToInt32(Session["CompanyCode"]), (Session["Username"].ToString()), Convert.ToInt32(Session["UserCode"])); // ShowMessage("#Avisos", CommonClasses.strRegDelSucesso, CommonClasses.MSG_Erro); PanelMsg.Visible = true; lblmsg.Text = "Record Deleted Successfully"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); } } //} LoadState(); } else { PanelMsg.Visible = true; lblmsg.Text = "Record Used By Another Person"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); //ShowMessage("#Avisos", "Record Used By Another Person", CommonClasses.MSG_Erro); return; } } else { PanelMsg.Visible = true; lblmsg.Text = "You Have No Rights To Delete"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); // //ShowMessage("#Avisos", "You Have No Rights To Delete", CommonClasses.MSG_Erro); // return; } } catch (Exception Ex) { CommonClasses.SendError("Account Ledger Master", "dgState_RowDeleting", Ex.Message); } }
protected void dgServiceTypeMaster_RowDeleting(object sender, GridViewDeleteEventArgs e) { if (CommonClasses.ValidRights(int.Parse(right.Substring(4, 1)), this, "For Delete")) { if (!ModifyLog(((Label)(dgServiceTypeMaster.Rows[e.RowIndex].FindControl("lblS_CODE"))).Text)) { string i_code = ((Label)(dgServiceTypeMaster.Rows[e.RowIndex].FindControl("lblS_CODE"))).Text; string i_name = ((Label)(dgServiceTypeMaster.Rows[e.RowIndex].FindControl("lblS_NAME"))).Text; string i_codeno = ((Label)(dgServiceTypeMaster.Rows[e.RowIndex].FindControl("lblS_CODENO"))).Text; if (CommonClasses.CheckUsedInTran("SERVICE_PO_MASTER,SERVICE_PO_DETAILS", "SRPOD_I_CODE", "AND SRPOD_SPOM_CODE=SRPOM_CODE and SERVICE_PO_MASTER.ES_DELETE=0", i_code)) { PanelMsg.Visible = true; lblmsg.Text = "You cant delete this record it has used in Service Purchase Order"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } //if (CommonClasses.CheckUsedInTran("CUSTPO_MASTER,CUSTPO_DETAIL", "CPOD_I_CODE", "AND CPOD_CPOM_CODE=CPOM_CODE and CUSTPO_MASTER.ES_DELETE=0", i_code)) //{ // PanelMsg.Visible = true; // lblmsg.Text = "You cant delete this record it has used in Sales Order"; // ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); // return; //} //if (CommonClasses.CheckUsedInTran("ISSUE_MASTER,ISSUE_MASTER_DETAIL ", "IMD_I_CODE", " AND ISSUE_MASTER.IM_CODE=ISSUE_MASTER_DETAIL.IM_CODE AND ISSUE_MASTER.ES_DELETE=0", i_code)) //{ // PanelMsg.Visible = true; // lblmsg.Text = "You cant delete this record it has used in Issue To Production"; // ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); // return; //} //if (CommonClasses.CheckUsedInTran("PRODUCTION_TO_STORE_MASTER,PRODUCTION_TO_STORE_DETAIL ", "PSD_I_CODE", " AND PS_CODE=PSD_PS_CODE AND PRODUCTION_TO_STORE_MASTER.ES_DELETE=0", i_code)) //{ // PanelMsg.Visible = true; // lblmsg.Text = "You cant delete this record it has used in Production TO store"; // ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); // return; //} bool flag = CommonClasses.Execute1("UPDATE SERVICE_TYPE_MASTER SET ES_DELETE = 1 WHERE S_CODE='" + Convert.ToInt32(i_code) + "'"); if (flag == true) { CommonClasses.WriteLog("Service Type Master", "Delete", "Service Type Master", i_name, Convert.ToInt32(i_code), Convert.ToInt32(Session["CompanyId"]), Convert.ToInt32(Session["CompanyCode"]), (Session["Username"].ToString()), Convert.ToInt32(Session["UserCode"])); //ShowMessage("#Avisos", CommonClasses.strRegDelSucesso, CommonClasses.MSG_Erro); PanelMsg.Visible = true; lblmsg.Text = "Record Deleted Successfully"; LoadItem(); ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); } } else { PanelMsg.Visible = true; lblmsg.Text = "Record Used By Another Person"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } } else { //ShowMessage("#Avisos", "You Have No Rights To Delete", CommonClasses.MSG_Erro); PanelMsg.Visible = true; lblmsg.Text = "You Have No Rights To Delete"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); return; } }
protected void dgSalesTaxMaster_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { if (CommonClasses.ValidRights(int.Parse(right.Substring(4, 1)), this, "For Delete")) { if (!ModifyLog(((Label)(dgSalesTaxMaster.Rows[e.RowIndex].FindControl("lblST_CODE"))).Text)) { BL_SalesTaxMAster = new SalesTaxMaster_BL(); string ST_CODE = ((Label)(dgSalesTaxMaster.Rows[e.RowIndex].FindControl("lblST_CODE"))).Text; string ST_TAX_NAME = ((Label)(dgSalesTaxMaster.Rows[e.RowIndex].FindControl("lblST_TAX_NAME"))).Text; string ST_ALIAS = ((Label)(dgSalesTaxMaster.Rows[e.RowIndex].FindControl("lblST_ALIAS"))).Text; string ST_SALES_TAX = ((Label)(dgSalesTaxMaster.Rows[e.RowIndex].FindControl("lblST_SALES_TAX"))).Text; string ST_TCS_TAX = ((Label)(dgSalesTaxMaster.Rows[e.RowIndex].FindControl("lblST_TCS_TAX"))).Text; // string ST_SET_OFF = ((Label)(dgSalesTaxMaster.Rows[e.RowIndex].FindControl("lblST_SET_OFF"))).Text; string ST_FORM_NO = ((Label)(dgSalesTaxMaster.Rows[e.RowIndex].FindControl("lblST_FORM_NO"))).Text; string ST_SALES_ACC_HEAD = ((Label)(dgSalesTaxMaster.Rows[e.RowIndex].FindControl("lblST_SALES_ACC_HEAD"))).Text; string ST_TAX_ACC_HEAD = ((Label)(dgSalesTaxMaster.Rows[e.RowIndex].FindControl("lblST_TAX_ACC_HEAD"))).Text; BL_SalesTaxMAster.ST_CODE = Convert.ToInt32(ST_CODE); if (CommonClasses.CheckUsedInTran("ITEM_MASTER", "I_ACCOUNT_SALES", "AND ES_DELETE=0", ST_CODE)) { PanelMsg.Visible = true; lblmsg.Text = "You cant delete this record it has used in Item Master"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); // ShowMessage("#Avisos", "You cant delete this record it has used in Sales Tax Master", CommonClasses.MSG_Warning); } else if (CommonClasses.CheckUsedInTran("ITEM_MASTER", "I_ACCOUNT_PURCHASE", "AND ES_DELETE=0", ST_CODE)) { PanelMsg.Visible = true; lblmsg.Text = "You cant delete this record it has used in Item Master"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); // ShowMessage("#Avisos", "You cant delete this record it has used in Sales Tax Master", CommonClasses.MSG_Warning); } else { bool flag = BL_SalesTaxMAster.Delete(); if (flag == true) { CommonClasses.WriteLog("Sales Tax Master", "Delete", "Sales Tax Master", ST_CODE, Convert.ToInt32(ST_CODE), Convert.ToInt32(Session["CompanyId"]), Convert.ToInt32(Session["CompanyCode"]), (Session["Username"].ToString()), Convert.ToInt32(Session["UserCode"])); //ShowMessage("#Avisos", CommonClasses.strRegDelSucesso, CommonClasses.MSG_Erro); PanelMsg.Visible = true; lblmsg.Text = "Record Deleted Successfully"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); } LoadSalesTaxMasterDetails(); } } } else { PanelMsg.Visible = true; lblmsg.Text = "You Have No Rights To Delete"; ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true); //ShowMessage("#Avisos", "You Have No Rights To Delete", CommonClasses.MSG_Erro); return; } } catch (Exception Ex) { CommonClasses.SendError("Saltes Tax Master", "dgSalesTaxMaster_RowDeleting", Ex.Message); } }