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