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