public HttpResponseMessage GetSalesmanOrder(int cid, int salesmanid, string qtnstatus) { cid = CID; ResponseObject res = new ResponseObject(); try { int errno = 0; string errstring = string.Empty; DataSet ds = new DataSet(); DataTable dtSalesmanQuotation = new DataTable(); obj = new DAL_SalesOrder(); dtSalesmanQuotation = obj.GetSalesmanOrder(DBPath, DBPwd, cid, salesmanid, qtnstatus, ref errno, ref errstring); if (dtSalesmanQuotation.Rows.Count > 0) { dtSalesmanQuotation.TableName = "SalesmanQuotation"; } res.respdata = dtSalesmanQuotation; return(Request.CreateResponse(HttpStatusCode.OK, res)); } catch (Exception e) { res.errno = 1; res.errdesc = e.Message; return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, res)); } }
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); }
public HttpResponseMessage GetQuotationDashboard(int cid, int salesmanid, int bspid) { cid = CID; ResponseObject res = new ResponseObject(); try { int errno = 0; string errstring = string.Empty; int[] arr_values = new int[5]; DataSet ds = new DataSet(); DataTable dtSalesmanQuotation = new DataTable(); DataTable dtMonthQuotation = new DataTable(); obj = new DAL_SalesOrder(); ds = obj.MA_OrderDashboard(DBPath, DBPwd, cid, bspid, salesmanid, ref errno, ref errstring); dtSalesmanQuotation = ds.Tables[0]; for (int i = 0; i < dtSalesmanQuotation.Rows.Count; i++) { arr_values[i] = Convert.ToInt32(ds.Tables[0].Rows[i]["Cnt"]); } //if (dtSalesmanQuotation.Rows.Count > 0) //{ // dtSalesmanQuotation.TableName = "series"; //} var pie = new { series = arr_values }; //barchart data dtMonthQuotation = ds.Tables[1]; //GetQuotationDashboardDT(); string[] arr_month = new string[5]; List <int[]> monthQtn = new List <int[]>(); int[] arr_status = new int[5]; for (int i = 0; i < dtMonthQuotation.Rows.Count; i++) { arr_month[i] = dtMonthQuotation.Rows[i]["Month"].ToString(); arr_status = new int[4]; arr_status[0] = Convert.ToInt32(dtMonthQuotation.Rows[i]["Open"]); arr_status[1] = Convert.ToInt32(dtMonthQuotation.Rows[i]["Close"]); arr_status[2] = Convert.ToInt32(dtMonthQuotation.Rows[i]["Partial"]); arr_status[3] = Convert.ToInt32(dtMonthQuotation.Rows[i]["ManualClose"]); monthQtn.Add(arr_status); } var barLabels = new { labels = arr_month }; var barSeries = new { series = monthQtn }; Dictionary <string, object> dic_QtnObject = new Dictionary <string, object>(); dic_QtnObject.Add("Count", dtSalesmanQuotation); dic_QtnObject.Add("ChartData", pie); dic_QtnObject.Add("BarLabels", barLabels); dic_QtnObject.Add("BarSeries", barSeries); res.respdata = dic_QtnObject; return(Request.CreateResponse(HttpStatusCode.OK, res)); } catch (Exception e) { res.errno = 1; res.errdesc = e.Message; return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, res)); } }