//-- function --
string ReceiveItemFunc(sapi.db db, Dictionary <string, string> vals, string mySt)
{
Dictionary <string, string> aVal = new Dictionary <string, string>();
string re = "";
string screen = "tblReceiveNew";
string screenItem = "tblReceiveItemNew";
string whid = "0";
sapi.sapi cls = new sapi.sapi();
db.beginTran();
re = cls.saveRecord(screen, vals, db, aVal, ignoreROF: true);
var str = JsonConvert.DeserializeObject <dynamic>(re);
if (str.tbl != null)
{
if (str.tbl[0].status == "ok")
{
whid = vals["rece_WarehouseID".ToLower()];
clsGlobal clsglobal = new clsGlobal();
string hid = (string)str.tbl[0].msg;
aVal.Clear();
aVal.Add("reit_receiveid", hid);
//foreach (var st in Request.Form["N"].ToString().Split(','))
foreach (var st in mySt.ToString().Split(','))
{
{
string re2 = "";
Dictionary <string, string> v = cls.getItemVals(screenItem, vals, db, st);
v.Add("rece_Date".ToLower(), vals["rece_Date".ToLower()]);
double quit_Qty = 0;
double quit_Price = 0;
if (v.ContainsKey("reit_Qty".ToLower()))
{
quit_Qty = db.cNum(v["reit_Qty".ToLower()]);
}
if (v.ContainsKey("reit_Price".ToLower()))
{
quit_Price = db.cNum(v["reit_Price".ToLower()]);
}
if (v.ContainsKey("reit_Total".ToLower()))
{
v["reit_Total".ToLower()] = (quit_Qty * quit_Price).ToString();
}
else
{
v.Add("reit_Total".ToLower(), (quit_Qty * quit_Price).ToString());
}
re2 = cls.saveRecord(screenItem, v, db, aVal, st);
str = JsonConvert.DeserializeObject <dynamic>(re2);
if (str.tbl != null)
{
if (str.tbl[0].status != "ok")
{
db.rollback();
return(re2);
}
else
{
clsglobal.receiveItem(db, v, whid);
}
}
}
}
clsglobal.ReceiveTotal(hid, db);
}
}
db.commit();
return(re);
}
string uploadSO(sapi.db db, Dictionary <string, string> vals, string mySt)
{
string token = Request.Headers.GetValues("token").First();
UserProfileViewDTO userProfile = Helper.Helper.GetUserProfile(token);
HttpContext.Current.Session["userid"] = userProfile.id;
HttpContext.Current.Session["user"] = userProfile.userName;
string re = "";
string re2 = "";
string hid = "";
sapi.sapi cls = new sapi.sapi();
string screenItem = "tblSaleOrderItemNew";
string screen = "tblSaleOrderNew";
Dictionary <string, string> aVal = new Dictionary <string, string>();
DataTable tblResult = new DataTable();
tblResult.Rows.Add();
tblResult.Columns.Add("status");
tblResult.Columns.Add("msg");
db.beginTran();
if (!vals.ContainsKey("sord_Date".ToLower()))
{
vals.Add("sord_Date".ToLower(), db.getDate(DateTime.UtcNow.AddHours(7).ToString("yyyy-MM-dd HH:mm"), 1));
}
else
{
vals.Remove("sord_Date".ToLower());
vals.Add("sord_Date".ToLower(), db.getDate(DateTime.UtcNow.AddHours(7).ToString("yyyy-MM-dd HH:mm"), 1));
}
if (vals.ContainsKey("invo_daystoexp"))
{
double invo_daystoexp = db.cNum(vals["invo_daystoexp"]);
if (!vals.ContainsKey("sord_Date".ToLower()))
{
vals.Add("sord_EndDate".ToLower(), db.getDate(DateTime.UtcNow.AddDays(invo_daystoexp).AddHours(7).ToString("yyyy-MM-dd HH:mm"), 1));
}
else
{
vals.Remove("sord_EndDate".ToLower());
vals.Add("sord_EndDate".ToLower(), db.getDate(DateTime.UtcNow.AddDays(invo_daystoexp).AddHours(7).ToString("yyyy-MM-dd HH:mm"), 1));
}
}
if (vals.ContainsKey("sord_saleorderid"))
{
if (string.IsNullOrEmpty(vals["sord_saleorderid"]) || vals["sord_saleorderid"] == "0")
{
vals.Remove("sord_saleorderid");
}
}
if (vals.ContainsKey("tbls_tableid"))
{
if (!string.IsNullOrEmpty(vals["tbls_tableid"]))
{
db.execData("Update tblTable Set tbls_Status = 'O' Where tbls_TableID = " + vals["tbls_tableid"]);
aVal.Add("sord_TableID", vals["tbls_tableid"]);
}
}
string sord_assignedto = "";
if (vals.ContainsKey("sord_assignedto".ToLower()))
{
if (!string.IsNullOrEmpty(vals["sord_assignedto".ToLower()]))
{
sord_assignedto = vals["sord_assignedto".ToLower()];
}
}
if (string.IsNullOrEmpty(sord_assignedto))
{
DataTable tmpTbl = db.readData("exec notificationSetup 'SO'");
if (tmpTbl.Rows.Count > 0)
{
sord_assignedto = tmpTbl.Rows[0][0].ToString();
}
}
if (!vals.ContainsKey("sord_assignedto".ToLower()))
{
vals["sord_assignedto"] = sord_assignedto;
}
else
{
vals.Add("sord_assignedto", sord_assignedto);
}
re = cls.saveRecord(screen, vals, db, aVals: aVal, ignoreROF: true);
var str = JsonConvert.DeserializeObject <dynamic>(re);
if (str.tbl != null)
{
if (str.tbl[0].status == "ok")
{
hid = (string)str.tbl[0].msg;
//foreach (var st in Request.Form["N"].ToString().Split(','))
foreach (var st in mySt.ToString().Split(','))
{
aVal.Clear();
aVal.Add("soit_SaleOrderID", hid);
if (string.IsNullOrEmpty(st))
{
continue;
}
Dictionary <string, string> v = cls.getItemVals(screenItem, vals, db, st);
v["soit_total"] = (db.cNum(v["soit_Qty".ToLower()].ToString()) * db.cNum(v["soit_Price".ToLower()].ToString())).ToString();
aVal.Add("soit_ShipQty", "0");
aVal.Add("soit_RemainQty", v["soit_Qty".ToLower()]);
if (vals.ContainsKey("soit_saleorderitemid"))
{
if (string.IsNullOrEmpty(vals["soit_saleorderitemid"]) || vals["soit_saleorderitemid"] == "0")
{
vals.Remove("soit_saleorderitemid");
}
}
re2 = cls.saveRecord(screenItem, v, db, aVal, st, ignoreROF: true);
str = JsonConvert.DeserializeObject <dynamic>(re2);
if (str.tbl != null)
{
if (str.tbl[0].status != "ok")
{
db.rollback();
return(re2);
}
}
}
new clsGlobal().SOTotal(hid, db);
if (!string.IsNullOrEmpty(sord_assignedto))
{
db.execData("insert into [dbo].[sys_notification]" +
"([notf_Name],[notf_objectID],[notf_objectValue],[notf_Module],[notf_UserID],[notf_FromUserID])" +
"values(NULL," +
"1035," + hid + ",'SO'," + sord_assignedto + "," + userProfile.id + ")");
new clsGlobal().notification(userProfile.id.ToString(), "SO", sord_assignedto, db);
}
}
else
{
db.rollback();
return(re);
}
}
db.commit();
return(re);
}
