public static string MakeRequisition(string h, string i, string con, string thisid)
{
string ret = "";
JavaScriptSerializer jss = new JavaScriptSerializer();
var head = jss.Deserialize <Dictionary <string, dynamic> >(h);
if (thisid == "0")
{
dynamic ai = JObject.Parse(i);
decimal?tblInvReqMainID = 0;
string tblInvReqNo = "";
using (DBDataContext db = new DBDataContext())
{
db.sp_tblInvReqMain_Insert(Convert.ToInt32(Convert.ToString(Convert.ToString(((HttpCookie)HttpContext.Current.Request.Cookies["Emp_Id"]).Value))), Convert.ToInt32(con), Convert.ToDecimal(head["Head"]["StoreID"]), Convert.ToString(head["Head"]["StoreName"]), Convert.ToString(head["Head"]["Subject"]), Convert.ToString(head["Head"]["Description"]), ref tblInvReqMainID, ref tblInvReqNo);
List <tblInvReqSub> l = new List <tblInvReqSub>();
foreach (var item in ai.Items)
{
var f = item;
tblInvReqSub o = new tblInvReqSub();
o.ItemName = item.ItemName;
o.Quality = item.Quality;
o.Quantity = item.Quantity;
o.tblInvReqMainID = tblInvReqMainID;
o.temID = item.ItemID;
o.Unit = item.Unit;
l.Add(o);
}
db.tblInvReqSubs.InsertAllOnSubmit(l);
db.SubmitChanges();
}
ret = Convert.ToString(tblInvReqMainID) + "½" + tblInvReqNo;
}
else
{
MyClass Fn = new MyClass();
Fn.Exec("delete [dbo].[tblInvReqSub] where tblInvReqMainID=" + thisid.Split('½')[0]);
Fn.Exec(@"UPDATE tblInvReqMain
SET Status ='" + con + @"', ToStoreID ='" + Convert.ToString(head["Head"]["StoreID"]) + @"', StoreName ='" + Convert.ToString(head["Head"]["StoreName"]) + @"', Subject ='" + Convert.ToString(head["Head"]["Subject"]) + @"', Description ='" + Convert.ToString(head["Head"]["Description"]) + @"'
WHERE (tblInvReqMainID = " + thisid.Split('½')[0] + @" )");
using (DBDataContext db = new DBDataContext())
{
dynamic ai = JObject.Parse(i);
List <tblInvReqSub> l = new List <tblInvReqSub>();
foreach (var item in ai.Items)
{
var f = item;
tblInvReqSub o = new tblInvReqSub();
o.ItemName = item.ItemName;
o.Quality = item.Quality;
o.Quantity = item.Quantity;
o.tblInvReqMainID = Convert.ToDecimal(thisid.Split('½')[0]);
o.temID = item.ItemID;
o.Unit = item.Unit;
l.Add(o);
}
db.tblInvReqSubs.InsertAllOnSubmit(l);
db.SubmitChanges();
}
ret = thisid;
}
return(ret);
}
public void ProcessRequest(HttpContext context)
{
MyClass Fn = new MyClass();
string[] dataID = Fn.CleanSQL(HttpUtility.UrlDecode(context.Request.QueryString["id"])).Split('ǁ');
string[] fdata = new string[500];
if (context.Request.Form["ourformData"] != null)
{
//string testing = context.Request.Form["ourformData"];
fdata = HttpUtility.UrlDecode(context.Request.Form["ourformData"]).Split('½');
}
{
try
{
context.Response.ContentType = "text/HTML";
switch (Convert.ToInt32(dataID[0]))
{
case 0:
context.Response.Write(Fn.Data2Json("Select * from [dbo].[tblInventoryDefault] where tblInventoryDefaultID=1"));
break;
case 1:
context.Response.Write(Fn.Exec(@"UPDATE tblInventoryDefault
SET MaxLevels =" + dataID[1] + @"
WHERE (tblInventoryDefaultID = 1)"));
break;
case 2:
// context.Response.Write(Fn.Data2Json(@"SELECT tblPlaceID, Code, Name, Branch= (
//
//Select count(*) from tblPlace as B where B.ParentId= M.tblPlaceID
//)
//FROM tblPlace AS M
//WHERE ParentId IS NULL order by Code"));
context.Response.Write(Fn.Data2Json(@"Select M.CompanyID AS tblPlaceID, M.Code , M.CompanyName AS Name, 0 bIsHead, Branch= (
Select count(*) from tbl_Company AS B Where B.ParentId=M.CompanyID
) from tbl_Company as M WHERE M.ParentId IS NULL
order by M.CompanyID, M.Code"));
break;
case 3:
// context.Response.Write(Fn.Data2Json(@" SELECT tblPlaceID, Code, Name, Branch= (
//
//Select count(*) from tblPlace as B where B.ParentId= M.tblPlaceID
//)
//FROM tblPlace AS M
//WHERE ParentId =" + dataID[1] + " order by Code"));
context.Response.Write(Fn.Data2Json(@" SELECT M.CompanyID AS tblPlaceID, Code, M.CompanyName Name, 0 bIsHead, Branch= (
Select count(*) from tbl_Company as B where B.ParentId= M.CompanyID
)
FROM tbl_Company AS M
WHERE ParentId =" + dataID[1] + " order by Code"));
break;
case 4:
// context.Response.Write(Fn.Exec(@"UPDATE tblPlace
//SET Name = '" + dataID[1] + @"'
//WHERE (tblPlaceID = " + dataID[2] + ")"));
context.Response.Write(Fn.Exec(@"UPDATE tbl_Company
SET CompanyName = '" + dataID[1] + @"'
WHERE (CompanyID = " + dataID[2] + ")"));
break;
case 5:
decimal?tblid = 0;
int? tblcode = 0;
using (DBDataContext db = new DBDataContext())
{
db.sp_tblPlace_Insert(dataID[1], dataID[2], ref tblid, ref tblcode);
}
string sssssss = Convert.ToString(tblid) + "½" + Convert.ToString(tblcode);
context.Response.Write(sssssss);
break;
default:
context.Response.Write("<p>Contents not available</p>");
break;
}
}
catch
{
context.Response.ContentType = "text/HTML";
context.Response.Write("<p>Contents not available</p>");
}
}
}
