public bool GetWebUpdate()
{
bool result = false;
try
{
string s = "UPDATE TBL_TRANSFTERDISPLAYDATETIME SET WLDbStatus='1' WHERE ID=@ID";
SqlParameter spID = new SqlParameter();
spID.ParameterName = "@ID";
spID.SqlDbType = System.Data.SqlDbType.NVarChar;
spID.Value = this.ID;
WebConnecString.ConString = WebConnString();
WebConnecString.CmdType = CommandType.Text;
WebConnecString.CmdString = s;
WebConnecString.InsertRecord(spID);
//local update
SqlCeParameter spID1 = new SqlCeParameter();
spID1.ParameterName = "@ID";
spID1.SqlDbType = System.Data.SqlDbType.NVarChar;
spID1.Value = this.ID;
LocConnecString.ConString = LocalConnString();
LocConnecString.CmdType = CommandType.Text;
LocConnecString.CmdString = s;
LocConnecString.InsertRecord(spID1);
result = true;
}
catch (Exception ex)
{
}
return(result);
}
public void InsertTenderDtls()
{
try
{
SqlParameter spDocumentID = new SqlParameter();
spDocumentID.ParameterName = "@DocumentID";
spDocumentID.SqlDbType = System.Data.SqlDbType.NVarChar;
spDocumentID.Value = DocumentID;
SqlParameter spLocationID = new SqlParameter();
spLocationID.ParameterName = "@LocationID";
spLocationID.SqlDbType = System.Data.SqlDbType.NVarChar;
spLocationID.Value = LocationID;
SqlParameter spTerminalID = new SqlParameter();
spTerminalID.ParameterName = "@TerminalID";
spTerminalID.SqlDbType = System.Data.SqlDbType.NVarChar;
spTerminalID.Value = TerminalID;
SqlParameter spCompanyID = new SqlParameter();
spCompanyID.ParameterName = "@CompanyID";
spCompanyID.SqlDbType = System.Data.SqlDbType.NVarChar;
spCompanyID.Value = CompanyID;
SqlParameter spStorageID = new SqlParameter();
spStorageID.ParameterName = "@StorageID";
spStorageID.SqlDbType = System.Data.SqlDbType.NVarChar;
spStorageID.Value = StorageID;
SqlParameter spCustomerID = new SqlParameter();
spCustomerID.ParameterName = "@CustomerID";
spCustomerID.SqlDbType = System.Data.SqlDbType.NVarChar;
if (!CustomerID.Equals(string.Empty))
{
spCustomerID.Value = CustomerID;
}
else
{
spCustomerID.Value = DBNull.Value;
}
SqlParameter spTenderID = new SqlParameter();
spTenderID.ParameterName = "@TenderID";
spTenderID.SqlDbType = System.Data.SqlDbType.NVarChar;
spTenderID.Value = TenderID;
SqlParameter spPostingType = new SqlParameter();
spPostingType.ParameterName = "@PostingType";
spPostingType.SqlDbType = System.Data.SqlDbType.NVarChar;
spPostingType.Value = PostingType;
SqlParameter spCounter = new SqlParameter();
spCounter.ParameterName = "@Counter";
spCounter.SqlDbType = System.Data.SqlDbType.Int;
spCounter.Value = Counter;
SqlParameter spDocumentDate = new SqlParameter();
spDocumentDate.ParameterName = "@DocumentDate";
spDocumentDate.SqlDbType = System.Data.SqlDbType.DateTime;
spDocumentDate.Value = DocumentDate;
SqlParameter spPostingDate = new SqlParameter();
spPostingDate.ParameterName = "@PostingDate";
spPostingDate.SqlDbType = System.Data.SqlDbType.Date;
spPostingDate.Value = PostingDate;
SqlParameter spAmount = new SqlParameter();
spAmount.ParameterName = "@Amount";
spAmount.SqlDbType = System.Data.SqlDbType.Decimal;
spAmount.Value = Amount;
SqlParameter spChangeAmount = new SqlParameter();
spChangeAmount.ParameterName = "@ChangeAmount";
spChangeAmount.SqlDbType = System.Data.SqlDbType.Decimal;
spChangeAmount.Value = ChangeAmount;
SqlParameter spPaidAmount = new SqlParameter();
spPaidAmount.ParameterName = "@PaidAmount";
spPaidAmount.SqlDbType = System.Data.SqlDbType.Decimal;
spPaidAmount.Value = PaidAmount;
SqlParameter spTransCode = new SqlParameter();
spTransCode.ParameterName = "@TransCode";
spTransCode.SqlDbType = System.Data.SqlDbType.NVarChar;
spTransCode.Value = TransCode;
string TenderDtls = "INSERT INTO TBL_TENDER_DETAIL(DOCUMENTID,LOCATIONID,TERMINALID,COUNTER,COMPANYID,STORAGEID,DOCUMENTDATE,POSTINGTYPE,POSTINGDATE,CUSTOMERID,TENDERID,AMOUNT,PAIDAMOUNT,CHANGEAMOUNT,TRANSCODE) VALUES(@DOCUMENTID,@LOCATIONID,@TERMINALID,@COUNTER,@COMPANYID," +
" @STORAGEID,@DOCUMENTDATE,@POSTINGTYPE,@POSTINGDATE,@CUSTOMERID,@TENDERID,@AMOUNT,@PAIDAMOUNT,@CHANGEAMOUNT,@TRANSCODE)";
datacon.ConString = DataCon;
datacon.CmdType = CommandType.Text;
datacon.CmdString = TenderDtls;
datacon.InsertRecord(spDocumentID, spLocationID, spTerminalID, spCompanyID, spStorageID, spCustomerID, spTenderID,
spPostingType, spCounter, spDocumentDate, spPostingDate, spAmount, spChangeAmount, spPaidAmount, spTransCode);
UpdateReadTenderdtls();
}
catch (Exception ex)
{
string _Ex = ex.Message;
string _Error = "Violation of PRIMARY KEY constraint 'PK_tbl_Tender_Detail'. Cannot insert duplicate key in object 'dbo.tbl_Tender_Detail'.\r\nThe statement has been terminated.";
if (_Error.Equals(_Ex))
{
UpdateReadTenderdtls();
}
else
{
throw;
}
}
}
public void Detail()
{
try
{
SqlParameter spDoc = new SqlParameter();
spDoc.ParameterName = "@DocumentID";
spDoc.SqlDbType = System.Data.SqlDbType.NVarChar;
spDoc.Value = DocumentID;
SqlParameter spLocationID = new SqlParameter();
spLocationID.ParameterName = "@LocationID";
spLocationID.SqlDbType = System.Data.SqlDbType.NVarChar;
spLocationID.Value = LocationID;
SqlParameter spStorageID = new SqlParameter();
spStorageID.ParameterName = "@StorageID";
spStorageID.SqlDbType = System.Data.SqlDbType.NVarChar;
spStorageID.Value = StorageID;
SqlParameter spVendorId = new SqlParameter();
spVendorId.ParameterName = "@VendorId";
spVendorId.SqlDbType = System.Data.SqlDbType.NVarChar;
spVendorId.Value = VendorId;
SqlParameter spCounter = new SqlParameter();
spCounter.ParameterName = "@Counter";
spCounter.SqlDbType = System.Data.SqlDbType.Int;
spCounter.Value = Counter;
SqlParameter spCompanyID = new SqlParameter();
spCompanyID.ParameterName = "@CompanyID";
spCompanyID.SqlDbType = System.Data.SqlDbType.NVarChar;
spCompanyID.Value = CompanyID;
SqlParameter spDoumentDate = new SqlParameter();
spDoumentDate.ParameterName = "@DocumentDate";
spDoumentDate.SqlDbType = System.Data.SqlDbType.DateTime;
spDoumentDate.Value = DocumentDate;
SqlParameter spPostingType = new SqlParameter();
spPostingType.ParameterName = "@PostingType";
spPostingType.SqlDbType = System.Data.SqlDbType.NVarChar;
spPostingType.Value = PostingType;
SqlParameter spCategoryID = new SqlParameter();
spCategoryID.ParameterName = "@CategoryID";
spCategoryID.SqlDbType = System.Data.SqlDbType.NVarChar;
spCategoryID.Value = CategoryID;
SqlParameter spMaterialID = new SqlParameter();
spMaterialID.ParameterName = "@MaterialID";
spMaterialID.SqlDbType = System.Data.SqlDbType.NVarChar;
spMaterialID.Value = MaterialID;
SqlParameter spUOM = new SqlParameter();
spUOM.ParameterName = "@UOM";
spUOM.SqlDbType = System.Data.SqlDbType.NVarChar;
spUOM.Value = UOM;
SqlParameter spTranQty = new SqlParameter();
spTranQty.ParameterName = "@TranQty";
spTranQty.SqlDbType = System.Data.SqlDbType.Decimal;
spTranQty.Value = TranQty;
SqlParameter spBaseQty = new SqlParameter();
spBaseQty.ParameterName = "@EntryBaseQty";
spBaseQty.SqlDbType = System.Data.SqlDbType.Decimal;
spBaseQty.Value = BaseQty;
SqlParameter spCreditQty = new SqlParameter();
spCreditQty.ParameterName = "@CreditQty";
spCreditQty.SqlDbType = System.Data.SqlDbType.Decimal;
spCreditQty.Value = CreditQty;
SqlParameter spCost = new SqlParameter();
spCost.ParameterName = "@Cost";
spCost.SqlDbType = System.Data.SqlDbType.Decimal;
spCost.Value = Cost;
SqlParameter spDiscountRate = new SqlParameter();
spDiscountRate.ParameterName = "@DiscountRate";
spDiscountRate.SqlDbType = System.Data.SqlDbType.Decimal;
spDiscountRate.Value = DiscountRate;
SqlParameter spAmount = new SqlParameter();
spAmount.ParameterName = "@Amount";
spAmount.SqlDbType = System.Data.SqlDbType.Decimal;
spAmount.Value = Amount;
SqlParameter spCreditAmount = new SqlParameter();
spCreditAmount.ParameterName = "@CreditAmount";
spCreditAmount.SqlDbType = System.Data.SqlDbType.Decimal;
spCreditAmount.Value = CreditAmount;
SqlParameter spUserID = new SqlParameter();
spUserID.ParameterName = "@UserID";
spUserID.SqlDbType = System.Data.SqlDbType.NVarChar;
spUserID.Value = UserID;
SqlParameter spPostKey = new SqlParameter();
spPostKey.ParameterName = "@PostKey";
spPostKey.SqlDbType = System.Data.SqlDbType.Int;
spPostKey.Value = PostKey;
SqlParameter spAddDate = new SqlParameter();
spAddDate.ParameterName = "@AddDate";
spAddDate.SqlDbType = System.Data.SqlDbType.DateTime;
spAddDate.Value = AddDate;
SqlParameter spUpdDate = new SqlParameter();
spUpdDate.ParameterName = "@UpdDate";
spUpdDate.SqlDbType = System.Data.SqlDbType.DateTime;
spUpdDate.Value = UpdDate;
SqlParameter spPostingDate = new SqlParameter();
spPostingDate.ParameterName = "@PostingDate";
spPostingDate.SqlDbType = System.Data.SqlDbType.DateTime;
spPostingDate.Value = PostingDate;
SqlParameter spconvertFactor = new SqlParameter();
spconvertFactor.ParameterName = "@ConvertFactor";
spconvertFactor.SqlDbType = System.Data.SqlDbType.Decimal;
spconvertFactor.Value = ConvertFactor;
string TransferDtls = "Proc_PhyInventory_Detail";//Proc_TransferDisplay_Ent_In_Out
datacon1.ConString = ConfigurationManager.ConnectionStrings["ConnectionStringSvr"].ConnectionString;
datacon1.CmdType = CommandType.StoredProcedure;
datacon1.CmdString = TransferDtls;
datacon1.InsertRecord(spDoc, spCompanyID, spLocationID, spStorageID, spDoumentDate, spPostingDate,
spMaterialID, spBaseQty, spAddDate, spUpdDate, spCategoryID, spUserID, spconvertFactor);
}
catch (Exception ex)
{
throw;
}
}
public DataTable InsertEOD()
{
DataTable dtEOD = null;
try
{
SqlParameter spLocationID = new SqlParameter();
spLocationID.ParameterName = "@LocationID";
spLocationID.SqlDbType = System.Data.SqlDbType.NVarChar;
spLocationID.Value = LocationID;
SqlParameter spTermininalID = new SqlParameter();
spTermininalID.ParameterName = "@TerminialID";
spTermininalID.SqlDbType = System.Data.SqlDbType.NVarChar;
spTermininalID.Value = TerminalID;
SqlParameter spEODID = new SqlParameter();
spEODID.ParameterName = "@EODID";
spEODID.SqlDbType = System.Data.SqlDbType.NVarChar;
spEODID.Value = EODID;
SqlParameter spDocDate = new SqlParameter();
spDocDate.ParameterName = "@DocDate";
spDocDate.SqlDbType = System.Data.SqlDbType.DateTime;
spDocDate.Value = DocDate;
SqlParameter spLoan = new SqlParameter();
spLoan.ParameterName = "@Loan";
spLoan.SqlDbType = System.Data.SqlDbType.NVarChar;
spLoan.Value = Loan;
SqlParameter spSystemCash = new SqlParameter();
spSystemCash.ParameterName = "@SystemCash";
spSystemCash.SqlDbType = System.Data.SqlDbType.Decimal;
spSystemCash.Value = SystemCash;
SqlParameter spActualCash = new SqlParameter();
spActualCash.ParameterName = "@ActualCash";
spActualCash.SqlDbType = System.Data.SqlDbType.Decimal;
spActualCash.Value = ActualCash;
SqlParameter spCash1 = new SqlParameter();
spCash1.ParameterName = "@1";
spCash1.SqlDbType = System.Data.SqlDbType.Decimal;
spCash1.Value = Cash1;
SqlParameter spCash5 = new SqlParameter();
spCash5.ParameterName = "@5";
spCash5.SqlDbType = System.Data.SqlDbType.Decimal;
spCash5.Value = Cash5;
SqlParameter spCash10 = new SqlParameter();
spCash10.ParameterName = "@10";
spCash10.SqlDbType = System.Data.SqlDbType.Decimal;
spCash10.Value = Cash10;
SqlParameter spCash20 = new SqlParameter();
spCash20.ParameterName = "@20";
spCash20.SqlDbType = System.Data.SqlDbType.Decimal;
spCash20.Value = Cash20;
SqlParameter spCash50 = new SqlParameter();
spCash50.ParameterName = "@50";
spCash50.SqlDbType = System.Data.SqlDbType.Decimal;
spCash50.Value = Cash50;
SqlParameter spCash100 = new SqlParameter();
spCash100.ParameterName = "@100";
spCash100.SqlDbType = System.Data.SqlDbType.Decimal;
spCash100.Value = Cash100;
SqlParameter spCash200 = new SqlParameter();
spCash200.ParameterName = "@200";
spCash200.SqlDbType = System.Data.SqlDbType.Decimal;
spCash200.Value = Cash200;
SqlParameter spCash500 = new SqlParameter();
spCash500.ParameterName = "@500";
spCash500.SqlDbType = System.Data.SqlDbType.Decimal;
spCash500.Value = Cash500;
SqlParameter spCashDiff = new SqlParameter();
spCashDiff.ParameterName = "@CashDiff";
spCashDiff.SqlDbType = System.Data.SqlDbType.Decimal;
spCashDiff.Value = CashDiff;
SqlParameter spCashCount = new SqlParameter();
spCashCount.ParameterName = "@CashCount";
spCashCount.SqlDbType = System.Data.SqlDbType.Int;
spCashCount.Value = CashCount;
SqlParameter spCreditAmt = new SqlParameter();
spCreditAmt.ParameterName = "@CreditAmt";
spCreditAmt.SqlDbType = System.Data.SqlDbType.Decimal;
spCreditAmt.Value = CreditAmt;
SqlParameter spDebitAmt = new SqlParameter();
spDebitAmt.ParameterName = "@DebitAmt";
spDebitAmt.SqlDbType = System.Data.SqlDbType.Decimal;
spDebitAmt.Value = DebitAmt;
SqlParameter spDebitCnt = new SqlParameter();
spDebitCnt.ParameterName = "@DebitCnt";
spDebitCnt.SqlDbType = System.Data.SqlDbType.Int;
spDebitCnt.Value = DebitCnt;
SqlParameter spReturnAmt = new SqlParameter();
spReturnAmt.ParameterName = "@ReturnAmt";
spReturnAmt.SqlDbType = System.Data.SqlDbType.Decimal;
spReturnAmt.Value = ReturnAmt;
SqlParameter spReturnCnt = new SqlParameter();
spReturnCnt.ParameterName = "@ReturnCnt";
spReturnCnt.SqlDbType = System.Data.SqlDbType.Int;
spReturnCnt.Value = ReturnCnt;
SqlParameter spDeleteAmt = new SqlParameter();
spDeleteAmt.ParameterName = "@DeleteAmt";
spDeleteAmt.SqlDbType = System.Data.SqlDbType.Decimal;
spDeleteAmt.Value = DeleteAmt;
SqlParameter spDeleteCnt = new SqlParameter();
spDeleteCnt.ParameterName = "@DeleteCnt";
spDeleteCnt.SqlDbType = System.Data.SqlDbType.Int;
spDeleteCnt.Value = DeleteCnt;
SqlParameter spOnAccAmt = new SqlParameter();
spOnAccAmt.ParameterName = "@OnAccAmt";
spOnAccAmt.SqlDbType = System.Data.SqlDbType.Decimal;
spOnAccAmt.Value = OnAccAmt;
SqlParameter spOnAccCnt = new SqlParameter();
spOnAccCnt.ParameterName = "@OnAccCnt";
spOnAccCnt.SqlDbType = System.Data.SqlDbType.Int;
spOnAccCnt.Value = OnAccCnt;
SqlParameter spCust1Amt = new SqlParameter();
spCust1Amt.ParameterName = "@Cust1Amt";
spCust1Amt.SqlDbType = System.Data.SqlDbType.NVarChar;
spCust1Amt.Value = Cust1Amt;
SqlParameter spCust1Cnt = new SqlParameter();
spCust1Cnt.ParameterName = "@";
spCust1Cnt.SqlDbType = System.Data.SqlDbType.Int;
spCust1Cnt.Value = Cust1Cnt;
SqlParameter spCust2Amt = new SqlParameter();
spCust2Amt.ParameterName = "@";
spCust2Amt.SqlDbType = System.Data.SqlDbType.Decimal;
spCust2Amt.Value = Cust2Amt;
SqlParameter spCust2Cnt = new SqlParameter();
spCust2Cnt.ParameterName = "@";
spCust2Cnt.SqlDbType = System.Data.SqlDbType.Int;
spCust2Cnt.Value = Cust2Cnt;
SqlParameter spCreditCnt = new SqlParameter();
spCreditCnt.ParameterName = "@CreditCnt";
spCreditCnt.SqlDbType = System.Data.SqlDbType.Int;
spCreditCnt.Value = CreditCnt;
string EOD = "Proc_SyncInsertEod";
datacon1.ConString = DataCon;
datacon1.CmdType = CommandType.StoredProcedure;
datacon1.CmdString = EOD;
datacon1.InsertRecord(spLocationID, spTermininalID, spEODID, spDocDate, spLoan, spSystemCash, spActualCash, spCash1, spCash5,
spCash10, spCash20, spCash50, spCash100, spCash200, spCash500, spCashDiff, spCashCount, spCreditAmt, spDebitAmt,
spDebitCnt, spReturnAmt, spReturnCnt, spDeleteAmt, spDeleteCnt, spOnAccAmt, spOnAccCnt, spCreditCnt, spCust1Amt);
UpdateReadEod();
}
catch (Exception ex)
{
string _Ex = ex.Message;
string _Error = "Violation of PRIMARY KEY constraint 'PK_tbl_EOD'. Cannot insert duplicate key in object 'dbo.tbl_EOD'.\r\nThe statement has been terminated.";
if (_Error.Equals(_Ex))
{
UpdateReadEod();
}
else
{
throw;
}
}
return(dtEOD);
}
public void InsertInvoiceDtls()
{
try
{
SqlParameter spDoc = new SqlParameter();
spDoc.ParameterName = "@DocumentID";
spDoc.SqlDbType = System.Data.SqlDbType.NVarChar;
spDoc.Value = DocumentID;
SqlParameter spLocationID = new SqlParameter();
spLocationID.ParameterName = "@LocationID";
spLocationID.SqlDbType = System.Data.SqlDbType.NVarChar;
spLocationID.Value = LocationID;
SqlParameter spStorageID = new SqlParameter();
spStorageID.ParameterName = "@StorageID";
spStorageID.SqlDbType = System.Data.SqlDbType.NVarChar;
spStorageID.Value = StorageID;
SqlParameter spTerminalID = new SqlParameter();
spTerminalID.ParameterName = "@TerminalID";
spTerminalID.SqlDbType = System.Data.SqlDbType.NVarChar;
spTerminalID.Value = TerminalID;
SqlParameter spCounter = new SqlParameter();
spCounter.ParameterName = "@Counter";
spCounter.SqlDbType = System.Data.SqlDbType.Int;
spCounter.Value = Counter;
SqlParameter spSalesOrder = new SqlParameter();
spSalesOrder.ParameterName = "@SalesOrder";
spSalesOrder.SqlDbType = System.Data.SqlDbType.NVarChar;
spSalesOrder.Value = SalesOrder;
SqlParameter spCompanyID = new SqlParameter();
spCompanyID.ParameterName = "@CompanyID";
spCompanyID.SqlDbType = System.Data.SqlDbType.NVarChar;
spCompanyID.Value = CompanyID;
SqlParameter spDoumentDate = new SqlParameter();
spDoumentDate.ParameterName = "@DocumentDate";
spDoumentDate.SqlDbType = System.Data.SqlDbType.DateTime;
spDoumentDate.Value = DocumentDate;
SqlParameter spPostingType = new SqlParameter();
spPostingType.ParameterName = "@PostingType";
spPostingType.SqlDbType = System.Data.SqlDbType.NVarChar;
spPostingType.Value = PostingType;
SqlParameter spCustomerID = new SqlParameter();
spCustomerID.ParameterName = "@CustomerID";
spCustomerID.SqlDbType = System.Data.SqlDbType.NVarChar;
if (!CustomerID.Equals(string.Empty))
{
spCustomerID.Value = CustomerID;
}
else
{
spCustomerID.Value = DBNull.Value;
}
SqlParameter spCategoryID = new SqlParameter();
spCategoryID.ParameterName = "@CategoryID";
spCategoryID.SqlDbType = System.Data.SqlDbType.NVarChar;
spCategoryID.Value = CategoryID;
SqlParameter spMaterialID = new SqlParameter();
spMaterialID.ParameterName = "@MaterialID";
spMaterialID.SqlDbType = System.Data.SqlDbType.NVarChar;
spMaterialID.Value = MaterialID;
SqlParameter spUOM = new SqlParameter();
spUOM.ParameterName = "@UOM";
spUOM.SqlDbType = System.Data.SqlDbType.NVarChar;
spUOM.Value = UOM;
SqlParameter spTranQty = new SqlParameter();
spTranQty.ParameterName = "@TranQty";
spTranQty.SqlDbType = System.Data.SqlDbType.Decimal;
spTranQty.Value = TranQty;
SqlParameter spBaseQty = new SqlParameter();
spBaseQty.ParameterName = "@BaseQty";
spBaseQty.SqlDbType = System.Data.SqlDbType.Decimal;
spBaseQty.Value = BaseQty;
SqlParameter spCreditQty = new SqlParameter();
spCreditQty.ParameterName = "@CreditQty";
spCreditQty.SqlDbType = System.Data.SqlDbType.Decimal;
spCreditQty.Value = CreditQty;
SqlParameter spCost = new SqlParameter();
spCost.ParameterName = "@Cost";
spCost.SqlDbType = System.Data.SqlDbType.Decimal;
spCost.Value = Cost;
SqlParameter spPrice = new SqlParameter();
spPrice.ParameterName = "@Price";
spPrice.SqlDbType = System.Data.SqlDbType.Decimal;
spPrice.Value = Price;
SqlParameter spDiscountRate = new SqlParameter();
spDiscountRate.ParameterName = "@DiscountRate";
spDiscountRate.SqlDbType = System.Data.SqlDbType.Decimal;
spDiscountRate.Value = DiscountRate;
SqlParameter spAmount = new SqlParameter();
spAmount.ParameterName = "@Amount";
spAmount.SqlDbType = System.Data.SqlDbType.Decimal;
spAmount.Value = Amount;
SqlParameter spCreditAmount = new SqlParameter();
spCreditAmount.ParameterName = "@CreditAmount";
spCreditAmount.SqlDbType = System.Data.SqlDbType.Decimal;
spCreditAmount.Value = CreditAmount;
SqlParameter spUserID = new SqlParameter();
spUserID.ParameterName = "@UserID";
spUserID.SqlDbType = System.Data.SqlDbType.NVarChar;
spUserID.Value = UserID;
SqlParameter spPostKey = new SqlParameter();
spPostKey.ParameterName = "@PostKey";
spPostKey.SqlDbType = System.Data.SqlDbType.Int;
spPostKey.Value = PostKey;
SqlParameter spAddDate = new SqlParameter();
spAddDate.ParameterName = "@AddDate";
spAddDate.SqlDbType = System.Data.SqlDbType.DateTime;
spAddDate.Value = AddDate;
SqlParameter spUpdDate = new SqlParameter();
spUpdDate.ParameterName = "@UpdDate";
spUpdDate.SqlDbType = System.Data.SqlDbType.DateTime;
spUpdDate.Value = UpdDate;
SqlParameter spPostingDate = new SqlParameter();
spPostingDate.ParameterName = "@PostingDate";
spPostingDate.SqlDbType = System.Data.SqlDbType.DateTime;
spPostingDate.Value = DocumentDate;
SqlParameter spOrderNo = new SqlParameter();
spOrderNo.ParameterName = "@OrderNo";
spOrderNo.SqlDbType = System.Data.SqlDbType.NVarChar;
spOrderNo.Value = OrderNo;
SqlParameter spSalesComm = new SqlParameter();
spSalesComm.ParameterName = "@SalesComm";
spSalesComm.SqlDbType = System.Data.SqlDbType.Decimal;
spSalesComm.Value = Sales_Comm;
SqlParameter spProducComm = new SqlParameter();
spProducComm.ParameterName = "@ProducComm";
spProducComm.SqlDbType = System.Data.SqlDbType.Decimal;
spProducComm.Value = Produc_Comm;
SqlParameter spTax = new SqlParameter();
spTax.ParameterName = "@Tax";
spTax.SqlDbType = System.Data.SqlDbType.Decimal;
spTax.Value = TaxAmount;
SqlParameter spCostAmount = new SqlParameter();
spCostAmount.ParameterName = "@CostAmount";
spCostAmount.SqlDbType = System.Data.SqlDbType.Decimal;
spCostAmount.Value = CostAmount;
SqlParameter spOrderUserName = new SqlParameter();
spOrderUserName.ParameterName = "@OrderUserName";
spOrderUserName.SqlDbType = System.Data.SqlDbType.NVarChar;
spOrderUserName.Value = OrderUsername;
SqlParameter spOrderTransQty = new SqlParameter();
spOrderTransQty.ParameterName = "@OrderTransQty";
spOrderTransQty.SqlDbType = System.Data.SqlDbType.NVarChar;
spOrderTransQty.Value = OrderTransQty;
SqlParameter spOrderBaseQty = new SqlParameter();
spOrderBaseQty.ParameterName = "@OrderBaseQty";
spOrderBaseQty.SqlDbType = System.Data.SqlDbType.NVarChar;
spOrderBaseQty.Value = OrderBaseQty;
string InvoiceDtls = "INSERT INTO TBL_SALES_DETAIL(DOCUMENTID,COMPANYID,LOCATIONID,STORAGEID,TERMINALID,DOCUMENTDATE,POSTINGTYPE,CUSTOMERID,COUNTER,CATEGORYID,MATERIALID,POSTINGDATE,UOM," +
" TRANQTY,BASEQTY,CREDITQTY,COST,PRICE,DISCOUNTRATE,AMOUNT,CREDITAMOUNT,USERID,POSTKEY,ADDDATE,UPDDATE,RtnQty,OrderNo,Sales_CommAmount,Produc_CommAmount,TaxAmount,CostAmount,OrderUserName,OrderTransQty,OrderBaseQty)" +
" VALUES(@DOCUMENTID,@COMPANYID,@LOCATIONID,@STORAGEID,@TERMINALID,@DOCUMENTDATE," +
" @POSTINGTYPE,@CUSTOMERID,@COUNTER,@CATEGORYID,@MATERIALID,@POSTINGDATE,@UOM," +
" @TRANQTY,@BASEQTY,@CREDITQTY,@COST,@PRICE,@DISCOUNTRATE,@AMOUNT,@CREDITAMOUNT,@USERID,@POSTKEY,@ADDDATE," +
" @UPDDATE,0,@OrderNo,@SalesComm,@ProducComm,@Tax,@CostAmount,@OrderUserName,@OrderTransQty,@OrderBaseQty)";
dcon.ConString = Datacon;
dcon.CmdType = CommandType.Text;
dcon.CmdString = InvoiceDtls;
dcon.InsertRecord(spDoc, spCompanyID, spLocationID, spStorageID, spTerminalID, spDoumentDate, spPostingType, spCustomerID, spCounter, spCategoryID, spMaterialID, spPostingDate,
spUOM, spTranQty, spBaseQty, spCreditQty, spCost, spPrice, spDiscountRate, spAmount, spCreditAmount, spUserID, spPostKey, spAddDate, spUpdDate, spOrderNo, spSalesComm, spProducComm, spTax, spCostAmount,
spOrderUserName, spOrderTransQty, spOrderBaseQty);
UpdateReadSalesdtls();
}
catch (Exception ex)
{
string _Ex = ex.Message;
string _Error = "Violation of PRIMARY KEY constraint 'PK_tbl_Sales_Detail'. Cannot insert duplicate key in object 'dbo.tbl_Sales_Detail'.\r\nThe statement has been terminated.";
if (_Error.Equals(_Ex))
{
UpdateReadSalesdtls();
}
else
{
throw;
}
}
}
public void InsertSalesCategory()
{
try
{
SqlParameter spCompanyId = new SqlParameter();
spCompanyId.ParameterName = "@CompanyId";
spCompanyId.SqlDbType = System.Data.SqlDbType.NVarChar;
spCompanyId.Value = CompanyId;
SqlParameter spLocationId = new SqlParameter();
spLocationId.ParameterName = "@LocationId";
spLocationId.SqlDbType = System.Data.SqlDbType.NVarChar;
spLocationId.Value = LocationId;
SqlParameter spTerminalId = new SqlParameter();
spTerminalId.ParameterName = "@TerminalId";
spTerminalId.SqlDbType = System.Data.SqlDbType.NVarChar;
spTerminalId.Value = TerminalId;
SqlParameter spDoc = new SqlParameter();
spDoc.ParameterName = "@DocumentId";
spDoc.SqlDbType = System.Data.SqlDbType.NVarChar;
spDoc.Value = DocumentId;
SqlParameter spCategoryName = new SqlParameter();
spCategoryName.ParameterName = "@CategoryName";
spCategoryName.SqlDbType = System.Data.SqlDbType.NVarChar;
spCategoryName.Value = CategoryName;
SqlParameter spUserName = new SqlParameter();
spUserName.ParameterName = "@UserName";
spUserName.SqlDbType = System.Data.SqlDbType.NVarChar;
spUserName.Value = UserName;
SqlParameter spAmount = new SqlParameter();
spAmount.ParameterName = "@Amount";
spAmount.SqlDbType = System.Data.SqlDbType.NVarChar;
spAmount.Value = Amount;
SqlParameter spDocDate = new SqlParameter();
spDocDate.ParameterName = "@Date";
spDocDate.SqlDbType = System.Data.SqlDbType.DateTime;
spDocDate.Value = Date;
string s = "Proc_InsertSalesCategory";
DbSvr.ConString = ConfigurationManager.ConnectionStrings["ConnectionStringSvr"].ToString();
DbSvr.CmdType = CommandType.StoredProcedure;
DbSvr.CmdString = s;
DbSvr.InsertRecord(spDoc, spCategoryName, spUserName, spAmount, spDocDate, spCompanyId, spLocationId, spTerminalId);
UpdateSalesCategory();
}
catch (Exception ex)
{
string _Ex = ex.Message;
string _Error = "";
if (_Error.Equals(_Ex))
{
UpdateSalesCategory();
}
else
{
throw;
}
}
}
public DataTable InsertEODdtls()
{
DataTable dtEODdtls = null;
try
{
SqlParameter spLocationID = new SqlParameter();
spLocationID.ParameterName = "@LocationID";
spLocationID.SqlDbType = System.Data.SqlDbType.NVarChar;
spLocationID.Value = LocationID;
SqlParameter spTermininalID = new SqlParameter();
spTermininalID.ParameterName = "@TerminalID";
spTermininalID.SqlDbType = System.Data.SqlDbType.NVarChar;
spTermininalID.Value = TerminalID;
SqlParameter spEODID = new SqlParameter();
spEODID.ParameterName = "@EODID";
spEODID.SqlDbType = System.Data.SqlDbType.NVarChar;
spEODID.Value = EODID;
SqlParameter spDocDate = new SqlParameter();
spDocDate.ParameterName = "@DocDate";
spDocDate.SqlDbType = System.Data.SqlDbType.DateTime;
spDocDate.Value = DocDate;
SqlParameter spTransactionDate = new SqlParameter();
spTransactionDate.ParameterName = "@TransactionDate";
spTransactionDate.SqlDbType = System.Data.SqlDbType.DateTime;
spTransactionDate.Value = TransactionDate;
SqlParameter spTransactionType = new SqlParameter();
spTransactionType.ParameterName = "@TransactionType";
spTransactionType.SqlDbType = System.Data.SqlDbType.NVarChar;
spTransactionType.Value = TransactionType;
SqlParameter spTransactionID = new SqlParameter();
spTransactionID.ParameterName = "@TransactionID";
spTransactionID.SqlDbType = System.Data.SqlDbType.NVarChar;
spTransactionID.Value = TransactionID;
SqlParameter spCount = new SqlParameter();
spCount.ParameterName = "@Count";
spCount.SqlDbType = System.Data.SqlDbType.BigInt;
spCount.Value = Count;
SqlParameter spPayType = new SqlParameter();
spPayType.ParameterName = "@PayType";
spPayType.SqlDbType = System.Data.SqlDbType.NVarChar;
spPayType.Value = PayType;
SqlParameter spAmount = new SqlParameter();
spAmount.ParameterName = "@Amount";
spAmount.SqlDbType = System.Data.SqlDbType.Decimal;
spAmount.Value = Amount;
string EODdtls = "Proc_SyncInsertEoddtls";
datacon1.ConString = Datacon;
datacon1.CmdType = CommandType.StoredProcedure;
datacon1.CmdString = EODdtls;
datacon1.InsertRecord(spLocationID, spTermininalID, spEODID, spDocDate, spTransactionDate,
spTransactionType, spTransactionID, spCount, spPayType, spAmount);
UpdateReadEoddtls();
}
catch (Exception ex)
{
string _Ex = ex.Message;
string _Error = "Violation of PRIMARY KEY constraint 'tbl_eoddtls'. Cannot insert duplicate key in object 'dbo.tbl_eoddtls'.\r\nThe statement has been terminated.";
if (_Error.Equals(_Ex))
{
UpdateReadEoddtls();
}
else
{
throw;
}
}
return(dtEODdtls);
}