public static sysGlobalClass.CResutlWebMethod RoleSelected(string sRoleID)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
//if (!UserAcc.UserExpired())
//{
// PTTPIMSAssessmentEntities db = new PTTPIMSAssessmentEntities();
// int nRoleID = SystemFunction2.ParseInt(sRoleID);
// var query = db.TGroupUser.FirstOrDefault(w => w.nGroupID == nRoleID && w.cActive == "1");
// if (query != null)
// {
// UserAcc.GetObjUser().nRoleID = query.nGroupID;
// UserAcc.GetObjUser().sACTIONROLE = query.sGroupname;
// HttpContext.Current.Session["ROLE"] = query.nGroupID;
// HttpContext.Current.Session["ACTIONROLE"] = query.sGroupname;
// result.Status = SystemFunction2.process_Success;
// result.Content = SystemFunction2.GetPageDefault();
// }
// else
// {
// result.Status = SystemFunction2.process_Failed;
// result.Msg = "ไม่พบ Role !";
// }
//}
//else
//{
// result.Status = SystemFunction2.process_SessionExpired;
//}
return(result);
}
public static sysGlobalClass.CResutlWebMethod DeleteData(string[] arrValue)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
if (!UserAcc.UserExpired())
{
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
List <int> lstDelID = new List <int>();
if (arrValue != null)
{
lstDelID = arrValue.Select(s => s.toIntNullToZero()).ToList();
}
int nUserID = UserAcc.GetObjUser().nUserID;
db.mTCompany.Where(w => w.ID != EPIFunc.DataType.Company.PTTGCID && lstDelID.Contains(w.ID)).ToList().ForEach(x =>
{
x.cDel = "Y";
x.dUpdate = DateTime.Now;
x.UpdateID = nUserID;
});
db.mTFacility.Where(w => lstDelID.Contains(w.CompanyID)).ToList().ForEach(x =>
{
x.cDel = "Y";
x.dUpdate = DateTime.Now;
x.UpdateID = nUserID;
});
db.SaveChanges();
result.Status = SystemFunction.process_Success;
}
else
{
result.Status = SystemFunction.process_SessionExpired;
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod ApproveWithEditContent(int FormID)
{
PTTGC_EPIEntities env = new PTTGC_EPIEntities();
sysGlobalClass.CResutlWebMethod r = new sysGlobalClass.CResutlWebMethod();
int nOperationType = 0;
if (!UserAcc.UserExpired())
{
var gData = env.TEPI_Forms.FirstOrDefault(f => f.FormID == FormID);
if (gData != null)
{
r.Msg = SystemFunction.ReturnPath(gData.IDIndicator, gData.OperationTypeID, gData.FacilityID.ToString(), gData.sYear, "27");
r.Status = SystemFunction.process_Success;
}
else
{
r.Msg = "";
r.Status = SystemFunction.process_Failed;
}
}
else
{
r.Msg = "";
r.Status = SystemFunction.process_SessionExpired;
}
return(r);
}
public static sysGlobalClass.CResutlWebMethod SaveAction(List <int> lstMonth, int FormID, string sComment, string sMode)
{
sysGlobalClass.CResutlWebMethod r = new sysGlobalClass.CResutlWebMethod();
if (!UserAcc.UserExpired())
{
int nRoleID = UserAcc.GetObjUser().nRoleID;
int nUserID = UserAcc.GetObjUser().nUserID;
if (nRoleID == 3)
{
r = new Workflow().WorkFlowAction(FormID, lstMonth, sMode, nUserID, nRoleID, sComment);
}// L1
else if (nRoleID == 2)
{
}//
else if (nRoleID == 4)
{
r = new Workflow().WorkFlowAction(FormID, lstMonth, sMode, nUserID, nRoleID, sComment);
}//L2
}
else
{
r.Status = SystemFunction.process_SessionExpired;
r.Msg = "";
}
//r = new Workflow().WorkFlowAction();
return(r);
}
public static sysGlobalClass.CResutlWebMethod getOperationTypePTT(string sFacilityPTT_ID)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
if (!UserAcc.UserExpired())
{
int nFacilityPTT_ID = SystemFunction.GetIntNullToZero(sFacilityPTT_ID);
var item = db.mTFacility.FirstOrDefault(w => w.ID == nFacilityPTT_ID);
if (item != null)
{
result.Content = item.OperationTypeID + "";
result.Status = SystemFunction.process_Success;
}
else
{
result.Msg = "Data operation type not found.";
result.Status = SystemFunction.process_Failed;
}
}
else
{
result.Status = SystemFunction.process_SessionExpired;
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod ForgetPassword(string sEmail, string sUsername)
{
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
sEmail = sEmail.ToLower();
sUsername = sUsername.ToLower();
var lstUser = db.mTUser.Where(w => w.cActive == "Y" && w.cDel == "N" && w.Username.ToLower() == sUsername && w.Email.ToLower() == sEmail).ToList();
if (lstUser.Any())
{
var Data = lstUser.First();
string sTitle = "";
string sText = "";
string subject = "";
string message = "";
string sURL = "";
string sFoot = "";// "Should you have any questions about RD&T work process.";
// sURL = Applicationpath + "login_forget.aspx?str=" + SystemFunction.Encrypt_UrlEncrypt(nDocID + "");
subject = "Password Confirmation | " + SystemFunction.SystemName + "";
sText += "<p>Your password is " + STCrypt.Decrypt(Data.PasswordEncrypt) + "</p>";
string From = SystemFunction.GetSystemMail;
string To = Data.Email;
message = string.Format(GET_TemplateEmail(),
"Dear " + Data.Firstname + ' ' + Data.Lastname,
sText,
sURL,
sFoot,
"",
"");
Workflow.DataMail_log log = new Workflow.DataMail_log();
log = SystemFunction.SendMailAll(From, To, "", "", subject, message, "");
log.nDataID = SystemFunction.GetIntNullToZero(Data.ID + "");
log.sPageName = "login.aspx";
new Workflow().SaveLogMail(log);
if (log.bStatus)
{
result.Status = SystemFunction.process_Success;
}
}
else
{
result.Status = SystemFunction.process_Failed;
result.Msg = "data not found user";
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod SelectedRole(string sUserID, string sRoleID)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
if (new bypass().SetUserLogin(sUserID, sRoleID))
{
result.Status = SystemFunction.process_Success;
result.Content = "epi_mytask.aspx";
}
else
{
result.Status = SystemFunction.process_Failed;
result.Msg = "data not found";
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod ApproveAll(List <DataApproveAll> arrValue)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
if (!UserAcc.UserExpired())
{
PTTGC_EPIEntities env = new PTTGC_EPIEntities();
int nUserID = UserAcc.GetObjUser().nUserID;
int nRoleID = UserAcc.GetObjUser().nRoleID;
var gForm = arrValue.Select(s => s.nFormID).Distinct().ToList();
int FormID = 0;
if (gForm.Any())
{
gForm.ForEach(f =>
{
FormID = f;
List <int> lstMonth = new List <int>();
arrValue.ForEach(f2 =>
{
if (f == f2.nFormID)
{
lstMonth.Add(f2.nMonth);
}
});
if (lstMonth.Any())
{
result = new Workflow().WorkFlowAction(FormID, lstMonth, "AP", nUserID, nRoleID, "");
}
});
}
}
else
{
result.Status = SystemFunction.process_SessionExpired;
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod DeleteDataGC(string[] arrValue)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
if (!UserAcc.UserExpired())
{
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
List <int> lstDelID = new List <int>();
if (arrValue != null)
{
lstDelID = arrValue.Select(s => s.toIntNullToZero()).ToList();
}
int nUserID = UserAcc.GetObjUser().nUserID;
db.mTFacility.Where(w => lstDelID.Contains(w.ID)).ToList().ForEach(x =>
{
db.mTFacility_Operationtype.RemoveRange(db.mTFacility_Operationtype.Where(w => w.nFacID == x.ID));
x.cDel = "Y";
x.dUpdate = DateTime.Now;
x.UpdateID = nUserID;
});
foreach (var item in lstDelID)
{
var qDelSubFac = db.mTFacility.Where(w => w.nLevel == 2 && w.nHeaderID == item);
foreach (var itemS in qDelSubFac)
{
itemS.cDel = "Y";
itemS.dUpdate = DateTime.Now;
itemS.UpdateID = nUserID;
}
}
db.SaveChanges();
result.Status = SystemFunction.process_Success;
}
else
{
result.Status = SystemFunction.process_SessionExpired;
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod DeleteData(string[] arrValue)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
if (!UserAcc.UserExpired())
{
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
List <int> lstDelID = new List <int>();
if (arrValue != null)
{
foreach (var item in arrValue)
{
string[] strArr = null;
char[] splitchar = { ',' };
strArr = item.Split(splitchar);
int nFacID = int.Parse(strArr[0]);
int nGroupID = int.Parse(strArr[1]);
int nUserID = UserAcc.GetObjUser().nUserID;
db.mTWorkFlow.Where(w => w.IDFac == nFacID && w.IDIndicator == nGroupID).ToList().ForEach(x =>
{
db.mTWorkFlow.Remove(x);
//x.cDel = "Y";
//x.dUpdate = DateTime.Now;
//x.nUpdateID = nUserID;
});
}
}
db.SaveChanges();
result.Status = SystemFunction.process_Success;
}
else
{
result.Status = SystemFunction.process_SessionExpired;
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod SaveData(CSaveData data)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
if (!UserAcc.UserExpired())
{
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
Func <string, int?, bool> CheckDuplicateName = (name, id) =>
{
bool Isdup = false;
var q = db.mTCompany.Where(w => (id.HasValue ? w.ID != id : true) && w.Name == name && w.cDel == "N");
Isdup = q.Any();
return(Isdup);
};
Func <string, int?, bool> CheckDuplicateCode = (code, id) =>
{
bool Isdup = false;
var q = db.mTCompany.Where(w => (id.HasValue ? w.ID != id : true) && w.sCode == code && w.cDel == "N");
Isdup = q.Any();
return(Isdup);
};
string sCompID = data.sCompID.STCDecrypt();
if (!string.IsNullOrEmpty(sCompID))
{
int nCompID = sCompID.toIntNullToZero();
if (!CheckDuplicateName(data.sCompName, nCompID))
{
if (!CheckDuplicateCode(data.sCode, nCompID))
{
var query = db.mTCompany.FirstOrDefault(w => w.ID == nCompID);
if (query != null)
{
query.Name = data.sCompName.Trims();
query.sCode = data.sCode.Trims();
query.Description = data.sDesc;
query.cActive = data.sStatus;
query.dUpdate = DateTime.Now;
query.UpdateID = UserAcc.GetObjUser().nUserID;
if (data.sStatus == "N")
{
query.sRemark = data.sRemark.Trims();
}
else
{
query.sRemark = "";
}
db.SaveChanges();
result.Status = SystemFunction.process_Success;
}
else
{
result.Status = SystemFunction.process_Failed;
result.Msg = "Not found data !";
}
}
else
{
result.Msg = "Duplicate SAP code !";
result.Status = SystemFunction.process_Failed;
}
}
else
{
result.Msg = "Duplicate company name !";
result.Status = SystemFunction.process_Failed;
}
}
else
{
if (!CheckDuplicateName(data.sCompName, null))
{
if (!CheckDuplicateCode(data.sCode, null))
{
int nCompID = db.mTCompany.Any() ? db.mTCompany.Max(x => x.ID) + 1 : 1;
mTCompany t = new mTCompany();
t.ID = nCompID;
t.Name = data.sCompName.Trims();
t.sCode = data.sCode.Trims();
t.Description = data.sDesc;
t.cActive = data.sStatus;
if (data.sStatus == "N")
{
t.sRemark = data.sRemark.Trims();
}
t.CreateID = UserAcc.GetObjUser().nUserID;
t.dCreate = DateTime.Now;
t.UpdateID = UserAcc.GetObjUser().nUserID;
t.dUpdate = DateTime.Now;
t.cDel = "N";
db.mTCompany.Add(t);
db.SaveChanges();
result.Status = SystemFunction.process_Success;
}
else
{
result.Msg = "Duplicate SAP code !";
result.Status = SystemFunction.process_Failed;
}
}
else
{
result.Msg = "Duplicate company name !";
result.Status = SystemFunction.process_Failed;
}
}
}
else
{
result.Status = SystemFunction.process_SessionExpired;
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod SaveData(CSaveData data)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
if (UserAcc.UserExpired())
{
result.Status = SystemFunction.process_SessionExpired;
}
else
{
int nProductID = 0;
Func <string, int?, bool> CheckDuplicateName = (name, id) =>
{
bool Isdup = false;
var q = db.TM_Emission_OtherProduct.Where(w => (id.HasValue ? w.nProductID != id : true) && w.sName == name && w.cDel == "N");
Isdup = q.Any();
return(Isdup);
};
if (string.IsNullOrEmpty(data.sProductID)) // NEW
{
nProductID = db.TM_Emission_OtherProduct.Any() ? db.TM_Emission_OtherProduct.Max(m => m.nProductID) + 1 : 1;
TM_Emission_OtherProduct t = new TM_Emission_OtherProduct();
if (!CheckDuplicateName(data.sName, null))
{
t.nProductID = nProductID;
t.sName = data.sName.Trim();
t.cActive = data.sStatus;
t.cDel = "N";
t.nAddBy = UserAcc.GetObjUser().nUserID;
t.dAdd = DateTime.Now;
t.nUpdateBy = UserAcc.GetObjUser().nUserID;
t.dUpdate = DateTime.Now;
db.TM_Emission_OtherProduct.Add(t);
}
else
{
result.Msg = "Duplicate Name !";
result.Status = SystemFunction.process_Failed;
return(result);
}
}
else
{
nProductID = int.Parse(data.sProductID);
if (!CheckDuplicateName(data.sName, nProductID))
{
var Query = db.TM_Emission_OtherProduct.FirstOrDefault(w => w.nProductID == nProductID);
if (Query != null)
{
Query.sName = data.sName.Trim();
Query.cActive = data.sStatus;
Query.cDel = "N";
Query.nUpdateBy = UserAcc.GetObjUser().nUserID;
Query.dUpdate = DateTime.Now;
}
}
else
{
result.Msg = "Duplicate Name !";
result.Status = SystemFunction.process_Failed;
return(result);
}
}
db.SaveChanges();
result.Status = SystemFunction.process_Success;
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod SaveToDB(CSave_Data item, List <dataFileContactUs> objFile)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
DateTime now = DateTime.Now;
if (UserAcc.UserExpired())
{
result.Status = SystemFunction.process_SessionExpired;
}
else
{
UserAcc ua = UserAcc.GetObjUser();
try
{
string sPathSend = "";
int nID = db.TContactUs.Any() ? db.TContactUs.Max(m => m.nContactID) + 1 : 1;
TContactUs t = new TContactUs();
t.nContactID = nID;
t.sContactName = item.sName;
t.sContactEmail = item.sEmail;
t.sContactTel = item.sTel;
t.sSubject = item.sSubject;
t.sDetail = item.sDec;
t.dCreate = now;
t.dUpdate = now;
t.cDel = "N";
if (objFile.Count > 0 && objFile != null)
{
string sPathSave = string.Format(sFolderInPathSave, nID);
SystemFunction.CreateDirectory(sPathSave);
//string sPathSave = string.Format(sFolderInPathSave, nID);
//SystemFunction.CreateDirectory(sPathSave);
var f = objFile.First();
string sSystemFileName = nID + "_" + "-" + DateTime.Now.ToString("ddMMyyyyHHmmss") + "." + SystemFunction.GetFileNameFromFileupload(f.sFileName, ""); //SystemFunction2.GetFileType(item.SaveToFileName);
SystemFunction.UpFile2Server(f.sPath, sPathSave, f.sSysFileName, sSystemFileName);
t.sContactFile = f.sFileName;
t.sContactSysFile = sSystemFileName;
t.sContactPath = sPathSave;
sPathSend = HttpContext.Current.Server.MapPath("./") + sPathSave + sSystemFileName;
}
//t.cStatusAns = "NULL";
db.TContactUs.Add(t);
var Ispass = db.SaveChanges() > 0;
if (Ispass)
{
string From = "";
var lstUser = db.mTUser.FirstOrDefault(w => w.ID == ua.nUserID);
if (lstUser != null)
{
From = lstUser.Email;
}
// string From = item.sEmail;
#region Get_Email_Admin
string AdminContactmail = "";
var lst_Email_Admin = db.TMenu_Permission.Where(w => w.nRoleID == 1 && w.nMenuID == 65 && w.nPermission == 2).ToList();
if (lst_Email_Admin.Any())
{
lst_Email_Admin.ForEach(f =>
{
int nUserID = f.nUserID;
var lst_Tuser = db.mTUser.FirstOrDefault(w => w.cActive == "Y" && w.ID == nUserID);
if (lst_Tuser != null)
{
AdminContactmail += "," + lst_Tuser.Email + " ";
}
});
AdminContactmail = AdminContactmail.Remove(0, 1);
}
else
{
AdminContactmail = WebConfigurationManager.AppSettings["ContactMail"] + "";
}
#endregion
string To = "*****@*****.**";
string sSubject = SystemFunction.sAbbrSystem + " : Contact Us." + item.sSubject;
string sGurl = SystemFunction.RequestUrl() + WebConfigurationManager.AppSettings["DefaultPage"] + "";
string sHtml = @"
<table align='left' border='0' cellspacing='2' cellpadding='3'>
<tr>
<td align='left'>Dear administrator: " + SystemFunction.SystemName + @" </td>
</tr>
<tr>
<td align='left'>Subject: " + item.sSubject + @"</td>
</tr>
<tr>
<td align='left'>Description: " + item.sDec + @"</td>
</tr>
<tr>
<td align='left'>From: " + item.sName + " E-mail: " + item.sEmail + " Contact phone number: " + item.sTel + @"</td>
</tr>
<tr>
<td align='left'><b>Check out more details.</b>: <a href='" + sGurl + @"' target='_blank'>Please click here</a></td>
</tr>
</table>";
//sPathSend != "" ? sPathSend.Replace("/", "\\") : ""
Workflow.DataMail_log log = new Workflow.DataMail_log();
log = SystemFunction.SendMailAll(From, AdminContactmail, "", "", sSubject, sHtml, sPathSend != "" ? sPathSend.Replace("/", "\\") : "");
log.nDataID = SystemFunction.GetIntNullToZero(nID + "");
log.sPageName = "f_ContactUs.aspx";
new Workflow().SaveLogMail(log);
if (log.bStatus)
{
result.Status = SystemFunction.process_Success;
}
}
}
catch (Exception e)
{
result.Msg = e.Message;
result.Status = SystemFunction.process_Failed;
}
result.Status = SystemFunction.process_Success;
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod SaveToDB(cDataSave arrData)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
Func <List <string>, string> Sum = (lstData) =>
{
string sReusltData = "";
int Total = 0;
foreach (var item in lstData)
{
if (item.Trim() != "" && item.ToLower().Trim() != "n/a")
{
Total += int.Parse(item);
}
}
return(sReusltData);
};
if (!UserAcc.UserExpired())
{
var itemEPI_FORM = db.TEPI_Forms.FirstOrDefault(w => w.sYear == arrData.sYear && w.IDIndicator == arrData.nIndicatorID && w.OperationTypeID == arrData.nOperationID && w.FacilityID == arrData.nFacilityID);
bool IsNew = itemEPI_FORM != null ? false : true;
int FORM_ID = itemEPI_FORM != null ? itemEPI_FORM.FormID : (db.TEPI_Forms.Any() ? db.TEPI_Forms.Max(m => m.FormID) + 1 : 1);
#region EPI_FORM
var EPI_FORM = db.TEPI_Forms.FirstOrDefault(w => w.FormID == FORM_ID);
if (IsNew)
{
EPI_FORM = new TEPI_Forms();
EPI_FORM.FormID = FORM_ID;
EPI_FORM.sYear = arrData.sYear;
EPI_FORM.IDIndicator = arrData.nIndicatorID;
EPI_FORM.OperationTypeID = arrData.nOperationID;
EPI_FORM.FacilityID = arrData.nFacilityID;
EPI_FORM.sAddBy = UserAcc.GetObjUser().nUserID;
EPI_FORM.dAddDate = DateTime.Now;
EPI_FORM.ResponsiblePerson = UserAcc.GetObjUser().nUserID;
EPI_FORM.sUpdateBy = UserAcc.GetObjUser().nUserID;
EPI_FORM.dUpdateDate = DateTime.Now;
db.TEPI_Forms.Add(EPI_FORM);
}
else
{
if (!SystemFunction.IsSuperAdmin())
{
EPI_FORM.ResponsiblePerson = UserAcc.GetObjUser().nUserID;
EPI_FORM.sUpdateBy = UserAcc.GetObjUser().nUserID;
EPI_FORM.dUpdateDate = DateTime.Now;
}
}
db.SaveChanges();
#endregion
#region EPI Workflow
int nWkFlowID = db.TEPI_Workflow.Any() ? db.TEPI_Workflow.Max(m => m.nReportID) + 1 : 1;
for (int i = 1; i <= 12; i++)
{
int nStatus = 0;
if (arrData.nStatus != 0)
{
var itemData = arrData.lstMonthSubmit.FirstOrDefault(a => a == i);
if (itemData != null && itemData != 0)
{
nStatus = arrData.nStatus;
}
}
var wkflow = db.TEPI_Workflow.FirstOrDefault(w => w.FormID == FORM_ID && w.nMonth == i);
if (wkflow == null)
{
wkflow = new TEPI_Workflow();
wkflow.nReportID = nWkFlowID;
wkflow.FormID = FORM_ID;
wkflow.nMonth = i;
wkflow.nStatusID = nStatus;
wkflow.nActionBy = UserAcc.GetObjUser().nUserID;
wkflow.dAction = DateTime.Now;
db.TEPI_Workflow.Add(wkflow);
nWkFlowID++;
}
}
db.SaveChanges();
#endregion
#region Product
if (arrData.nStatus != 24)
{
if (!IsNew)
{
db.TComplaint_Product.RemoveRange(db.TComplaint_Product.Where(w => w.FormID == FORM_ID));
db.TComplaint.RemoveRange(db.TComplaint.Where(w => w.FormID == FORM_ID));
db.TComplaint_Impact.RemoveRange(db.TComplaint_Impact.Where(w => w.FormID == FORM_ID));
db.SaveChanges();
}
#region TComplaint_Product
TComplaint_Product dataComplaintPrd = new TComplaint_Product();
dataComplaintPrd.FormID = FORM_ID;
dataComplaintPrd.ProductID = arrData.incData.ProductID;
dataComplaintPrd.UnitID = arrData.incData.nUnitID;
dataComplaintPrd.Target = arrData.incData.sTarget;
dataComplaintPrd.M1 = arrData.incData.M1;
dataComplaintPrd.M2 = arrData.incData.M2;
dataComplaintPrd.M3 = arrData.incData.M3;
dataComplaintPrd.M4 = arrData.incData.M4;
dataComplaintPrd.M5 = arrData.incData.M5;
dataComplaintPrd.M6 = arrData.incData.M6;
dataComplaintPrd.M7 = arrData.incData.M7;
dataComplaintPrd.M8 = arrData.incData.M8;
dataComplaintPrd.M9 = arrData.incData.M9;
dataComplaintPrd.M10 = arrData.incData.M10;
dataComplaintPrd.M11 = arrData.incData.M11;
dataComplaintPrd.M12 = arrData.incData.M12;
dataComplaintPrd.IsCheckM1 = arrData.incData.IsCheckM1;
dataComplaintPrd.IsCheckM2 = arrData.incData.IsCheckM2;
dataComplaintPrd.IsCheckM3 = arrData.incData.IsCheckM3;
dataComplaintPrd.IsCheckM4 = arrData.incData.IsCheckM4;
dataComplaintPrd.IsCheckM5 = arrData.incData.IsCheckM5;
dataComplaintPrd.IsCheckM6 = arrData.incData.IsCheckM6;
dataComplaintPrd.IsCheckM7 = arrData.incData.IsCheckM7;
dataComplaintPrd.IsCheckM8 = arrData.incData.IsCheckM8;
dataComplaintPrd.IsCheckM9 = arrData.incData.IsCheckM9;
dataComplaintPrd.IsCheckM10 = arrData.incData.IsCheckM10;
dataComplaintPrd.IsCheckM11 = arrData.incData.IsCheckM11;
dataComplaintPrd.IsCheckM12 = arrData.incData.IsCheckM12;
List <string> lstForSum = new List <string> {
arrData.incData.M1, arrData.incData.M2, arrData.incData.M3, arrData.incData.M4, arrData.incData.M5,
arrData.incData.M6, arrData.incData.M7, arrData.incData.M8, arrData.incData.M9, arrData.incData.M10, arrData.incData.M11, arrData.incData.M12
};
dataComplaintPrd.nTotal = Sum(lstForSum);
db.TComplaint_Product.Add(dataComplaintPrd);
db.SaveChanges();
#endregion
#region TComplaint
int nComplaint = 1;
arrData.lstComplaint.ForEach(f =>
{
if (f.IsShow && f.IsSubmited)
{
TComplaint data = new TComplaint();
data.FormID = FORM_ID;
data.nComplaintID = nComplaint;
data.nComplaintTypeID = f.nComplaintTypeID;
data.ComplaintDate = DateTime.ParseExact(f.sIssueDate, "dd/MM/yyyy", null);
data.sIssueBy = f.sIssueBy;
data.sSubject = f.sSubject;
data.sDetail = f.sDetail;
data.sCorrectiveAction = f.sCorrectiveAction;
data.nComplaintByID = f.nComplaintByID;
data.sComplaintByOther = f.sComplaintByOther;
data.sStatus = f.sStatus;
data.nAddBy = UserAcc.GetObjUser().nUserID;
data.dAdd = DateTime.Now;
db.TComplaint.Add(data);
f.lstImpact.ForEach(f2 =>
{
TComplaint_Impact dataImpact = new TComplaint_Impact();
dataImpact.FormID = FORM_ID;
dataImpact.nComplaintID = nComplaint;
dataImpact.nImpactTypeID = f2.nImpactTypeID;
dataImpact.sOther = f2.sOther;
db.TComplaint_Impact.Add(dataImpact);
});
db.SaveChanges();
#region TComplaint_File
if (f.lstFile.Any())
{
string sPathSave = string.Format(sFolderInPathSave, FORM_ID);
SystemFunction.CreateDirectory(sPathSave);
//ลบไฟล์เดิมที่เคยมีและกดลบจากหน้าเว็บ
var qDelFile = f.lstFile.Where(w => w.IsNewFile == false && w.sDelete == "Y").ToList();
if (qDelFile.Any())
{
foreach (var qf in qDelFile)
{
var query = db.TComplaint_File.FirstOrDefault(w => w.FormID == FORM_ID && w.nComplaintID == f.nComplaintID && w.sSysFileName == qf.SaveToFileName);
if (query != null)
{
new SystemFunction().DeleteFileInServer(query.sPath, query.sSysFileName);
// new SystemFunction2().DeleteFileInServer(query.sSysPath, query.sSysFileName);
db.TComplaint_File.Remove(query);
///db.TAuditPlan_AttachFile.Remove(query);
}
}
db.SaveChanges();
}
//Update Description
f.lstFile.Where(w => w.IsNewFile == false && w.sDelete == "N").ToList().ForEach(f2U =>
{
var data2Update = db.TComplaint_File.FirstOrDefault(w => w.FormID == FORM_ID && w.nComplaintID == f.nComplaintID && w.nFileID == f2U.ID);
if (data2Update != null)
{
data2Update.sDescription = f2U.sDescription;
}
});
//Save New File Only
var lstSave = f.lstFile.Where(w => w.IsNewFile == true && w.sDelete == "N").ToList();
if (lstSave.Any())
{
int nFileID = db.TComplaint_File.Where(w => w.FormID == FORM_ID && w.nComplaintID == f.nComplaintID).Any() ? db.TComplaint_File.Where(w => w.FormID == FORM_ID && w.nComplaintID == f.nComplaintID).Max(m => m.nFileID) + 1 : 1;
foreach (var s in lstSave)
{
string sSystemFileName = FORM_ID + "_" + f.nComplaintID + "_" + nFileID + "-" + DateTime.Now.ToString("ddMMyyyyHHmmss") + "." + SystemFunction.GetFileNameFromFileupload(s.SaveToFileName, ""); //+ "." + SystemFunction.GetFileNameFromFileupload(s.SaveToFileName, "") SystemFunction2.GetFileType(item.SaveToFileName);
SystemFunction.UpFile2Server(s.SaveToPath, sPathSave, s.SaveToFileName, sSystemFileName);
// SystemFunction2.UpFile2Server(item.SaveToPath, sPathSave, item.SaveToFileName, sSystemFileName);
TComplaint_File t = new TComplaint_File();
t.FormID = FORM_ID;
t.nComplaintID = f.nComplaintID;
t.nFileID = nFileID;
t.sSysFileName = sSystemFileName;
t.sFileName = s.FileName;
t.sPath = sPathSave;
t.sDescription = s.sDescription;
db.TComplaint_File.Add(t);
nFileID++;
}
}
db.SaveChanges();
}
#endregion
nComplaint++;
}
});
#endregion
new EPIFunc().RecalculateComplaint(arrData.nOperationID, arrData.nFacilityID, arrData.sYear);
}
#endregion
if (arrData.nStatus != 27)
{
new Workflow().UpdateHistoryStatus(FORM_ID);
}
if (arrData.nStatus != 0 && arrData.nStatus != 9999)
{
string sMode = "";
switch (arrData.nStatus)
{
case 1:
sMode = "SM";
break;
case 2:
sMode = "RQ";
break;
case 24:
sMode = "RC";
break;
case 27:
sMode = "APC";
break;
}
result = new Workflow().WorkFlowAction(FORM_ID, arrData.lstMonthSubmit, sMode, UserAcc.GetObjUser().nUserID, UserAcc.GetObjUser().nRoleID, arrData.sRemarkRequestEdit);
}
else
{
if (arrData.nStatus != 0)
{
if (UserAcc.GetObjUser().nRoleID == 4)//ENVI Corporate (L2) >> Req.09.04.2019 Send email to L0 on L2 Modified data.
{
new Workflow().SendEmailToL0onL2EditData(arrData.sYear, arrData.nIndicatorID, arrData.nFacilityID, arrData.nOperationID);
}
}
result.Status = SystemFunction.process_Success;
}
}
else
{
result.Status = SystemFunction.process_SessionExpired;
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod SaveData(DataSave itemSave)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
if (UserAcc.UserExpired())
{
result.Status = SystemFunction.process_SessionExpired;
}
else
{
Func <string, int?, bool> CheckDuplicateName = (name, id) =>
{
bool Isdup = false;
var q = db.mOperationType.Where(w => (id.HasValue ? w.ID != id : true) && w.Name == name);
Isdup = q.Any();
return(Isdup);
};
string sOperationID = itemSave.sID.STCDecrypt();
if (!string.IsNullOrEmpty(sOperationID))
{
int nOperationID = sOperationID.toIntNullToZero();
if (!CheckDuplicateName(itemSave.sOperationName, nOperationID))
{
var query = db.mOperationType.FirstOrDefault(f => f.ID == nOperationID);
if (query != null)
{
query.Name = itemSave.sOperationName.Trims();
query.Description = itemSave.sDesc;
query.cActive = itemSave.sStatus;
query.nUpdateID = UserAcc.GetObjUser().nUserID;
query.dUpdate = DateTime.Now;
if (itemSave.sStatus == "N")
{
query.sRemark = itemSave.sRemark.Trims();
}
else
{
query.sRemark = "";
}
db.SaveChanges();
result.Status = SystemFunction.process_Success;
}
else
{
result.Status = SystemFunction.process_Failed;
result.Msg = "Not found data !";
}
}
else
{
result.Msg = "Duplicate Operation name !";
result.Status = SystemFunction.process_Failed;
}
}
else
{
if (!CheckDuplicateName(itemSave.sOperationName, null))
{
int nID = db.mOperationType.Any() ? db.mOperationType.Max(m => m.ID) + 1 : 1;
mOperationType t = new mOperationType();
t.ID = nID;
t.Name = itemSave.sOperationName.Trims();
t.Description = itemSave.sDesc;
t.cActive = itemSave.sStatus;
if (itemSave.sStatus == "N")
{
t.sRemark = itemSave.sRemark.Trims();
}
t.nCreateID = UserAcc.GetObjUser().nUserID;
t.dCreate = DateTime.Now;
t.nUpdateID = UserAcc.GetObjUser().nUserID;
t.dUpdate = DateTime.Now;
t.cDel = "N";
t.cManage = "Y";
db.mOperationType.Add(t);
db.SaveChanges();
result.Status = SystemFunction.process_Success;
}
else
{
result.Msg = "Duplicate Operation name !";
result.Status = SystemFunction.process_Failed;
}
}
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod saveToDB(DataValue dataValue)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
if (!UserAcc.UserExpired())
{
dataValue.sComID = STCrypt.Decrypt(dataValue.sComID);
dataValue.sFacilityID = !string.IsNullOrEmpty(dataValue.sFacilityID) ? STCrypt.Decrypt(dataValue.sFacilityID) : "";
Func <string, int, int?, int, bool> CheckDuplicateName = (name, comID, facID, nLevel) =>
{
bool Isdup = false;
var q = db.mTFacility.Where(w => w.CompanyID == comID && w.nLevel == nLevel && (facID.HasValue ? w.ID != facID : true) && w.Name == name && w.cDel == "N");
Isdup = q.Any();
return(Isdup);
};
#region Add / Update
if (CheckDuplicateName(dataValue.sFacilityName, SystemFunction.GetIntNullToZero(dataValue.sComID), dataValue.IsNew ? (int?)null : SystemFunction.GetIntNullToZero(dataValue.sFacilityID), (dataValue.sComType == "GC" ? 1 : 0)))
{
result.Status = SystemFunction.process_Failed;
result.Msg = "Duplicate Facility name";
return(result);
}
int nFacility_PTT = SystemFunction.GetIntNullToZero(dataValue.sFacilityPTT_ID);
int nFacilityID = SystemFunction.GetIntNullToZero(dataValue.sFacilityID);
if (dataValue.sComType == "GC" && nFacility_PTT != 0)
{
var query = db.mTFacility.Where(w => w.cDel == "N" && w.nLevel == 1 && w.nHeaderID == nFacility_PTT && w.ID != nFacilityID);
if (query.Any())
{
result.Status = SystemFunction.process_Failed;
result.Msg = "Cannot reference PTT facility, because exist used.";
return(result);
}
}
int nComID = SystemFunction.GetIntNullToZero(dataValue.sComID);
var itemFacility = db.mTFacility.FirstOrDefault(w => w.ID == nFacilityID && w.CompanyID == nComID);
int nMaxID = db.mTFacility.Any() ? db.mTFacility.Max(m => m.ID) + 1 : 1;
if (dataValue.IsNew)
{
itemFacility = new mTFacility();
itemFacility.ID = nMaxID;
itemFacility.cDel = "N";
itemFacility.CreateID = UserAcc.GetObjUser().nUserID;
itemFacility.dCreate = DateTime.Now;
}
itemFacility.sMappingCodePTT = (dataValue.sMapPTTCode + "").Trim();
itemFacility.Name = dataValue.sFacilityName;
itemFacility.nLevel = dataValue.sComType == "GC" ? 1 : 0;
itemFacility.nHeaderID = dataValue.sComType == "GC" ? (nFacility_PTT == 0 ? (int?)null : nFacility_PTT) : (int?)null;
itemFacility.sRelation = dataValue.sComType == "GC" ? (nFacility_PTT == 0 ? itemFacility.ID + "" : nFacility_PTT + "-" + itemFacility.ID) : itemFacility.ID + "";
//itemFacility.sRelation = dataValue.sComType == "GC" ? nFacility_PTT + "-" + itemFacility.ID : itemFacility.ID + "";
itemFacility.OperationTypeID = SystemFunction.GetIntNullToZero(dataValue.sOperationTypePTT_ID);
itemFacility.CompanyID = SystemFunction.GetIntNullToZero(dataValue.sComID);
itemFacility.Description = dataValue.sDescription;
itemFacility.cActive = dataValue.sActive;
itemFacility.sRemark = dataValue.sActive == "Y" ? null : dataValue.sRemark;
itemFacility.UpdateID = dataValue.IsNew ? (int?)null : UserAcc.GetObjUser().nUserID;
itemFacility.dUpdate = DateTime.Now;
if (dataValue.IsNew)
{
db.mTFacility.Add(itemFacility);
}
if (dataValue.sComType == "GC")
{
//db.mTFacility_Operationtype.RemoveRange(db.mTFacility_Operationtype.Where(w => w.nFacID == itemFacility.ID));
//foreach (var item in dataValue.lstOperationTypeGC_ID)
//{
// mTFacility_Operationtype oprt = new mTFacility_Operationtype();
// oprt.nFacID = itemFacility.ID;
// oprt.nOperationtypeID = SystemFunction.GetIntNullToZero(item);
// db.mTFacility_Operationtype.Add(oprt);
//}
}
else
{
if (!dataValue.IsNew)
{
db.mTFacility.Where(w => w.nHeaderID == itemFacility.ID && w.cDel == "N").ToList().ForEach(f =>
{
f.OperationTypeID = itemFacility.OperationTypeID;
});
}
}
db.SaveChanges();
result.Status = SystemFunction.process_Success;
#endregion
}
else
{
result.Status = SystemFunction.process_SessionExpired;
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod SaveData(CSaveData data)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
if (UserAcc.UserExpired())
{
result.Status = SystemFunction.process_SessionExpired;
}
else
{
Func <string, int?, bool> CheckDuplicateName = (name, id) =>
{
bool Isdup = false;
var q = db.mTUser.Where(w => (id.HasValue ? w.ID != id : true) && w.Username == name);
Isdup = q.Any();
return(Isdup);
};
if (!string.IsNullOrEmpty(data.sUserID))
{
int nUserID = data.sUserID.toIntNullToZero();
var query = db.mTUser.FirstOrDefault(w => w.ID == nUserID);
if (query != null)
{
if (query.cUserType == "0") //Employee_GC
{
if (!CheckDuplicateName(data.sUserCode, nUserID))
{
query.Firstname = data.sName.Trim();
query.Email = data.sEmail.Trim();
query.Company = data.sOrg.Trim();
//query.sUserCode = data.sUserCode.Trim();
//query.Username = data.sUserCode.Trim();
}
else
{
result.Msg = "Duplicate Employee Code !";
result.Status = SystemFunction.process_Failed;
return(result);
}
}
else //Employee_Other
{
if (!CheckDuplicateName(data.sUsername, nUserID))
{
query.Username = data.sUsername.Trim();
query.Email = data.sEmail.Trim();
query.Company = data.sOrg.Trim();
query.Firstname = data.sName.Trim();
query.Lastname = data.sSurName.Trim();
if (!string.IsNullOrEmpty(data.sPassword))
{
query.Password = STCrypt.encryptMD5(data.sPassword.Trim());
query.PasswordEncrypt = STCrypt.Encrypt(data.sPassword.Trim());
}
}
else
{
result.Msg = "Duplicate Username !";
result.Status = SystemFunction.process_Failed;
return(result);
}
}
query.nUpdateID = UserAcc.GetObjUser().nUserID;
query.dUpdate = DateTime.Now;
db.SaveChanges();
result.Status = SystemFunction.process_Success;
}
}
else
{
result.Status = SystemFunction.process_Failed;
result.Msg = "Not found data !";
return(result);
}
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod SaveToDB(string sDesc, string sID, List <dataFileContactUs> objFile)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
DateTime now = DateTime.Now;
if (UserAcc.UserExpired())
{
result.Status = SystemFunction.process_SessionExpired;
}
else
{
try
{
UserAcc ua = UserAcc.GetObjUser();
if (!string.IsNullOrEmpty(sID))
{
string sPathSend = "";
int nID = int.Parse(STCrypt.Decrypt(sID));
var Query = db.TContactUs.FirstOrDefault(w => w.cDel == "N" && w.nContactID == nID);
if (Query != null)
{
Query.sAnswer = sDesc;
Query.cStatusAns = "2";
Query.dAnswer = now;
Query.dUpdate = now;
Query.nAnswerBy = UserAcc.GetObjUser().nUserID;
if (objFile.Count > 0 && objFile != null)
{
string sPathSave = string.Format(sFolderInPathSave, nID);
SystemFunction.CreateDirectory(sPathSave);
//string sPathSave = string.Format(sFolderInPathSave, nID);
//SystemFunction.CreateDirectory(sPathSave);
var f = objFile.First();
string sSystemFileName = nID + "_" + "-" + DateTime.Now.ToString("ddMMyyyyHHmmss") + "." + SystemFunction.GetFileNameFromFileupload(f.sFileName, ""); //SystemFunction2.GetFileType(item.SaveToFileName);
SystemFunction.UpFile2Server(f.sPath, sPathSave, f.sSysFileName, sSystemFileName);
Query.sAnsFile = f.sFileName;
Query.sAnsSysFile = sSystemFileName;
Query.sAnsPath = sPathSave;
sPathSend = HttpContext.Current.Server.MapPath("./") + sPathSave + sSystemFileName;
}
var Ispass = db.SaveChanges() > 0;
if (Ispass)
{
string To = Query.sContactEmail; // Contact Mail
string AdminContactmail = WebConfigurationManager.AppSettings["ContactMail"] + ""; // Mail Admin
//string To1 = "*****@*****.**";
string sSubject = SystemFunction.sAbbrSystem + " : Contact Us." + Query.sSubject;
string sGurl = SystemFunction.RequestUrl() + WebConfigurationManager.AppSettings["DefaultPage"] + "";
string sHtml = @"
<table align='left' border='0' cellspacing='2' cellpadding='3'>
<tr>
<td align='left'>Dear: " + Query.sContactName + @"</td>
</tr>
<tr>
<td align='left'>Subject: " + Query.sSubject + @"</td>
</tr>
<tr>
<td align='left'>Description: " + Query.sDetail + @"</td>
</tr>
<tr>
<td align='left'>Answer: " + Query.sAnswer + @"</td>
</tr>
</table>";
Workflow.DataMail_log log = new Workflow.DataMail_log();
string ccMail = "";
var lstUser = db.mTUser.FirstOrDefault(w => w.ID == ua.nUserID);
if (lstUser != null)
{
ccMail = lstUser.Email;
}
log = SystemFunction.SendMailAll(AdminContactmail, To, ccMail, "", sSubject, sHtml, sPathSend != "" ? sPathSend.Replace("/", "\\") : "");
log.nDataID = SystemFunction.GetIntNullToZero(nID + "");
log.sPageName = "admin_ContactUs_update.aspx";
new Workflow().SaveLogMail(log);
if (log.bStatus)
{
result.Status = SystemFunction.process_Success;
}
}
}
}
}
catch (Exception e)
{
result.Msg = e.Message;
result.Status = SystemFunction.process_Failed;
}
result.Status = SystemFunction.process_Success;
}
return(result);
}
public static sysGlobalClass.CResutlWebMethod saveToDB(DataValue dataValue)
{
sysGlobalClass.CResutlWebMethod result = new sysGlobalClass.CResutlWebMethod();
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
if (!UserAcc.UserExpired())
{
dataValue.sFacilityID = STCrypt.Decrypt(dataValue.sFacilityID);
dataValue.sAssetID = !string.IsNullOrEmpty(dataValue.sAssetID) ? STCrypt.Decrypt(dataValue.sAssetID) : "";
Func <string, int?, bool> CheckDuplicateName = (name, AssetID) =>
{
bool Isdup = false;
var q = db.mTFacility.Where(w => (AssetID.HasValue ? w.ID != AssetID : true) && w.nLevel == 2 && w.Name.Trim().ToLower() == name.Trim().ToLower() && w.cDel == "N");
Isdup = q.Any();
return(Isdup);
};
Func <string, int?, bool> CheckDuplicateNameSAP = (name, AssetID) =>
{
bool Isdup = false;
var q = db.mTFacility.Where(w => (AssetID.HasValue ? w.ID != AssetID : true) && w.nLevel == 2 && w.sSAPName.Trim().ToLower() == name.Trim().ToLower() && w.cDel == "N");
Isdup = q.Any();
return(Isdup);
};
Func <string, int?, bool> CheckDuplicateCodeSAP = (code, AssetID) =>
{
bool Isdup = false;
var q = db.mTFacility.Where(w => (AssetID.HasValue ? w.ID != AssetID : true) && w.nLevel == 2 && w.sRefFacCode.Trim().ToLower() == code.Trim().ToLower() && w.cDel == "N");
Isdup = q.Any();
return(Isdup);
};
#region Add / Update
if (dataValue.sRefFacType == "N" && CheckDuplicateName(dataValue.sAssetName, dataValue.IsNew ? (int?)null : SystemFunction.GetIntNullToZero(dataValue.sAssetID)))
{
result.Status = SystemFunction.process_Failed;
result.Msg = "Already Sub-facility Name !";
return(result);
}
if (dataValue.sRefFacType == "P" && !string.IsNullOrEmpty(dataValue.sRefFacCode))
{
if (CheckDuplicateCodeSAP(dataValue.sRefFacCode, dataValue.IsNew ? (int?)null : SystemFunction.GetIntNullToZero(dataValue.sAssetID)))
{
result.Status = SystemFunction.process_Failed;
result.Msg = "Already SAP Code !";
return(result);
}
}
bool IsPass = true;
int sAssetID = SystemFunction.GetIntNullToZero(dataValue.sAssetID);
int nFacilityID = SystemFunction.GetIntNullToZero(dataValue.sFacilityID);
var itemAsset = db.mTFacility.FirstOrDefault(w => w.ID == sAssetID);
var itemFacility = db.mTFacility.FirstOrDefault(w => w.ID == nFacilityID);
int nMaxID = db.mTFacility.Any() ? db.mTFacility.Max(m => m.ID) + 1 : 1;
if (dataValue.IsNew)
{
itemAsset = new mTFacility();
itemAsset.ID = nMaxID;
itemAsset.cDel = "N";
itemAsset.CreateID = UserAcc.GetObjUser().nUserID;
itemAsset.dCreate = DateTime.Now;
}
if (dataValue.sRefFacType == "P")
{
#region SAP Master
var dataComp = db.mTCompany.FirstOrDefault(w => w.ID == itemFacility.CompanyID);
if (dataComp != null)
{
var qSAPFac = db.v_TM_SAP_ALLFAC.FirstOrDefault(w => w.sCode == dataValue.sRefFacCode && w.sCompCode == dataComp.sCode);
if (qSAPFac != null)
{
itemAsset.sRefFacCode = dataValue.sRefFacCode;
itemAsset.Name = qSAPFac.sName.Trims();
itemAsset.sRefFacSubType = qSAPFac.sType;
itemAsset.sInternalCode = "";
}
else
{
IsPass = false;
result.Status = SystemFunction.process_Failed;
result.Msg = "Not found SAP master data !";
}
}
else
{
IsPass = false;
result.Status = SystemFunction.process_Failed;
result.Msg = "Not found company data !";
}
#endregion
}
else
{
#region Manual Create
var dataComp = db.mTCompany.FirstOrDefault(w => w.ID == itemFacility.CompanyID);
if (dataComp != null)
{
if (!string.IsNullOrEmpty(dataValue.sRefFacCode))//มีการอัพเดท SAP Code หลังจากที่ manual create
{
var qSAPFac = db.v_TM_SAP_ALLFAC.FirstOrDefault(w => w.sCode == dataValue.sRefFacCode && w.sCompCode == dataComp.sCode);
if (qSAPFac != null)
{
itemAsset.sRefFacCode = dataValue.sRefFacCode;
itemAsset.Name = qSAPFac.sName.Trims();
}
else
{
IsPass = false;
result.Status = SystemFunction.process_Failed;
result.Msg = "Not found SAP master data !";
}
}
else
{
itemAsset.Name = dataValue.sAssetName;
itemAsset.sRefFacCode = "";
}
itemAsset.sRefFacSubType = dataValue.sRefFacSubType;
if (dataValue.IsNew || string.IsNullOrEmpty(itemAsset.sInternalCode))
{
string sType = dataValue.sRefFacSubType == "O" ? "Z" : dataValue.sRefFacSubType;
char cType = '-';
switch (sType)
{
case "O": cType = 'Z'; break;
case "S": cType = 'S'; break;
case "P": cType = 'P'; break;
}
Func <string, int> GetNumber = (code) =>
{
string[] arr = code.Split(cType);
return((arr[arr.Length - 1]).toIntNullToZero());
};
var qFacInternalCode = db.mTFacility.Where(w => w.cDel == "N" && w.CompanyID == itemFacility.CompanyID && w.sInternalCode.Contains(sType)).AsEnumerable().Select(s => new
{
nNumber = GetNumber(s.sInternalCode)
}).ToList();
int nNumber = qFacInternalCode.Any() ? qFacInternalCode.Max(x => x.nNumber) + 1 : 1;
itemAsset.sInternalCode = dataComp.sCode + sType + nNumber; //EX. 10Z1
}
}
else
{
IsPass = false;
result.Status = SystemFunction.process_Failed;
result.Msg = "Not found company data !";
}
#endregion
}
if (IsPass)
{
itemAsset.sRefFacType = dataValue.sRefFacType;
itemAsset.nLevel = 2;
itemAsset.nHeaderID = itemFacility.ID;
itemAsset.sRelation = itemFacility.sRelation + "-" + itemAsset.ID;
itemAsset.OperationTypeID = itemFacility.OperationTypeID;
itemAsset.CompanyID = itemFacility.CompanyID;
itemAsset.Description = dataValue.sDescription;
itemAsset.cActive = dataValue.sActive;
itemAsset.sRemark = dataValue.sActive == "Y" ? null : dataValue.sRemark;
itemAsset.UpdateID = dataValue.IsNew ? (int?)null : UserAcc.GetObjUser().nUserID;
itemAsset.dUpdate = DateTime.Now;
if (dataValue.IsNew)
{
db.mTFacility.Add(itemAsset);
}
db.SaveChanges();
result.Status = SystemFunction.process_Success;
}
#endregion
}
else
{
result.Status = SystemFunction.process_SessionExpired;
}
return(result);
}
