public void ProcessRequest(HttpContext context)
{
SqlConnection conn = new SqlConnection(strcon);
String userId = context.Request.Form["txtUserName"];
long StoreId = Convert.ToInt64(context.Request.Form["txtDepartmentId"]);
// String userPass = context.Request.Form["usrPass"];
CustomProfile profile = CustomProfile.GetProfile(userId);
long uId = profile.Personal.UserID;
DateTime creationdate = DateTime.Now;
string template = context.Request.Form["txtTemplate"];
DateTime OrderDate = Convert.ToDateTime(context.Request.Form["txtReqDate"].ToString());
string Title = context.Request.Form["txtTitle"];
DateTime Deliverydate = Convert.ToDateTime(context.Request.Form["txtDisDate"].ToString());
string OrderNumber = context.Request.Form["txtOrderNo"];
string Remark = context.Request.Form["txtRemark"];
long Contact1 = Convert.ToInt64(context.Request.Form["txtContact1"]);
long Contact2 = Convert.ToInt64(context.Request.Form["txtContact2"]);
long AddressId = Convert.ToInt64(context.Request.Form["txtAddress"]);
long PaymentMethodID = Convert.ToInt64(context.Request.Form["txtPaymentMethod"]);
string PMField1 = context.Request.Form["txtPaymentMethodField1"];
string PMField2 = context.Request.Form["txtPaymentMethodField2"];
decimal totalqty = Convert.ToDecimal(context.Request.Form["txttotalqty"]);
decimal grandtotal = Convert.ToDecimal(context.Request.Form["txtgrandtotal"]);
string ConID2 = context.Request.Form["txtContact2"];
string Priority = "High";
string OrderNo = "";
SqlCommand cmd6 = new SqlCommand();
SqlDataAdapter da6 = new SqlDataAdapter();
DataSet ds6 = new DataSet();
DataTable dt6 = new DataTable();
string ordertype = "";
cmd6.CommandType = CommandType.Text;
cmd6.CommandText = "select * from FN_GetOrderNo(" + StoreId + ")";
cmd6.Connection = conn;
cmd6.Parameters.Clear();
da6.SelectCommand = cmd6;
da6.Fill(ds6, "dtl6");
dt6 = ds6.Tables[0];
if (dt6.Rows.Count > 0)
{
OrderNo = dt6.Rows[0]["NewOrderNo"].ToString();
long PreviousStatusID = 0;
iPartRequestClient objService = new iPartRequestClient();
tOrderHead RequestHead = new tOrderHead();
RequestHead.CreatedBy = profile.Personal.UserID;
RequestHead.Creationdate = DateTime.Now;
RequestHead.OrderNumber = OrderNumber;
RequestHead.StoreId = StoreId;
RequestHead.Priority = Priority;
RequestHead.Status = 2;
RequestHead.Title = Title.ToString();
RequestHead.Orderdate = OrderDate;
RequestHead.RequestBy = profile.Personal.UserID;
RequestHead.Remark = Remark;
RequestHead.Deliverydate = Deliverydate;
RequestHead.ContactId1 = Contact1;
RequestHead.ContactId2 = Contact2;
RequestHead.Con2 = ConID2;
RequestHead.AddressId = AddressId;
RequestHead.OrderNo = OrderNo.ToString();
RequestHead.TotalQty = totalqty;
RequestHead.GrandTotal = grandtotal;
RequestHead.PaymentID = PaymentMethodID;
RequestHead.orderType = "Mobile";
RequestHead.LocationID = 0;
long RequestID = objService.SetIntotOrderHead(RequestHead, profile.DBConnection._constr);
string prdDetails = context.Request.Form["txtProductDetails"];
string myQueryString = " select * from SplitString('" + prdDetails + "','|')";
cmd.CommandType = CommandType.Text;
cmd.CommandText = myQueryString;
cmd.Connection = conn;
cmd.Parameters.Clear();
da.SelectCommand = cmd;
da.Fill(ds, "tbl1");
dt = ds.Tables[0];
int cntr = dt.Rows.Count;
if (cntr > 0)
{
long MySequence = 1;
for (int i = 0; i <= (cntr - 1); i++)
{
long PrdID = Convert.ToInt64(ds.Tables[0].Rows[i]["part"].ToString());
i = i + 1;
long uomId = Convert.ToInt64(ds.Tables[0].Rows[i]["part"].ToString());
i = i + 1;
decimal Qty = Convert.ToDecimal(ds.Tables[0].Rows[i]["part"].ToString());
i = i + 1;
decimal price = Convert.ToDecimal(ds.Tables[0].Rows[i]["part"].ToString());
i = i + 1;
long ischanged = Convert.ToInt64(ds.Tables[0].Rows[i]["part"].ToString());
i = i + 1;
decimal totalprice = Convert.ToDecimal(ds.Tables[0].Rows[i]["part"].ToString());
SqlCommand cmd1 = new SqlCommand();
SqlDataAdapter da1 = new SqlDataAdapter();
DataSet ds1 = new DataSet();
DataTable dt1 = new DataTable();
string dsprdDetails = "select ProductCode,Name , Description from mProduct where ID=" + PrdID + "";
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = dsprdDetails;
cmd1.Connection = conn;
cmd1.Parameters.Clear();
da1.SelectCommand = cmd1;
da1.Fill(ds1, "tbl2");
dt1 = ds1.Tables[0];
string name = ds1.Tables[0].Rows[0]["Name"].ToString();
string descr = ds1.Tables[0].Rows[0]["Description"].ToString();
string code = ds1.Tables[0].Rows[0]["ProductCode"].ToString();
SqlCommand cmd3 = new SqlCommand();
SqlDataAdapter da3 = new SqlDataAdapter();
DataSet ds3 = new DataSet();
DataTable dt3 = new DataTable();
string insPrdDetails = "insert into torderdetail(OrderHeadId,SkuId,OrderQty,UOMID,Sequence,Prod_Name,Prod_Description,Prod_Code,RemaningQty,Price,Total,IsPriceChange) values(" + RequestID + "," + PrdID + "," + Qty + "," + uomId + "," + MySequence + ",'" + name + "','" + descr + "','" + code + "'," + Qty + "," + price + "," + totalprice + "," + ischanged + ")";
cmd3.CommandType = CommandType.Text;
cmd3.CommandText = insPrdDetails;
cmd3.Connection = conn;
cmd3.Parameters.Clear();
da3.SelectCommand = cmd3;
da3.Fill(ds3, "tbl3");
//dt3 = ds3.Tables[0];
//after Save
MySequence = MySequence + 1;
}
}
SqlCommand cmd7 = new SqlCommand();
SqlDataAdapter da7 = new SqlDataAdapter();
DataSet ds7 = new DataSet();
DataTable dt7 = new DataTable();
cmd7.CommandType = CommandType.Text;
cmd7.CommandText = "select * from mPaymentMethodDetail where PMethodID=" + PaymentMethodID + "";
cmd7.Connection = conn;
cmd7.Parameters.Clear();
da7.SelectCommand = cmd7;
da7.Fill(ds7, "dtl7");
dt7 = ds7.Tables[0];
if (dt7.Rows.Count > 0)
{
for (int i = 0; i <= dt7.Rows.Count - 1; i++)
{
int StatutoryId = Convert.ToInt32(dt7.Rows[i]["ID"].ToString());
if (StatutoryId == 5)
{
SqlCommand cmd12 = new SqlCommand();
SqlDataAdapter da12 = new SqlDataAdapter();
DataSet ds12 = new DataSet();
DataTable dt12 = new DataTable();
cmd12.CommandType = CommandType.Text;
cmd12.CommandText = "select ID from mcostcentermain where CenterName='" + PMField1 + "'";
cmd12.Connection = conn;
cmd12.Parameters.Clear();
da12.SelectCommand = cmd12;
da12.Fill(ds12, "dtl12");
dt12 = ds12.Tables[0];
if (dt12.Rows.Count > 0)
{
PMField1 = dt12.Rows[0]["ID"].ToString();
}
}
int Sequence = Convert.ToInt32(dt7.Rows[i]["Sequence"].ToString());
SqlCommand cmd8 = new SqlCommand();
SqlDataAdapter da8 = new SqlDataAdapter();
DataSet ds8 = new DataSet();
DataTable dt8 = new DataTable();
string Object = "RequestPartDetail";
int active = 1;
int companyid = 0;
cmd8.CommandType = CommandType.Text;
if (Sequence == 1)
{
cmd8.CommandText = "Insert into tStatutorydetail(ObjectName,ReferenceID,StatutoryID,StatutoryValue,Active,CreatedBy,CreatedDate,CompanyID,Sequence)values('" + Object + "'," + RequestID + "," + StatutoryId + ",'" + PMField1 + "'," + active + "," + uId + ",'" + creationdate + "'," + companyid + "," + Sequence + ")";
}
else if (Sequence == 2)
{
cmd8.CommandText = "Insert into tStatutorydetail(ObjectName,ReferenceID,StatutoryID,StatutoryValue,Active,CreatedBy,CreatedDate,CompanyID,Sequence)values('" + Object + "'," + RequestID + "," + StatutoryId + ",'" + PMField2 + "'," + active + "," + uId + ",'" + creationdate + "'," + companyid + "," + Sequence + ")";
}
cmd8.Connection = conn;
cmd8.Parameters.Clear();
da8.SelectCommand = cmd8;
da8.Fill(ds8, "dtl8");
}
}
string Doctype1 = context.Request.Form["txtDocType1"];
string Docname1 = context.Request.Form["txtDocName1"];
string Docpath1 = context.Request.Form["txtDocPath1"];
string extension1 = "";
string doc1 = "";
string filename1 = "";
string documentDownloadPath1 = "";
string docSave1 = "";
string documentSavePath1 = "";
if (Docpath1 != String.Empty && Docpath1 != null && Docpath1 != "" && Docpath1 != "null")
{
extension1 = Docpath1.Split('.').Last();
filename1 = Path.GetFileNameWithoutExtension(Docpath1);
docSave1 = Path.GetDirectoryName(Docpath1);
documentDownloadPath1 = "http://testoms.gwclogistics.com:8080/GWCMobile/Mobile/" + docSave1 + "/" + RequestID + "/" + filename1 + "";
documentSavePath1 = "C:\\GWCMobile\\Mobile\\" + docSave1 + "\\" + RequestID + "\\";
}
string Doctype2 = context.Request.Form["txtDocType2"];
string Docname2 = context.Request.Form["txtDocName2"];
string Docpath2 = context.Request.Form["txtDocPath2"];
string extension2 = "";
string doc2 = "";
string filename2 = "";
string documentDownloadPath2 = "";
string docSave2 = "";
string documentSavePath2 = "";
if (Docpath2 != String.Empty && Docpath2 != null && Docpath2 != "" && Docpath2 != "null")
{
extension2 = Docpath2.Split('.').Last();
filename2 = Path.GetFileNameWithoutExtension(Docpath2);
docSave2 = Path.GetDirectoryName(Docpath2);
documentDownloadPath2 = "http://testoms.gwclogistics.com:8080/GWCMobile/Mobile/" + docSave2 + "/" + RequestID + "/" + filename2 + "";
documentSavePath2 = "C:\\GWCMobile\\Mobile\\" + docSave2 + "\\" + RequestID + "\\";
}
string Doctype3 = context.Request.Form["txtDocType3"];
string Docname3 = context.Request.Form["txtDocName3"];
string Docpath3 = context.Request.Form["txtDocPath3"];
string extension3 = "";
string doc3 = "";
string filename3 = "";
string documentDownloadPath3 = "";
string docSave3 = "";
string documentSavePath3 = "";
if (Docpath3 != String.Empty && Docpath3 != null && Docpath3 != "" && Docpath3 != "null")
{
extension3 = Docpath3.Split('.').Last();
filename3 = Path.GetFileNameWithoutExtension(Docpath3);
docSave3 = Path.GetDirectoryName(Docpath3);
documentDownloadPath3 = "http://testoms.gwclogistics.com:8080/GWCMobile/Mobile/" + docSave3 + "/" + RequestID + "/" + filename3 + "";
documentSavePath3 = "C:\\GWCMobile\\Mobile\\" + docSave3 + "\\" + RequestID + "\\";
}
string Doctype4 = context.Request.Form["txtDocType4"];
string Docname4 = context.Request.Form["txtDocName4"];
string Docpath4 = context.Request.Form["txtDocPath4"];
string extension4 = "";
string doc4 = "";
string filename4 = "";
string documentDownloadPath4 = "";
string docSave4 = "";
string documentSavePath4 = "";
if (Docpath4 != String.Empty && Docpath4 != null && Docpath4 != "" && Docpath4 != "null")
{
extension4 = Docpath4.Split('.').Last();
filename4 = Path.GetFileNameWithoutExtension(Docpath4);
docSave4 = Path.GetDirectoryName(Docpath4);
documentDownloadPath4 = "http://testoms.gwclogistics.com:8080/GWCMobile/Mobile/" + docSave4 + "/" + RequestID + "/" + filename4 + "";
documentSavePath4 = "C:\\GWCMobile\\Mobile\\" + docSave4 + "\\" + RequestID + "\\";
}
SqlCommand cmd10 = new SqlCommand();
SqlDataAdapter da10 = new SqlDataAdapter();
DataSet ds10 = new DataSet();
DataTable dt10 = new DataTable();
cmd10.CommandType = CommandType.Text;
cmd10.CommandText = "Select ParentID from mTerritory where ID=" + StoreId + "";
cmd10.Connection = conn;
cmd10.Parameters.Clear();
da10.SelectCommand = cmd10;
da10.Fill(ds10, "tbl10");
dt10 = ds10.Tables[0];
if (dt10.Rows.Count > 0)
{
long CompanyID = Convert.ToInt64(dt10.Rows[0]["ParentID"].ToString());
if (Docname1 != "" && Docpath1 != "" && Doctype1 != "")
{
InsertDocument(RequestID, Docname1, documentDownloadPath1, documentSavePath1, extension1, uId, creationdate, CompanyID, Doctype1);
string dirattachment = context.Server.MapPath("~/Mobile/Attachment/" + RequestID);
if (!Directory.Exists(dirattachment))
{
Directory.CreateDirectory(dirattachment);
}
string sourcePath = context.Server.MapPath("~/Mobile/Attachment/" + Path.GetFileName(Docpath1));
string destinationPath = context.Server.MapPath("~/Mobile/Attachment/" + RequestID + "/" + Path.GetFileName(Docpath1));
if (File.Exists(sourcePath))
{
File.Move(sourcePath, destinationPath);
}
}
if (Docname2 != "" && Docpath2 != "" && Doctype2 != "")
{
InsertDocument(RequestID, Docname2, documentDownloadPath2, documentSavePath2, extension2, uId, creationdate, CompanyID, Doctype2);
string dirattachment = context.Server.MapPath("~/Mobile/Attachment/" + RequestID);
if (!Directory.Exists(dirattachment))
{
Directory.CreateDirectory(dirattachment);
}
string sourcePath = context.Server.MapPath("~/Mobile/Attachment/" + Path.GetFileName(Docpath2));
string destinationPath = context.Server.MapPath("~/Mobile/Attachment/" + RequestID + "/" + Path.GetFileName(Docpath2));
if (File.Exists(sourcePath))
{
File.Move(sourcePath, destinationPath);
}
}
if (Docname3 != "" && Docpath3 != "" && Doctype3 != "")
{
InsertDocument(RequestID, Docname3, documentDownloadPath3, documentSavePath3, extension3, uId, creationdate, CompanyID, Doctype3);
string dirattachment = context.Server.MapPath("~/Mobile/Attachment/" + RequestID);
if (!Directory.Exists(dirattachment))
{
Directory.CreateDirectory(dirattachment);
}
string sourcePath = context.Server.MapPath("~/Mobile/Attachment/" + Path.GetFileName(Docpath3));
string destinationPath = context.Server.MapPath("~/Mobile/Attachment/" + RequestID + "/" + Path.GetFileName(Docpath3));
if (File.Exists(sourcePath))
{
File.Move(sourcePath, destinationPath);
}
}
if (Docname4 != "" && Docpath4 != "" && Doctype4 != "")
{
InsertDocument(RequestID, Docname4, documentDownloadPath4, documentSavePath4, extension4, uId, creationdate, CompanyID, Doctype4);
string dirattachment = context.Server.MapPath("~/Mobile/Attachment/" + RequestID);
if (!Directory.Exists(dirattachment))
{
Directory.CreateDirectory(dirattachment);
}
string sourcePath = context.Server.MapPath("~/Mobile/Attachment/" + Path.GetFileName(Docpath4));
string destinationPath = context.Server.MapPath("~/Mobile/Attachment/" + RequestID + "/" + Path.GetFileName(Docpath4));
if (File.Exists(sourcePath))
{
File.Move(sourcePath, destinationPath);
}
}
}
objService.SetApproverDataafterSave("RequestPartDetail", RequestID, uId.ToString(), 2, StoreId, 0, profile.DBConnection._constr);
String xmlString = String.Empty;
// String orderNo = String.Empty;
context.Response.ContentType = "text/xml";
xmlString = xmlString + "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
xmlString = xmlString + "<gwcInfo>";
xmlString = xmlString + "<newRequestInfo>";
if (RequestID > 0)
{
xmlString = xmlString + "<requestmsg>success</requestmsg>";
//xmlString = xmlString + "<orderno> Order ID : " + RequestID + "</orderno>";
// xmlString = xmlString + "<gwcOrderLabel> " + OrderNo + "</gwcOrderLabel>";
xmlString = xmlString + "<orderno> Order ID : " + OrderNo + "</orderno>";
}
else
{
xmlString = xmlString + "<requestmsg>failed</requestmsg>";
}
xmlString = xmlString + "</newRequestInfo>";
xmlString = xmlString + "</gwcInfo>";
context.Response.Write(xmlString);
}
}