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");
}
}