public HttpResponseMessage CustomerAndSalesman(int cid)
{
cid = CID;
ResponseObject res = new ResponseObject();
try
{
DataSet ds = new DataSet();
DataTable dtCustomer = new DataTable();
objGen = new DAL_General(cid.ToString());
dtCustomer = objGen.GetCustomer(DBPath, DBPwd, cid);
if (dtCustomer.Rows.Count > 0)
{
dtCustomer.TableName = "Customers";
ds.Tables.Add(dtCustomer);
}
res.respdata = ds;
return(Request.CreateResponse(HttpStatusCode.OK, res));
}
catch (Exception e)
{
res.errno = 1;
res.errdesc = e.Message;
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, res));
}
}
public HttpResponseMessage GetItemPriceList(int cid, string itemcode, int salesmanid, string barcode)
{
cid = CID;
ResponseObject res = new ResponseObject();
try
{
//int errno = 0;
//string errstring = string.Empty;
DataSet ds = new DataSet();
objGen = new DAL_General(cid.ToString());
ds = objGen.MA_ItemPriceList(DBPath, DBPwd, cid, itemcode, salesmanid, barcode);
ds.Tables[0].TableName = "ItemMaster";
ds.Tables[1].TableName = "ItemPriceList";
res.respdata = ds;
return(Request.CreateResponse(HttpStatusCode.OK, res));
}
catch (Exception e)
{
res.errno = 1;
res.errdesc = e.Message;
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, res));
}
}
private void UpdateImage(string cid, string qtnno, Byte[] image, string imagename, string imagetype, string updatedby)
{
string errstring = string.Empty;
int errno = 0;
DateTime updateddate = DateTime.Now;
string slno = "1";
DAL_General obj = new DAL_General(cid);
obj.FileUpload(cid, DBPath, DBPwd, BusinessPeriodID, qtnno, "SalesOrder", "ERP_156", "", "", imagename, ".jpg", updatedby, image, ref slno, "ADD", ref errno, ref errstring);
//errstring = obj.FileUpload(cid, qtnno, "Quotation", "ERP_155", "ORDER", "", imagename, imagetype, updatedby, image, "1", "ADD", ref errno, ref errstring);
}
public HttpResponseMessage GetItemList(int cid)
{
cid = CID;
ResponseObject res = new ResponseObject();
try
{
//int errno = 0;
//string errstring = string.Empty;
DataTable dt = new DataTable();
objGen = new DAL_General(cid.ToString());
dt = objGen.GetItemList(DBPath, DBPwd, cid);
//dt.TableName = "ItemList";
res.respdata = dt;
return(Request.CreateResponse(HttpStatusCode.OK, res));
}
catch (Exception e)
{
res.errno = 1;
res.errdesc = e.Message;
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, res));
}
}
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);
}
