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 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
{
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);
}
