protected void btnsave_Click(object sender, System.EventArgs e) { try { if (Fk_CustomerID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Select Customer.<br>"; } if (SPI_No.Text.Length == 0) { ErrorMessage = ErrorMessage + "Customer Invoice No Cannot Be Blank.<br>"; } if (SPI_ShippedFrom_State_ID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Place Of Dispatch<br>"; } if (SPI_ShippTo_State_ID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Place Of Supply<br>"; } if (SPI_ShippTo_GSTNo.Text.Length != 15) { ErrorMessage = ErrorMessage + "Invalid Ship To GSTNO<br>"; } if (SPI_ShippTo_PANNO.Text.Length != 10) { ErrorMessage = ErrorMessage + "Invalid Ship To PAN No<br>"; } if ((SPI_No.Text.Length > 0) && (Fk_CustomerID.SelectedIndex > 0)) { if (SQLManager.CheckDuplicateRecord("M_AT_Sales_Inv_AHDR", "SPIHDR_ID", Convert.ToInt32("0" + SPIHDR_ID.Text), "SPI_No", SPI_No.Text, " AND Fk_Branch_ID=" + SessionUserData.Company.BranchID)) { ErrorMessage = ErrorMessage + "Customer Invoice Already Exist.<br>"; } } if (SPI_DT.Text.Length != 11) { ErrorMessage = ErrorMessage + "Invalid Customer Invoice Date.<br>"; } if ((Fk_CustomerID.SelectedIndex > 0) && (Convert.ToInt32(SPIHDR_ID.Text) == 0)) { if (Fk_MItem_ID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Pls Select Item<br>"; } if (SPI_BasicRate.Text.Length == 0) { ErrorMessage = ErrorMessage + "Invalid Item Rate<br>"; } if (SPI_QTY.Text.Length == 0) { ErrorMessage = ErrorMessage + "Invalid Item Quantity<br>"; } else { if (Convert.ToDecimal(SPI_QTY.Text) <= 0) { ErrorMessage = ErrorMessage + "Invalid Item Quantity<br>"; } } } if ((Convert.ToInt32(SPIHDR_ID.Text) > 0) && (Convert.ToInt32(SPIDTL_ID.Text) > 0) && (Fk_MItem_ID.SelectedIndex > 0)) { if (Fk_MItem_ID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Pls Select Item<br>"; } if (SPI_BasicRate.Text.Length == 0) { ErrorMessage = ErrorMessage + "Invalid Item Rate<br>"; } if (SPI_QTY.Text.Length == 0) { ErrorMessage = ErrorMessage + "Invalid Item Quantity<br>"; } else { if (Convert.ToDecimal(SPI_QTY.Text) <= 0) { ErrorMessage = ErrorMessage + "Invalid Item Quantity<br>"; } } } if (ErrorMessage.Length == 0) { using (TransactionScope scope = new TransactionScope()) { if (Convert.ToInt32(SPIHDR_ID.Text) == 0) { ObjAT_SPI_HDR.Fk_Company_ID = SessionUserData.Company.CompanyID; ObjAT_SPI_HDR.Fk_Branch_ID = SessionUserData.Company.BranchID; ObjAT_SPI_HDR.Fk_Year_ID = SessionUserData.Company.YearID; ObjAT_SPI_HDR.Rec_Created_In = "HO"; ObjAT_SPI_HDR.Rec_CreatedBy_ID = SessionUserData.Company.BranchID; ObjAT_SPI_HDR.Rec_CreatedFor_ID = SessionUserData.Company.BranchID; ObjAT_SPI_HDR.SPI_CreationType = "Manual"; ObjAT_SPI_HDR.SPI_Category = ""; ObjAT_SPI_HDR.MDBSC_RowCreatedByUserName = SessionUserData.UserData.UserName; ObjAT_SPI_HDR.MDBSC_RowCreatedByUser_ID = SessionUserData.UserData.UserID; ObjAT_SPI_HDR.SPI_No = MEF.GenrateRefNo(SessionUserData.Company.CompanyID, SessionUserData.Company.BranchID, SessionUserData.Company.YearID, "Proforma Invoice", "SPI", "SPI", "Yes", "", "", "", 0); } SetValuesToBO_HDR(); ErrorMessage = ObjAT_SPI_HDR.Insert_Update(ObjAT_SPI_HDR); SPIHDR_ID.Text = ErrorMessage.Substring((ErrorMessage.IndexOf("|") + 1), (ErrorMessage.Length - ErrorMessage.IndexOf("|") - 1)); ErrorMessage = ErrorMessage.Substring((0), (ErrorMessage.IndexOf("|"))); if ((Convert.ToInt32(SPIHDR_ID.Text) > 0) && (Fk_MItem_ID.SelectedIndex > 0)) { if (Convert.ToInt32(SPIDTL_ID.Text) == 0) { ObjAT_SPI_DTL.MDBSC_RowCreatedByUser_ID = SessionUserData.UserData.UserID; ObjAT_SPI_DTL.MDBSC_RowCreatedByUserName = SessionUserData.UserData.UserName; } ObjAT_SPI_DTL.SPIDTL_ID = Convert.ToInt64("0" + SPIDTL_ID.Text); ObjAT_SPI_DTL.Fk_SPIHDR_ID = Convert.ToInt64("0" + SPIHDR_ID.Text); ObjAT_SPI_DTL.Fk_MItem_ID = Convert.ToInt64("0" + Fk_MItem_ID.Text); ObjAT_SPI_DTL.SPI_HSNCode = SPI_HSNCode.Text; ObjAT_SPI_DTL.SPI_QTY = Convert.ToDecimal(SPI_QTY.Text); ObjAT_SPI_DTL.SPI_Final_Qty = Convert.ToDecimal(SPI_QTY.Text); ObjAT_SPI_DTL.SPI_BasicRate = Convert.ToDecimal(SPI_BasicRate.Text); ObjAT_SPI_DTL.SPI_DiscountRate = Convert.ToDecimal(SPI_DiscountRate.Text); ObjAT_SPI_DTL.SPI_CGST_ID = 0; ObjAT_SPI_DTL.SPI_SGST_ID = 0; ObjAT_SPI_DTL.SPI_IGST_ID = 0; ObjAT_SPI_DTL.SPI_CESS_ID = 0; ObjAT_SPI_DTL.SPI_ItemRemark_DTL = SPI_ItemRemark_DTL.Text; ObjAT_SPI_DTL.MDBSC_RowLupdnByUser_ID = SessionUserData.UserData.UserID; ObjAT_SPI_DTL.MDBSC_RowLupdnUserName = SessionUserData.UserData.UserName; ObjAT_SPI_DTL.MDBSC_RowLupdnOn_DT = DateHelper.ConvertToDataBase(DateHelper.ConvertToForm(DateTime.Now)); ObjAT_SPI_DTL.Insert_Update(ObjAT_SPI_DTL); } scope.Complete(); } MABL.SQLManager.SQLProcedureCall.USP_Update_Tbl_Sales_PI(Convert.ToInt32(SPIHDR_ID.Text)); SetValueToControls_Edit_HDR(Convert.ToInt32("0" + SPIHDR_ID.Text)); // DisplayCustomMessageSummary(ErrorMessage); } else { // DisplayCustomMessageSummary(ErrorMessage); } Msg_ErrorMsg.Text = ErrorMessage; } catch (Exception ex) { DisplayCustomMessageSummary("Failed Save Data"); } }
protected void btnsave_Click(object sender, System.EventArgs e) { try { if (SQLManager.CheckDuplicateRecord("M_AT_Mst_ItemMaster", "MItem_ID", Convert.ToInt32("0" + MItem_ID.Text), "Item_Name", Item_Name.Text, "")) { ErrorMessage = ErrorMessage + "Item Already Exist.<br>"; } if (Item_Name.Text.Length == 0) { ErrorMessage = ErrorMessage + "Item Name Cannot Be Blank<br>"; } if (UOM_ID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Select Unit Of Measurment<br>"; } if (Item_Tax_GST_ID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Select Integrated Tax Rate<br>"; } if (Item_Tax_GST_Effective_From.Text.Length != 11) { ErrorMessage = ErrorMessage + "Invalid Integrated Tax Rate Effective From Date<br>"; } if (Item_Code.Text.Length == 0) { ErrorMessage = ErrorMessage + "Invalid Item Code <br>"; } if (ErrorMessage.Length == 0) { using (TransactionScope scope = new TransactionScope()) { if (Convert.ToInt32(MItem_ID.Text) == 0) { ObjBOAT_Item.Fk_Company_ID = SessionUserData.Company.CompanyID; ObjBOAT_Item.Fk_Branch_ID = SessionUserData.Company.BranchID; ObjBOAT_Item.Fk_Year_ID = SessionUserData.Company.YearID; ObjBOAT_Item.MDBSC_RowCreatedByUser_ID = SessionUserData.UserData.UserID; ObjBOAT_Item.MDBSC_RowCreatedByUserName = SessionUserData.UserData.UserName; ObjBOAT_Item.Item_SRNO = 0; ObjBOAT_Item.Fk_MIC_ID = 1; ObjBOAT_Item.Fk_IG_ID = 1; ObjBOAT_Item.Fk_ISG_ID = 1; ObjBOAT_Item.Item_Code = MEF.GenrateRefNo(SessionUserData.Company.CompanyID, SessionUserData.Company.BranchID, 0, "Item", "IC", "IC", "No", "", "", "", 0); } SetValuesToBO(); ErrorMessage = ObjBOAT_Item.Insert_Update(ObjBOAT_Item); MItem_ID.Text = ErrorMessage.Substring((ErrorMessage.IndexOf("|") + 1), (ErrorMessage.Length - ErrorMessage.IndexOf("|") - 1)); ErrorMessage = ErrorMessage.Substring((0), (ErrorMessage.IndexOf("|"))); scope.Complete(); } SetValueToControls_Edit(Convert.ToInt64(MItem_ID.Text)); DisplayCustomMessageSummary(ErrorMessage); } else { DisplayCustomMessageSummary(ErrorMessage); } } catch (Exception ex) { DisplayCustomMessageSummary("Failed Save Data"); } }
//SAVE public static string CU_Mst_Item(M_AT_Mst_ItemMasterBO ObjItem) { M_AT_Mst_ItemMasterBO ObjBOAT_Item = new M_AT_Mst_ItemMasterBO(); string strRetMst = ""; DataTable dt = new DataTable(); string var_ErrorMessage = ""; try { if (ObjItem.Item_Name.Length == 0) { var_ErrorMessage = var_ErrorMessage + "Item Name Cannot Be Blank \n"; } if (SQLManager.CheckDuplicateRecord("M_AT_Mst_ItemMaster", "MItem_ID", Convert.ToInt32("0" + ObjItem.MItem_ID), "Item_Name", ObjItem.Item_Name, " AND Fk_Company_ID=" + ObjItem.Fk_Company_ID + " AND Fk_Branch_ID=" + ObjItem.Fk_Branch_ID)) { var_ErrorMessage = var_ErrorMessage + "Item Already Exist. \n"; } if (SQLManager.CheckDuplicateRecord("M_AT_Mst_ItemMaster", "MItem_ID", Convert.ToInt32("0" + ObjItem.MItem_ID), "HSNCode", ObjItem.HSNCode, " AND Fk_Company_ID=" + ObjItem.Fk_Company_ID + " AND Fk_Branch_ID=" + ObjItem.Fk_Branch_ID)) { var_ErrorMessage = var_ErrorMessage + "Item Already Exist. \n"; } if (ObjItem.Fk_UOM_ID <= 0) { var_ErrorMessage = var_ErrorMessage + "Select Unit Of Measurment \n"; } if (ObjItem.Item_Tax_GST_ID <= 0) { var_ErrorMessage = var_ErrorMessage + "Select Integrated Tax Rate\n"; } if (ObjItem.Item_Tax_GST_Effective_From.Length != 11) { var_ErrorMessage = var_ErrorMessage + "Invalid Integrated Tax Rate Effective From Date\n"; } if (ObjItem.Item_Code.Length == 0) { var_ErrorMessage = var_ErrorMessage + "Invalid Item Code \n"; } if (var_ErrorMessage.Length == 0) { using (TransactionScope scope = new TransactionScope()) { if (Convert.ToInt32(ObjItem.MItem_ID) == 0) { ObjBOAT_Item.Fk_Company_ID = ObjItem.Fk_Company_ID; ObjBOAT_Item.Fk_Branch_ID = ObjItem.Fk_Branch_ID; ObjBOAT_Item.Fk_Year_ID = ObjItem.Fk_Year_ID; ObjBOAT_Item.MDBSC_RowCreatedByUser_ID = ObjItem.MDBSC_RowCreatedByUser_ID; ObjBOAT_Item.MDBSC_RowCreatedByUserName = ObjItem.MDBSC_RowCreatedByUserName; ObjBOAT_Item.Item_SRNO = 0; ObjBOAT_Item.Fk_MIC_ID = 1; ObjBOAT_Item.Fk_IG_ID = 1; ObjBOAT_Item.Fk_ISG_ID = 1; ObjBOAT_Item.Item_Code = MEF.GenrateRefNo(ObjItem.Fk_Company_ID, ObjItem.Fk_Branch_ID, 0, "Item", "I-", "I-", "No", "", "", "", 0); } ObjBOAT_Item.MItem_ID = ObjItem.MItem_ID; ObjBOAT_Item.Item_Type = ObjItem.Item_Type; ObjBOAT_Item.Fk_UOM_ID = ObjItem.Fk_UOM_ID; ObjBOAT_Item.Item_Name = ObjItem.Item_Name; ObjBOAT_Item.HSNCode = ObjItem.HSNCode; ObjBOAT_Item.Fk_HSN_ID = ObjItem.Fk_HSN_ID; ObjBOAT_Item.HSN_Desc = ObjItem.HSN_Desc; ObjBOAT_Item.Item_Tax_GST_ID = ObjItem.Item_Tax_GST_ID; //decimal var_Tax_GST_Rate = Convert.ToDecimal(Item_Tax_GST_ID.SelectedItem.Text); //decimal var_Tax_SGST_Rate = Math.Round((var_Tax_GST_Rate / 2), 2); ObjBOAT_Item.Item_CGST_Rate = ObjItem.Item_CGST_Rate; ObjBOAT_Item.Item_SGST_Rate = ObjItem.Item_SGST_Rate; ObjBOAT_Item.Item_IGST_Rate = ObjItem.Item_IGST_Rate; if (ObjItem.Item_Tax_GST_Effective_From.Length == 11) { ObjBOAT_Item.Item_Tax_GST_Effective_From = ObjItem.Item_Tax_GST_Effective_From; } ObjBOAT_Item.Item_CESS_Rate = ObjItem.Item_CESS_Rate; ObjBOAT_Item.Item_Tax_CESS_ID = ObjItem.Item_Tax_CESS_ID; ObjBOAT_Item.Item_Selling_Rate = ObjItem.Item_Selling_Rate; ObjBOAT_Item.Item_Purchase_Rate = ObjItem.Item_Purchase_Rate; ObjBOAT_Item.Item_Desc = ObjItem.Item_Desc; ObjBOAT_Item.MDBSC_RowStatus = ObjItem.MDBSC_RowStatus; ObjBOAT_Item.MDBSC_RowLupdnByUser_ID = ObjItem.MDBSC_RowLupdnByUser_ID; ObjBOAT_Item.MDBSC_RowLupdnUserName = ObjItem.MDBSC_RowLupdnUserName; ObjBOAT_Item.MDBSC_RowLupdnOn_DT = DateHelper.ConvertToDataBase(DateHelper.ConvertToForm(DateTime.Now)); var_ErrorMessage = ObjBOAT_Item.Insert_Update(ObjBOAT_Item); //ObjItem.MItem_ID =Convert.ToInt64( var_ErrorMessage.Substring((var_ErrorMessage.IndexOf("|") + 1), (var_ErrorMessage.Length - var_ErrorMessage.IndexOf("|") - 1))); //var_ErrorMessage = var_ErrorMessage.Substring((0), (var_ErrorMessage.IndexOf("|"))); scope.Complete(); } strRetMst = var_ErrorMessage; } else { strRetMst = var_ErrorMessage + "|" + ObjItem.MItem_ID.ToString(); } return(strRetMst); } catch (Exception ex) { throw new Exception(ex.Message); } }
protected void btnsave_Click(object sender, System.EventArgs e) { try { if (VP_DT.Text.Length != 11) { ErrorMessage = ErrorMessage + "Invalid Entry Date<br>"; } if (VP_No.Text.Length == 0) { ErrorMessage = ErrorMessage + "Invalid Ref No<br>"; } if (Fk_VendorID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Pls Select Customer<br>"; } if (VP_Received_Amt.Text.Length == 0) { ErrorMessage = ErrorMessage + "Received Amount Cannot Be Zero Or Blank<br>"; } else { if (Convert.ToDecimal(VP_Received_Amt.Text) <= 0) { ErrorMessage = ErrorMessage + "Received Amount Cannot Be Zero Or Blank<br>"; } } decimal var_T_Received_Amt = Convert.ToDecimal(VP_Received_Amt.Text); decimal var_T_Adjusted_Amt = Convert.ToDecimal(VP_Adjusted_Amt.Text); decimal var_T_OnAccount_Amt = Convert.ToDecimal(VP_OnAccount_Amt.Text); decimal var_T_InvAdjust_Amt = 0; foreach (GridViewRow row in gv_VP_Inv.Rows) { TextBox gv_Inv_Adjusted_Amt = (TextBox)row.FindControl("Inv_Adjusted_Amt"); if (Convert.ToDecimal(gv_Inv_Adjusted_Amt.Text) > 0) { var_T_InvAdjust_Amt = var_T_InvAdjust_Amt + Convert.ToDecimal(gv_Inv_Adjusted_Amt.Text); } } if (var_T_Received_Amt < var_T_InvAdjust_Amt) { ErrorMessage = ErrorMessage + "Sum Of Adjust Amount In Invoice Cannot Be Greater Than Received Amount <br> Adjusted Amt Sum : " + var_T_InvAdjust_Amt; } if (ErrorMessage.Length == 0) { using (TransactionScope scope = new TransactionScope()) { if (Convert.ToInt32(AVPHDR_ID.Text) == 0) { ObjAT_VPHDR.Fk_Company_ID = SessionUserData.Company.CompanyID; ObjAT_VPHDR.Fk_Branch_ID = SessionUserData.Company.BranchID; ObjAT_VPHDR.Fk_Year_ID = SessionUserData.Company.YearID; ObjAT_VPHDR.Rec_Created_In = "Self"; ObjAT_VPHDR.Rec_CreatedBy_ID = SessionUserData.Company.BranchID; ObjAT_VPHDR.Rec_CreatedFor_ID = SessionUserData.Company.BranchID; ObjAT_VPHDR.VP_CreationType = "Manually"; ObjAT_VPHDR.PC_Type = ""; ObjAT_VPHDR.MDBSC_RowCreatedByUser_ID = SessionUserData.UserData.UserID; ObjAT_VPHDR.MDBSC_RowCreatedByUserName = SessionUserData.UserData.UserName; ObjAT_VPHDR.VP_No = MEF.GenrateRefNo(SessionUserData.Company.CompanyID, SessionUserData.Company.BranchID, SessionUserData.Company.YearID, "Vendor Payment", "VP", "VP", "No", "", "", "", 0); } SetValuesToBO(); ErrorMessage = ObjAT_VPHDR.Insert_Update(ObjAT_VPHDR); AVPHDR_ID.Text = ErrorMessage.Substring((ErrorMessage.IndexOf("|") + 1), (ErrorMessage.Length - ErrorMessage.IndexOf("|") - 1)); ErrorMessage = ErrorMessage.Substring((0), (ErrorMessage.IndexOf("|"))); foreach (GridViewRow row in gv_VP_Inv.Rows) { TextBox gv_Inv_Adjusted_Amt = (TextBox)row.FindControl("Inv_Adjusted_Amt"); if (Convert.ToDecimal(gv_Inv_Adjusted_Amt.Text) > 0) { ObjAT_VPDTL = new M_AT_Acc_Payment_Vendor_BDTLBO(); ObjAT_VPDTL.AVPDTL_ID = Convert.ToInt64(row.Cells[0].Text); ObjAT_VPDTL.Fk_AVPHDRID = Convert.ToInt64(AVPHDR_ID.Text); ObjAT_VPDTL.Fk_InvoiceID = Convert.ToInt64(row.Cells[2].Text); ObjAT_VPDTL.Inv_Adjusted_Amt = Convert.ToDecimal(gv_Inv_Adjusted_Amt.Text); ErrorMessage = ObjAT_VPDTL.Insert_Update(ObjAT_VPDTL); ErrorMessage = ErrorMessage.Substring((0), (ErrorMessage.IndexOf("|"))); } else { if (Convert.ToInt64(row.Cells[0].Text) > 0) { MaheshAF18.Application.SQLManager.DeleteSRMD("M_AT_Acc_Payment_Vendor_AHDR", "M_AT_Acc_Payment_Vendor_BDTL", "AVPHDR_ID", Convert.ToInt64(0 + row.Cells[1].Text), "AVPDTL_ID", Convert.ToInt64(0 + row.Cells[0].Text), "C", ""); } } } scope.Complete(); } MABL.SQLManager.SQLProcedureCall.USP_Update_Tbl_Payment_Vendor(Convert.ToInt32(AVPHDR_ID.Text)); SetValueToControls_Edit(Convert.ToInt64(AVPHDR_ID.Text)); DisplayCustomMessageSummary(ErrorMessage); } else { DisplayCustomMessageSummary(ErrorMessage); } } catch (Exception ex) { DisplayCustomMessageSummary("Failed Save Data"); } }
protected void btnsave_Click(object sender, System.EventArgs e) { try { if (DCNC_Reason.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Pls Select Reason.<br>"; } if (DCNC_No.Text.Length == 0) { ErrorMessage = ErrorMessage + "Ref No Cannot Be Blank.<br>"; } if (DCNC_DT.Text.Length != 11) { ErrorMessage = ErrorMessage + "Invalid Entry Date.<br>"; } if (DCNC_ShippTo_State_ID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Invalid Place Of Supply.<br>"; } if ((Convert.ToInt64(Fk_INVHDR_ID.Text) > 0) && (Convert.ToInt64(DCNCHDR_ID.Text) == 0)) { if (Fk_MItem_ID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Pls Select Item<br>"; } if (DCNC_BasicRate.Text.Length == 0) { ErrorMessage = ErrorMessage + "Invalid Item Rate<br>"; } if (DCNC_QTY.Text.Length == 0) { ErrorMessage = ErrorMessage + "Invalid Item Quantity<br>"; } } if ((Convert.ToInt32(DCNCHDR_ID.Text) > 0) && (Convert.ToInt32(DCNCDTL_ID.Text) > 0) && (Fk_MItem_ID.SelectedIndex > 0)) { if (Fk_MItem_ID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Pls Select Item<br>"; } if (DCNC_BasicRate.Text.Length == 0) { ErrorMessage = ErrorMessage + "Invalid Item Rate<br>"; } if (DCNC_QTY.Text.Length == 0) { ErrorMessage = ErrorMessage + "Invalid Item Quantity<br>"; } } if (ErrorMessage.Length == 0) { using (TransactionScope scope = new TransactionScope()) { if (Convert.ToInt32(DCNCHDR_ID.Text) == 0) { ObjAT_DCNCHDR.Fk_Company_ID = SessionUserData.Company.CompanyID; ObjAT_DCNCHDR.Fk_Branch_ID = SessionUserData.Company.BranchID; ObjAT_DCNCHDR.Fk_Year_ID = SessionUserData.Company.YearID; ObjAT_DCNCHDR.Rec_Created_In = "HO"; ObjAT_DCNCHDR.Rec_CreatedBy_ID = SessionUserData.Company.BranchID; ObjAT_DCNCHDR.Rec_CreatedFor_ID = SessionUserData.Company.BranchID; ObjAT_DCNCHDR.DCNC_CreationType = "Manual"; ObjAT_DCNCHDR.Fk_INVHDR_ID = Convert.ToInt64(Fk_INVHDR_ID.Text); ObjAT_DCNCHDR.MDBSC_RowCreatedByUserName = SessionUserData.UserData.UserName; ObjAT_DCNCHDR.MDBSC_RowCreatedByUser_ID = SessionUserData.UserData.UserID; ObjAT_DCNCHDR.DCNC_No = MEF.GenrateRefNo(SessionUserData.Company.CompanyID, SessionUserData.Company.BranchID, SessionUserData.Company.YearID, "DCN", "DCN", "DCN", "Yes", "", "", "", 0); ObjAT_DCNCHDR.DCNC_Type = DCNC_Type.Text; } SetValuesToBO_HDR(); ErrorMessage = ObjAT_DCNCHDR.Insert_Update(ObjAT_DCNCHDR); DCNCHDR_ID.Text = ErrorMessage.Substring((ErrorMessage.IndexOf("|") + 1), (ErrorMessage.Length - ErrorMessage.IndexOf("|") - 1)); ErrorMessage = ErrorMessage.Substring((0), (ErrorMessage.IndexOf("|"))); if (Convert.ToInt32(DCNCHDR_ID.Text) > 0) { if (Convert.ToInt32(DCNCDTL_ID.Text) == 0) { ObjAT_DCNCDTL.MDBSC_RowCreatedByUser_ID = SessionUserData.UserData.UserID; ObjAT_DCNCDTL.MDBSC_RowCreatedByUserName = SessionUserData.UserData.UserName; } ObjAT_DCNCDTL.DCNCDTL_ID = Convert.ToInt64("0" + DCNCDTL_ID.Text); ObjAT_DCNCDTL.Fk_DCNCHDR_ID = Convert.ToInt64("0" + DCNCHDR_ID.Text); ObjAT_DCNCDTL.Fk_MItem_ID = Convert.ToInt64("0" + Fk_MItem_ID.Text); ObjAT_DCNCDTL.DCNC_HSNCode = DCNC_HSNCode.Text; ObjAT_DCNCDTL.DCNC_QTY = Convert.ToDecimal(DCNC_QTY.Text); ObjAT_DCNCDTL.DCNC_BasicRate = Convert.ToDecimal(DCNC_BasicRate.Text); ObjAT_DCNCDTL.DCNC_DiscountRate = Convert.ToDecimal(DCNC_DiscountRate.Text); ObjAT_DCNCDTL.DCNC_ItemRemark_DTL = DCNC_ItemRemark_DTL.Text; ObjAT_DCNCDTL.MDBSC_RowLupdnByUser_ID = SessionUserData.UserData.UserID; ObjAT_DCNCDTL.MDBSC_RowLupdnUserName = SessionUserData.UserData.UserName; ObjAT_DCNCDTL.MDBSC_RowLupdnOn_DT = DateHelper.ConvertToDataBase(DateHelper.ConvertToForm(DateTime.Now)); ObjAT_DCNCDTL.Insert_Update(ObjAT_DCNCDTL); } scope.Complete(); } MABL.SQLManager.SQLProcedureCall.USP_Update_Tbl_DCN_Cust(SessionUserData.Company.CompanyID, SessionUserData.Company.BranchID, SessionUserData.Company.YearID, Convert.ToInt32(DCNCHDR_ID.Text)); SetValueToControls_Edit_HDR(Convert.ToInt32("0" + DCNCHDR_ID.Text)); // DisplayCustomMessageSummary(ErrorMessage); } else { // DisplayCustomMessageSummary(ErrorMessage); } Msg_ErrorMsg.Text = ErrorMessage; } catch (Exception ex) { DisplayCustomMessageSummary("Failed Save Data"); } }