private string newSalesOrder(int customerledger, string customername, int salesmanid, string username) { string soNo = string.Empty; string outsms = string.Empty, outemail = string.Empty; string errstring = string.Empty; int revno = 0; int errno = 0; obj = new DAL_SalesOrder(); csSalesOrder objcsSO = CreateSOObject(customerledger, customername, salesmanid, username); BusinessPeriodID = objcsSO.objSalesOrderMain.int_BusinessPeriodID; errstring = obj.Update_SalesOrder(DBPath, DBPwd, ref soNo, ref revno, objcsSO, ref outsms, ref outemail, ref errno); return(soNo); }
private string createSalesOrder(int customerledger, string customername, int salesmanid, string username, Byte[] image, string imagename, string imagetype) { string soNo = string.Empty; string outsms = string.Empty, outemail = string.Empty; string errstring = string.Empty; int revno = 0; int errno = 0; obj = new DAL_SalesOrder(); csSalesOrder objcsSO = CreateSOObject(customerledger, customername, salesmanid, username); errstring = obj.Update_SalesOrder(DBPath, DBPwd, ref soNo, ref revno, objcsSO, ref outsms, ref outemail, ref errno); //errstring = obj.Update_Quotation(ref qtnNo, ref revno, objcsqtn, ref outsms, ref outemail, ref errno); if (errstring == "" && soNo != "") { UpdateImage(objcsSO.int_CID.ToString(), PREFIX + soNo, image, imagename, imagetype, username); } return(soNo); }
private csSalesOrder CreateSOObject(int customerledger, string customername, int salesmanid, string username) { Dictionary <string, string> objproj = new Dictionary <string, string>(); csSalesOrder objSO = new csSalesOrder(objproj); objSO.int_CID = CID; objGen = new DAL_General(objSO.int_CID.ToString()); objSO.objSalesOrderMain.str_SalOrd = ""; objSO.objSalesOrderMain.int_BusinessPeriodID = objGen.GetLatestBusinessPeriodID(DBPath, DBPwd, CID); objSO.objSalesOrderMain.str_Flag = "ADD"; objSO.objSalesOrderMain.str_FormPrefix = PREFIX; objSO.objSalesOrderMain.str_MenuID = "ERP_156"; objSO.objSalesOrderMain.int_RevNo = 0; objSO.objSalesOrderMain.dtp_SODate = DateTime.Now; objSO.objSalesOrderMain.str_QtnNum = ""; objSO.objSalesOrderMain.int_LedgerID = customerledger; objSO.objSalesOrderMain.str_Alias = customername; objSO.objSalesOrderMain.int_Aging = 0; objSO.objSalesOrderMain.str_PayTerm = ""; objSO.objSalesOrderMain.str_Indref = ""; objSO.objSalesOrderMain.str_Comment = ""; objSO.objSalesOrderMain.str_Contact = ""; objSO.objSalesOrderMain.str_SOStatus = "Open"; objSO.objSalesOrderMain.str_MerchantRef = ""; objSO.objSalesOrderMain.str_SalesManID = salesmanid.ToString(); objSO.objSalesOrderMain.str_TCCurrency = CURRENCY; objSO.objSalesOrderMain.dbl_ExchangeRate = 1; objSO.objSalesOrderMain.int_StatusCancel = 2; objSO.objSalesOrderMain.str_DeliveryAddress = ""; objSO.objSalesOrderMain.str_ContactPerson = ""; objSO.objSalesOrderMain.str_Desc1 = ""; objSO.objSalesOrderMain.str_Desc2 = ""; objSO.objSalesOrderMain.str_Desc3 = ""; objSO.objSalesOrderMain.str_Desc4 = ""; objSO.objSalesOrderMain.str_Desc5 = ""; objSO.objSalesOrderMain.str_Desc6 = ""; objSO.objSalesOrderMain.str_Desc7 = ""; objSO.objSalesOrderMain.str_Desc8 = ""; objSO.objSalesOrderMain.dbl_TCAmount = 0; objSO.objSalesOrderMain.dbl_TCDisAmount = "0"; objSO.objSalesOrderMain.dbl_TCDiscountAmount = 0; objSO.objSalesOrderMain.dbl_TCAdjAmount = 0; objSO.objSalesOrderMain.dbl_TCNetAmount = 0; objSO.objSalesOrderMain.dbl_TCMiscPercentage = "0"; objSO.objSalesOrderMain.dbl_TCMiscAmount = 0; objSO.objSalesOrderMain.dbl_LCNetAmount = 0; objSO.objSalesOrderMain.str_ExpiryDays = ""; objSO.objSalesOrderMain.str_MiscText = "Misc"; objSO.objSalesOrderMain.str_DiscText = "Discount"; objSO.objSalesOrderMain.str_UserComment = ""; objSO.objSalesOrderMain.str_ApproverComment = ""; objSO.objSalesOrderMain.str_ItemTaxCode = "TAX"; objSO.objSalesOrderMain.str_InvoiceTaxCode = ""; objSO.objSalesOrderMain.str_InvoiceTaxXML = ConvertDatatableToXML(SingleItemTaxDetails()); objSO.objSalesOrderMain.dbl_TCItemTaxAmount = 0; objSO.objSalesOrderMain.dbl_TCInvoiceTaxAmount = 0; objSO.objSalesOrderMain.dbl_ItemDiscPercentage = 0; objSO.objSalesOrderMain.str_WHID = ""; objSO.objSalesOrderMain.str_Consignee = ""; objSO.objSalesOrderMain.str_SalesType = ""; objSO.objSalesOrderMain.str_DeliveryCountry = ""; objSO.objSalesOrderMain.int_LanguageCode = 0; objSO.objSalesOrderMain.str_RTF_Description = ""; objSO.objproject.str_ProjectID = ""; objSO.objproject.str_ProjectLocation = ""; objSO.objproject.str_WorkOrderNo = ""; objSO.str_CreatedBy = username; objSO.dtp_CreatedDate = DateTime.Now; objSO.str_LastUpdatedBy = ""; objSO.dtp_LastUpdatedDate = DateTime.Now; objSO.str_ApprovedBy = ""; objSO.dtp_ApprovedDate = DateTime.Now; objSO.bool_ApprovedStatus = 1; objSO.ApprovedHigherLevel = true; objSO.ApprovedComment = ""; objSO.DTItemExtraDetails = ItemExtraDT(); objSO.objSalesorderSub.dt_SalesOrderItemDetails = DBTemplate(); objSO.DTBatch = BatchDTTemplate(); objSO.objSalesOrderMain.dt_TaxItemDetails = TaxItemDetails(); return(objSO); }