public CResutlWebMethod SetOrder(int nGroupID, string sOrder)
{
CResutlWebMethod result = new CResutlWebMethod();
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
result.sStatus = STFunction.process_Success();
List <TB_Material_Group> listtb_material_group = db.TB_Material_Group.ToList();
TB_Material_Group otb_material_group = listtb_material_group.FirstOrDefault(w => w.nGroupID == nGroupID);
if (otb_material_group != null)
{
otb_material_group.nOrder = sOrder.ToInt();
int n = 0;
var lstItem_OTHER = listtb_material_group.Where(w => w.nGroupID != nGroupID && w.IsDel == false).OrderBy(o => o.nOrder).ToList();
lstItem_OTHER.ForEach(i =>
{
n += 1;
if (n == sOrder.ToInt())
{
n += 1;
}
i.nOrder = n;
});
db.SaveChanges();
}
else
{
result.sMsg = "ไม่พบข้อมูลไม่ถูกต้อง";
result.sStatus = STFunction.process_Warning();
}
return(result);
}
public IActionResult ParcelGroup_Del_data(int[] nGroupID)
{
CResutlWebMethod result = new CResutlWebMethod();
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
if (nGroupID.Length > 0)
{
List <TB_Material_Group> tb_material_group = db.TB_Material_Group.Where(w => nGroupID.Contains(w.nGroupID)).ToList();
foreach (var i in tb_material_group)
{
i.IsDel = true;
db.SaveChanges();
}
SetOrderAll();
result.sStatus = STFunction.process_Success();
}
else
{
result.sStatus = STFunction.process_Warning();
}
return(Ok(result));
}
public IActionResult onDeleteDataMaterial(int nMaterialID)
{
CResutlWebMethod result = new CResutlWebMethod();
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
result.sStatus = STFunction.process_Success();
return(Ok(result));
}
public List <Stp_BarTrendChart_SearchData3> GetExecStpBarTrendChart3SearchData(string StartCreatedDate, string EndCreatedDate, string GroupID, string CategoryID, string MaterialID)
{
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
List <Stp_BarTrendChart_SearchData3> listStp_BarTrendChart_SearchData = new List <Stp_BarTrendChart_SearchData3>();
string Exceq = "EXEC [dbo].[Stp_BarTrendChart_SearchData] '" + StartCreatedDate + "','" + EndCreatedDate + "','" + GroupID + "'" + ",'" + CategoryID + "'" + ",'" + MaterialID + "'" + ",'" + "3" + "'";
var JsonString = STFunction.QryToJson(Exceq, "");
listStp_BarTrendChart_SearchData = JsonConvert.DeserializeObject <List <Stp_BarTrendChart_SearchData3> >(JsonString);
return(listStp_BarTrendChart_SearchData);
}
public IActionResult Savedata(V_Material_Category oV_Material_Category)
{
CResutlWebMethod result = new CResutlWebMethod();
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
result.sStatus = STFunction.process_Success();
try
{
if (!db.V_Material_Category.Any(w => w.sCategoryName.ToLower().Trim() == oV_Material_Category.sCategoryName.ToLower().Trim() && w.nCategoryID != oV_Material_Category.nCategoryID))
{
if (!db.V_Material_Category.Any(w => w.sCategoryCode.ToLower().Trim() == oV_Material_Category.sCategoryCode.ToLower().Trim() && w.nCategoryID != oV_Material_Category.nCategoryID))
{
TB_Material_Category otb_material_category = db.TB_Material_Category.Where(w => w.nCategoryID == oV_Material_Category.nCategoryID).FirstOrDefault();
if (otb_material_category == null)
{
otb_material_category = new TB_Material_Category();
otb_material_category.dCreate = DateTime.Now;
db.TB_Material_Category.Add(otb_material_category);
}
otb_material_category.nGroupID = oV_Material_Category.nGroupID.ToInt();
otb_material_category.sCategoryCode = oV_Material_Category.sCategoryCode;
otb_material_category.sName = oV_Material_Category.sCategoryName;
otb_material_category.sDetail = oV_Material_Category.sDetail;
otb_material_category.nOrder = oV_Material_Category.nOrder;
otb_material_category.IsActive = oV_Material_Category.IsActive;
otb_material_category.dUpdate = DateTime.Now;
db.SaveChanges();
}
else
{
result.sMsg = "รหัสประเภทวัสดุนี้มีในระบบแล้ว";
result.sStatus = STFunction.process_Warning();
}
}
else
{
result.sMsg = "ชื่อประเภทวัสดุนี้มีในระบบแล้ว";
result.sStatus = STFunction.process_Warning();
}
}
catch (Exception e)
{
result.sStatus = STFunction.process_Failed();
result.sMsg = e.ToString();
}
return(Ok(result));
}
public List <V_Withdrawal_Status> GetV_Withdrawal_Status_SearchData(string sStepID, string sStartDate, string sEndDate)
{
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
List <V_Withdrawal_Status> listv_withdrawal_status = new List <V_Withdrawal_Status>();
string Exceq = "EXEC [dbo].[Stp_Withdrawal_Status_SearchData] '" + sStartDate + "','" + sEndDate + "','" + sStepID + "'";
var JsonString = STFunction.QryToJson(Exceq, "");
listv_withdrawal_status = JsonConvert.DeserializeObject <List <V_Withdrawal_Status> >(JsonString);
return(listv_withdrawal_status);
}
public IActionResult Savedata(TB_Material_Group TB_Material_Group)
{
CResutlWebMethod result = new CResutlWebMethod();
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
result.sStatus = STFunction.process_Success();
try
{
if (!db.TB_Material_Group.Any(w => w.sName.ToLower().Trim() == TB_Material_Group.sName.ToLower().Trim() && w.nGroupID != TB_Material_Group.nGroupID && w.IsDel != true))
{
TB_Material_Group tb_material_group = db.TB_Material_Group.Where(w => w.nGroupID == TB_Material_Group.nGroupID).FirstOrDefault();
if (tb_material_group == null)
{
tb_material_group = new TB_Material_Group();
tb_material_group.dCreate = DateTime.Now;
db.TB_Material_Group.Add(tb_material_group);
}
tb_material_group.sName = TB_Material_Group.sName;
tb_material_group.sDetail = TB_Material_Group.sDetail;
tb_material_group.nOrder = TB_Material_Group.nOrder;
tb_material_group.IsActive = TB_Material_Group.IsActive;
tb_material_group.dUpdate = DateTime.Now;
db.SaveChanges();
}
else
{
result.sMsg = "ชื่อกลุ่มวัสดุนี้มีในระบบแล้ว";
result.sStatus = STFunction.process_Warning();
}
}
catch (Exception e)
{
result.sStatus = STFunction.process_Failed();
result.sMsg = e.ToString();
}
return(Ok(result));
}
public IActionResult GetMaterialGroup__Del_data(int[] nCategoryID)
{
CResutlWebMethod result = new CResutlWebMethod();
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
if (nCategoryID.Length > 0)
{
List <TB_Material_Category> listtb_material_category = db.TB_Material_Category.Where(w => nCategoryID.Contains(w.nCategoryID)).ToList();
foreach (var i in listtb_material_category)
{
i.IsDel = true;
db.SaveChanges();
}
SetOrderAll();
result.sStatus = STFunction.process_Success();
}
else
{
result.sStatus = STFunction.process_Warning();
}
return(Ok(result));
}
public IActionResult Requestapproval(data data)
{
CResutlWebMethod result = new CResutlWebMethod();
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
result.sStatus = STFunction.process_Success();
try
{
///-----------TB_Stock_Update
TB_Stock_Update tb_stock_update = db.TB_Stock_Update.Where(w => w.nRequestID == data.oV_Stock_Update.nRequestID).FirstOrDefault();
if (tb_stock_update == null)
{
tb_stock_update = new TB_Stock_Update();
var countrunning = db.TB_Stock_Update.Where(w => w.dCreate.Month == DateTime.Now.Month && w.dCreate.Year == DateTime.Now.Year).ToList().Count();
var running = "AS-" + DateTime.Now.AddYears(543).Year.ToString().Substring(2) + String.Format("{0:D2}", DateTime.Now.Month) + String.Format("{0:D4}", countrunning);
tb_stock_update.sRequestNo = running;
tb_stock_update.dCreate = DateTime.Now;
db.TB_Stock_Update.Add(tb_stock_update);
}
tb_stock_update.nStepID = data.oV_Stock_Update.nStepID ?? 0;
tb_stock_update.dUpdateStockDate = Convert.ToDateTime(data.oV_Stock_Update.sUpdatekc);
tb_stock_update.sReason = data.oV_Stock_Update.sReason;
tb_stock_update.nTotalPrice_Minus = data.oV_Materials.Select(s => s.nTotalPrice_Minus ?? 0).Sum();
tb_stock_update.nTotalPrice_Plus = data.oV_Materials.Select(s => s.nTotalPrice_Plus ?? 0).Sum();
tb_stock_update.nStepID = 1;
tb_stock_update.dUpdate = DateTime.Now;
db.SaveChanges();
///-----------TB_Stock_Update_Material
List <TB_Stock_Update_Material> list_stock_update_material = db.TB_Stock_Update_Material.Where(w => w.nRequestID == tb_stock_update.nRequestID).ToList();
if (list_stock_update_material != null)
{
foreach (TB_Stock_Update_Material otb_stock_update_material in list_stock_update_material)
{
db.TB_Stock_Update_Material.Remove(otb_stock_update_material);
}
}
foreach (V_Materials ov_materials in data.oV_Materials)
{
TB_Stock_Update_Material otb_stock_update_material = new TB_Stock_Update_Material();
otb_stock_update_material.nRequestID = tb_stock_update.nRequestID;
otb_stock_update_material.nMaterialID = ov_materials.nMaterialID;
otb_stock_update_material.nAmount = ov_materials.nAmount;
otb_stock_update_material.sCause = ov_materials.sReason;
db.TB_Stock_Update_Material.Add(otb_stock_update_material);
db.SaveChanges();
}
TB_Stock_Update_Approval otb_stock_update_approval = new TB_Stock_Update_Approval();
otb_stock_update_approval.nActionID = 1;
otb_stock_update_approval.dCreate = DateTime.Now;
otb_stock_update_approval.nRequestID = tb_stock_update.nRequestID;
db.TB_Stock_Update_Approval.Add(otb_stock_update_approval);
db.SaveChanges();
}
catch (Exception e)
{
result.sStatus = SysFunc.process_Error;
result.sMsg = e.Message;
}
return(Ok(result));
}
public SysModalGlobal.CResutlWebMethod SavetoDB([FromBody] TB_Material_Location data)
{
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
var result = new SysModalGlobal.CResutlWebMethod();
try
{
var MaterialLocation = db.TB_Material_Location.ToList();
var duplicate = (from a in db.TB_Material_Location
where !a.IsDel && a.sName.Trim().ToLower() == data.sName.Trim().ToLower() && a.nLocationID != data.nLocationID
select a).FirstOrDefault();
if (duplicate != null)
{
// result.sStatus = SysGlobal.SysFunc.process_Duplicate;
result.sStatus = STFunction.process_Warning();
result.sMsg = "สถานที่เก็บวัสดุนี้มีในระบบอยู่แล้ว";
return(result);
}
var nLocationID = (MaterialLocation.Any() ? MaterialLocation.Max(m => m.nLocationID) : 0) + 1;
if (data.nLocationID == 0)
{
db.TB_Material_Location.Add(new TB_Material_Location
{
sName = data.sName,
sDetail = data.sDetail,
IsActive = data.IsActive,
IsDel = false,
dCreate = DateTime.Now,
sCreateBy = data.sCreateBy,
dUpdate = DateTime.Now,
sUpdateBy = data.sUpdateBy,
});
db.SaveChanges();
}
else
{
var oldnID = (from a in db.TB_Material_Location
where a.nLocationID == data.nLocationID
select a).FirstOrDefault();
if (oldnID != null)
{
oldnID.sName = data.sName;
oldnID.sDetail = data.sDetail;
oldnID.IsActive = data.IsActive;
oldnID.IsDel = false;
oldnID.dUpdate = DateTime.Now;
oldnID.sUpdateBy = data.sUpdateBy;
db.SaveChanges();
}
}
result.sStatus = SysFunc.process_Success;
}
catch (Exception e)
{
result.sStatus = SysFunc.process_Error;
result.sMsg = e.Message;
}
return(result);
}
public static bool Send(EmailParameter o)
{
if (STFunction.GetAppSetting <string>("Email:Active") == "Y")//เพื่อตรวจสอบว่าจะให้ส่ง mail หรือไม่
{
try
{
string sConntentDemo = "<br/>From : " + o.sFrom + " <br /> To : " + o.sTo + "<br /> CC : " + o.sCC + " BCC : " + o.sBCC;
System.Net.Mail.MailMessage oMsg = new System.Net.Mail.MailMessage(); //MailMessage oMsg = new MailMessage();
//Set Font
string sSetFont = @"<style type='text/css'>
body{
font-family: " + FontFamily + @";
font-size: " + FontSize + @";
}
</ style > ";
if (STFunction.GetAppSetting <string>("Email:Debug") == "N")
{
#region Real E-mail
//From
if (!string.IsNullOrEmpty(o.sFrom))
{
oMsg.From = new System.Net.Mail.MailAddress(o.sFrom);
}
else
{
oMsg.From = new System.Net.Mail.MailAddress(STFunction.GetAppSetting <string>("Email:Sender"));
}
//To
if (!string.IsNullOrEmpty(o.sTo))
{
string[] mailToList = o.sTo.Replace(",", ";").Split(';');
foreach (string strM in mailToList)
{
if (strM != "")
{
oMsg.To.Add(strM);
}
}
}
//CC
if (!string.IsNullOrEmpty(o.sCC))
{
string[] mailToList = o.sCC.Replace(",", ";").Split(';');
foreach (string strM in mailToList)
{
if (strM != "")
{
oMsg.CC.Add(strM);
}
}
}
//BCC
if (!string.IsNullOrEmpty(o.sBCC))
{
string[] mailToList = o.sBCC.Replace(",", ";").Split(';');
foreach (string strM in mailToList)
{
if (strM != "")
{
oMsg.Bcc.Add(strM);
}
}
}
#endregion
}
else
{
#region Demo E-mail
o.sFrom = STFunction.GetAppSetting <string>("Email:Sender");
o.sTo = STFunction.GetAppSetting <string>("Email:DebugReceive");
o.sCC = "";
o.sBCC = "";
o.sMessage += sConntentDemo;
//From
oMsg.From = new System.Net.Mail.MailAddress(o.sFrom);
//To
if (!string.IsNullOrEmpty(o.sTo))
{
string[] mailToList = o.sTo.Replace(",", ";").Split(';');
foreach (string strM in mailToList)
{
if (strM != "")
{
oMsg.To.Add(strM);
}
}
}
//CC
if (!string.IsNullOrEmpty(o.sCC))
{
string[] mailToList = o.sCC.Replace(",", ";").Split(';');
foreach (string strM in mailToList)
{
if (strM != "")
{
oMsg.CC.Add(strM);
}
}
}
//BCC
if (!string.IsNullOrEmpty(o.sBCC))
{
string[] mailToList = o.sBCC.Replace(",", ";").Split(';');
foreach (string strM in mailToList)
{
if (strM != "")
{
oMsg.Bcc.Add(strM);
}
}
}
}
oMsg.Subject = o.sSubject;
// SEND IN HTML FORMAT (comment this line to send plain text).
oMsg.IsBodyHtml = true; //oMsg.BodyFormat = MailFormat.Html;
// HTML Body (remove HTML tags for plain text).
oMsg.Body = @"<HTML>" + sSetFont + "<BODY>" + o.sMessage + "</BODY></HTML>";
// ADD AN ATTACHMENT.
//TODO: Replace with path to attachment.
if (o.lstFile.Any())
{
o.lstFile.Select(s => new Attachment(s)).ToList().ForEach(oMsg.Attachments.Add);
}
// TODO: Replace with the name of your remote SMTP server.
System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient();
smtp.Port = (STFunction.GetAppSetting <string>("Email:Port") != "") ? int.Parse(STFunction.GetAppSetting <string>("Email:Port")) : 25;
smtp.Host = STFunction.GetAppSetting <string>("Email:SMTP");
smtp.Send(oMsg);
oMsg.Attachments.Dispose();
oMsg = null;
return(true);
//oAttch = null;
#endregion
}
catch
{
return(false);
}
}
else
{
return(true);
}
}
public SysModalGlobal.CResutlWebMethod SavetoDB([FromBody] lstSavedata data)
{
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
var result = new SysModalGlobal.CResutlWebMethod();
try
{
var Work = db.TB_Work.ToList();
var WorkMaterials = db.TB_Work_Material.ToList();
var duplicate = (from a in db.TB_Work
where !a.IsDel && a.sName.Trim().ToLower() == data.sName.Trim().ToLower() && a.nWorkID != data.nWorkID
select a).FirstOrDefault();
if (duplicate != null)
{
// result.sStatus = SysGlobal.SysFunc.process_Duplicate;
result.sStatus = STFunction.process_Warning();
result.sMsg = "ลักษณะงานนี้มีในระบบอยู่แล้ว";
return(result);
}
var nWorkID = (Work.Any() ? Work.Max(m => m.nWorkID) : 0) + 1;
if (data.nWorkID == 0)
{
TB_Work a = new TB_Work()
{
sName = data.sName,
nReasonID = data.nReasonID,
sDetail = data.sDetail,
IsActive = data.IsActive,
IsDel = false,
dCreate = DateTime.Now,
sCreateBy = data.sCreateBy,
dUpdate = DateTime.Now,
sUpdateBy = data.sUpdateBy,
};
db.TB_Work.Add(a);
db.SaveChanges();
db = new PTTGSP_DWSContext();
foreach (var per in data.lstWorkMaterial)
{
//data.lstWorkMaterial.Remove(per);
if (per.nWorkID == 0)
{
TB_Work_Material s = new TB_Work_Material();
s.nWorkID = nWorkID;
s.nMaterialID = per.nMaterialID;
s.nAmount = per.nAmount;
s.IsActive = per.IsActive;
db.TB_Work_Material.Add(s);
}
else
{
var edit = db.TB_Work_Material.FirstOrDefault(w => w.nWorkID == per.nWorkID);
if (edit != null)
{
edit.nMaterialID = per.nMaterialID;
edit.nAmount = per.nAmount;
edit.IsActive = per.IsActive;
}
}
}
db.SaveChanges();
}
else
{
var oldnID = (from a in db.TB_Work
where a.nWorkID == data.nWorkID
select a).FirstOrDefault();
if (oldnID != null)
{
oldnID.sName = data.sName;
oldnID.nReasonID = data.nReasonID;
oldnID.sDetail = data.sDetail;
oldnID.IsActive = data.IsActive;
oldnID.IsDel = false;
oldnID.dUpdate = DateTime.Now;
oldnID.sUpdateBy = data.sUpdateBy;
db.SaveChanges();
}
foreach (var per in data.lstWorkMaterial)
{
if (nWorkID != 0)
{
var editdata = db.TB_Work_Material.FirstOrDefault(w => w.nWorkID == per.nWorkID);
if (editdata != null)
{
db.TB_Work_Material.Remove(editdata);
editdata.nAmount = per.nAmount;
editdata.IsActive = per.IsActive;
}
}
}
db.SaveChanges();
foreach (var per in data.lstWorkMaterial)
{
TB_Work_Material s = new TB_Work_Material();
s.nMaterialID = per.nMaterialID;
s.nAmount = per.nAmount;
s.IsActive = per.IsActive;
db.TB_Work_Material.Add(s);
}
db.SaveChanges();
}
result.sStatus = SysFunc.process_Success;
}
catch (Exception e)
{
result.sStatus = SysFunc.process_Error;
result.sMsg = e.Message;
}
return(result);
}
