public object[] queryDataMstCarRegistertionByCarRegistertionId(MST_CAR_REGISTERTION param)
{
log.Info("Start log INFO... queryDataMstCarRegistertionBycarRegistertionId");
MsgForm msgError = new MsgForm();
MST_CAR_REGISTERTION form = new MST_CAR_REGISTERTION();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.MST_CAR_REGISTERTION where row.CAR_REGISTERTION_ID == param.CAR_REGISTERTION_ID select row).FirstOrDefault();
db.Dispose();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... queryDataMstCarRegistertionBycarRegistertionId");
}
return(new object[] { msgError, form });
}
public object[] updateDataMstCarRegistertion(MST_CAR_REGISTERTION param)
{
log.Info("Start log INFO... updateDataMstCarRegistertion");
MsgForm msgError = new MsgForm();
MST_CAR_REGISTERTION form = new MST_CAR_REGISTERTION();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.MST_CAR_REGISTERTION where row.CAR_REGISTERTION_ID == param.CAR_REGISTERTION_ID select row).FirstOrDefault();
if (Util.isNotEmpty(form))
{
form.CAR_REGISTERTION_NAME = param.CAR_REGISTERTION_NAME;
form.CAR_REGISTERTION_VENDOR_ID = param.CAR_REGISTERTION_VENDOR_ID;
}
db.SaveChanges();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... updateDataMstCarRegistertion");
}
return(new object[] { msgError });
}
public object[] queryComboMstAmphures(MST_AMPHURES param)
{
log.Info("Start log INFO... queryComboMstAmphures");
MsgForm msgError = new MsgForm();
List <MST_AMPHURES> resultList = new List <MST_AMPHURES>();
try
{
using (var db = new PaknampoScaleDBEntities())
{
resultList = (from row in db.MST_AMPHURES where row.PROVINCE_ID == param.PROVINCE_ID select row).ToList();
db.Dispose();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... queryComboMstAmphures");
}
return(new object[] { msgError, resultList });
}
public object[] queryDataStsSerialPort(STS_SERIAL_PORT param)
{
log.Info("Start log INFO... queryDataStsSerialPort");
MsgForm msgError = new MsgForm();
STS_SERIAL_PORT form = new STS_SERIAL_PORT();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.STS_SERIAL_PORT where row.SERIAL_PORT_ID == param.SERIAL_PORT_ID select row).FirstOrDefault();
db.Dispose();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... queryDataStsSerialPort");
}
return(new object[] { msgError, form });
}
public object[] checkStatusLogin()
{
log.Info("Start log INFO... checkStatusLogin");
MsgForm msgError = new MsgForm();
LOGIN_STATUS result = new LOGIN_STATUS();
try
{
using (var db = new PaknampoScaleDBEntities())
{
result = (from row in db.LOGIN_STATUS where row.LOGIN_STATUS_ID == 1 select row).FirstOrDefault();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... checkStatusLogin");
}
return(new object[] { msgError, result });
}
public object[] deleteDataMstProduct(MST_PRODUCT param)
{
log.Info("Start log INFO... deleteDataMstProduct");
MsgForm msgError = new MsgForm();
MST_PRODUCT form = new MST_PRODUCT();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.MST_PRODUCT where row.PRODUCT_ID == param.PRODUCT_ID select row).FirstOrDefault();
if (Util.isNotEmpty(form))
{
db.MST_PRODUCT.Remove(form);
}
db.SaveChanges();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... deleteDataMstProduct");
}
return(new object[] { msgError });
}
public object[] queryDataManageUserLoginByUserId(USER_LOGIN param)
{
log.Info("Start log INFO... queryDataManageUserLoginByUserId");
MsgForm msgError = new MsgForm();
USER_LOGIN form = new USER_LOGIN();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.USER_LOGIN where row.USER_ID == param.USER_ID select row).FirstOrDefault();
db.Dispose();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... queryDataManageUserLoginByUserId");
}
return(new object[] { msgError, form });
}
public object[] queryLstDataMstCustomerService(MST_CUSTOMER_SERVICE param)
{
log.Info("Start log INFO... queryLstDataMstCustomerService");
MsgForm msgError = new MsgForm();
List <MST_CUSTOMER_SERVICE> resultList = new List <MST_CUSTOMER_SERVICE>();
try
{
using (var db = new PaknampoScaleDBEntities())
{
resultList = (from row in db.MST_CUSTOMER_SERVICE where row.CUSTOMER_ID == param.CUSTOMER_ID select row).ToList();
db.Dispose();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... queryLstDataMstCustomerService");
}
return(new object[] { msgError, resultList });
}
public object[] queryDataMstBusiness(MST_BUSINESS param)
{
log.Info("Start log INFO... queryDataMstBusiness");
MsgForm msgError = new MsgForm();
MST_BUSINESS form = new MST_BUSINESS();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.MST_BUSINESS where row.BUSINESS_ID == param.BUSINESS_ID select row).FirstOrDefault();
db.Dispose();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... queryDataMstBusiness");
}
return(new object[] { msgError, form });
}
public object[] searchDataVwMstProduct()
{
log.Info("Start log INFO... searchDataVwMstProduct");
MsgForm msgError = new MsgForm();
List <VW_MST_PRODUCT> resultList = new List <VW_MST_PRODUCT>();
try
{
using (var db = new PaknampoScaleDBEntities())
{
resultList = (from row in db.VW_MST_PRODUCT select row).ToList();
db.Dispose();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... searchDataVwMstProduct");
}
return(new object[] { msgError, resultList });
}
public object[] insertOrUpdateDataMstCarRegistertion(MST_CAR_REGISTERTION param, string flagAddEdit)
{
log.Info("Start log INFO... insertOrUpdateDataMstCarRegistertion");
MsgForm msgError = new MsgForm();
MST_CAR_REGISTERTION formInsert = new MST_CAR_REGISTERTION();
MST_CAR_REGISTERTION formUpdate = new MST_CAR_REGISTERTION();
try
{
using (var db = new PaknampoScaleDBEntities())
{
formUpdate = (from row in db.MST_CAR_REGISTERTION where row.CAR_REGISTERTION_ID == param.CAR_REGISTERTION_ID select row).FirstOrDefault();
if (flagAddEdit.Equals("A"))
{
if (Util.isEmpty(formUpdate))
{
formInsert.CAR_REGISTERTION_ID = param.CAR_REGISTERTION_ID;
formInsert.CAR_REGISTERTION_NAME = param.CAR_REGISTERTION_NAME;
formInsert.CAR_REGISTERTION_VENDOR_ID = param.CAR_REGISTERTION_VENDOR_ID;
db.MST_CAR_REGISTERTION.Add(formInsert);
log.Info("Insert Data form MST_CAR_REGISTERTION"
+ " CAR_REGISTERTION_ID : " + formInsert.CAR_REGISTERTION_ID
+ " CAR_REGISTERTION_NAME : " + formInsert.CAR_REGISTERTION_NAME
+ " CAR_REGISTERTION_VENDOR_ID : " + formInsert.CAR_REGISTERTION_VENDOR_ID
);
}
}
else if (flagAddEdit.Equals("E"))
{
if (Util.isNotEmpty(formUpdate))
{
formUpdate.CAR_REGISTERTION_ID = param.CAR_REGISTERTION_ID;
formUpdate.CAR_REGISTERTION_NAME = param.CAR_REGISTERTION_NAME;
formUpdate.CAR_REGISTERTION_VENDOR_ID = param.CAR_REGISTERTION_VENDOR_ID;
log.Info("Update Data form MST_CAR_REGISTERTION"
+ " CAR_REGISTERTION_ID : " + formUpdate.CAR_REGISTERTION_ID
+ " CAR_REGISTERTION_NAME : " + formUpdate.CAR_REGISTERTION_NAME
+ " CAR_REGISTERTION_VENDOR_ID : " + formUpdate.CAR_REGISTERTION_VENDOR_ID
);
}
}
db.SaveChanges();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... insertOrUpdateDataMstCarRegistertion");
}
return(new object[] { msgError, formUpdate });
}
public object[] updateDataMstDataBasic(MST_DATA_BASIC param)
{
log.Info("Start log INFO... updateDataMstDataBasic");
MsgForm msgError = new MsgForm();
MST_DATA_BASIC form = new MST_DATA_BASIC();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.MST_DATA_BASIC where row.BASIC_ID == param.BASIC_ID select row).FirstOrDefault();
if (Util.isNotEmpty(form))
{
form.BASIC_CARD_NO = param.BASIC_CARD_NO;
form.BASIC_CARD_NO_SCOOP = param.BASIC_CARD_NO_SCOOP;
form.BASIC_RECEIPT_NO = param.BASIC_RECEIPT_NO;
form.BASIC_DECIMAL = param.BASIC_DECIMAL;
form.BASIC_MOVE_NO = param.BASIC_MOVE_NO;
form.BASIC_DEDUCTION = param.BASIC_DEDUCTION;
form.BASIC_FARE = param.BASIC_FARE;
form.BASIC_STATUS_PRINT_CARD_NO = param.BASIC_STATUS_PRINT_CARD_NO;
form.BASIC_STATUS_PRINT_CARD_SEND = param.BASIC_STATUS_PRINT_CARD_SEND;
form.BASIC_STATIS_SHOW_CARD_FARE = param.BASIC_STATIS_SHOW_CARD_FARE;
form.BASIC_STATUS_PRINT_OUTLOOK_VENDOR = param.BASIC_STATUS_PRINT_OUTLOOK_VENDOR;
log.Info("Update Data form MST_DATA_BASIC WHERE " + form.BASIC_ID
+ " BASIC_CARD_NO : " + form.BASIC_CARD_NO
+ " BASIC_CARD_NO_SCOOP : " + form.BASIC_CARD_NO_SCOOP
+ " BASIC_RECEIPT_NO : " + form.BASIC_RECEIPT_NO
+ " BASIC_DECIMAL : " + form.BASIC_DECIMAL
+ " BASIC_MOVE_NO : " + form.BASIC_MOVE_NO
+ " BASIC_DEDUCTION : " + form.BASIC_DEDUCTION
+ " BASIC_FARE : " + form.BASIC_FARE
+ " BASIC_STATUS_PRINT_CARD_NO : " + form.BASIC_STATUS_PRINT_CARD_NO
+ " BASIC_STATUS_PRINT_CARD_SEND : " + form.BASIC_STATUS_PRINT_CARD_SEND
+ " BASIC_STATIS_SHOW_CARD_FARE : " + form.BASIC_STATIS_SHOW_CARD_FARE
+ " BASIC_STATUS_PRINT_OUTLOOK_VENDOR : " + form.BASIC_STATUS_PRINT_OUTLOOK_VENDOR
);
}
db.SaveChanges();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... updateDataMstDataBasic");
}
return(new object[] { msgError });
}
public object[] insertOrUpdateDataMstProductUnit(MST_PRODUCT_UNIT param, string flagAddEdit)
{
log.Info("Start log INFO... insertOrUpdateDataMstProductUnit");
MsgForm msgError = new MsgForm();
MST_PRODUCT_UNIT formInsert = new MST_PRODUCT_UNIT();
MST_PRODUCT_UNIT formUpdate = new MST_PRODUCT_UNIT();
try
{
using (var db = new PaknampoScaleDBEntities())
{
formUpdate = (from row in db.MST_PRODUCT_UNIT where row.PRODUCT_UNIT_ID == param.PRODUCT_UNIT_ID select row).FirstOrDefault();
if (flagAddEdit.Equals("A"))
{
if (Util.isEmpty(formUpdate))
{
formInsert.PRODUCT_UNIT_ID = param.PRODUCT_UNIT_ID;
formInsert.PRODUCT_UNIT_NAME = param.PRODUCT_UNIT_NAME;
db.MST_PRODUCT_UNIT.Add(formInsert);
log.Info("Insert Data form MST_PRODUCT_UNIT"
+ " PRODUCT_UNIT_ID : " + formInsert.PRODUCT_UNIT_ID
+ " PRODUCT_UNIT_NAME : " + formInsert.PRODUCT_UNIT_NAME
);
}
}
else if (flagAddEdit.Equals("E"))
{
if (Util.isNotEmpty(formUpdate))
{
formUpdate.PRODUCT_UNIT_ID = param.PRODUCT_UNIT_ID;
formUpdate.PRODUCT_UNIT_NAME = param.PRODUCT_UNIT_NAME;
log.Info("Update Data form MST_PRODUCT_UNIT"
+ " PRODUCT_UNIT_ID : " + formUpdate.PRODUCT_UNIT_ID
+ " PRODUCT_UNIT_NAME : " + formUpdate.PRODUCT_UNIT_NAME
);
}
}
db.SaveChanges();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... insertOrUpdateDataMstProductUnit");
}
return(new object[] { msgError, formUpdate });
}
public object[] updateDataMstBusiness(MST_BUSINESS param)
{
log.Info("Start log INFO... updateDataMstBusiness");
MsgForm msgError = new MsgForm();
MST_BUSINESS form = new MST_BUSINESS();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.MST_BUSINESS where row.BUSINESS_ID == param.BUSINESS_ID select row).FirstOrDefault();
if (Util.isNotEmpty(form))
{
form.BUSINESS_NAME = param.BUSINESS_NAME;
form.BUSINESS_ADDRESS = param.BUSINESS_ADDRESS;
form.BUSINESS_DISTRICT = param.BUSINESS_DISTRICT;
form.BUSINESS_AMPHURE = param.BUSINESS_AMPHURE;
form.BUSINESS_PROVINCE = param.BUSINESS_PROVINCE;
form.BUSINESS_POSTCODE = param.BUSINESS_POSTCODE;
form.BUSINESS_TEL_NO = param.BUSINESS_TEL_NO;
form.BUSINESS_FAX = param.BUSINESS_FAX;
log.Info("Update Data form MST_BUSINESS WHERE " + form.BUSINESS_ID
+ " BUSINESS_NAME : " + form.BUSINESS_NAME
+ " BUSINESS_ADDRESS : " + form.BUSINESS_ADDRESS
+ " BUSINESS_DISTRICT : " + form.BUSINESS_DISTRICT
+ " BUSINESS_AMPHURE : " + form.BUSINESS_AMPHURE
+ " BUSINESS_PROVINCE : " + form.BUSINESS_PROVINCE
+ " BUSINESS_POSTCODE : " + form.BUSINESS_POSTCODE
+ " BUSINESS_TEL_NO : " + form.BUSINESS_TEL_NO
+ " BUSINESS_FAX : " + form.BUSINESS_FAX
);
}
db.SaveChanges();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... updateDataMstBusiness");
}
return(new object[] { msgError });
}
public object[] updateDataRegister(REGISTER param)
{
log.Info("Start log INFO... updateDataRegister");
MsgForm msgError = new MsgForm();
REGISTER form = new REGISTER();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.REGISTERs where row.REGISTER_ID == param.REGISTER_ID select row).FirstOrDefault();
if (Util.isNotEmpty(form))
{
form.REGISTER_MODEL = Util.toString(CryptoUtil.encrypt(param.REGISTER_MODEL));
form.REGISTER_TYPE = Util.toString(CryptoUtil.encrypt(param.REGISTER_TYPE));
form.REGISTER_SERIAL_NO = Util.toString(CryptoUtil.encrypt(param.REGISTER_SERIAL_NO));
form.REGISTER_DEVICE_ID = Util.toString(CryptoUtil.encrypt(param.REGISTER_DEVICE_ID));
form.REGISTER_PASSWORD_HASH = param.REGISTER_PASSWORD_HASH;
form.REGISTER_CODE = Util.toString(CryptoUtil.encrypt(param.REGISTER_CODE));
//form.CREATE_DATE = param.CREATE_DATE;
//form.UPDATE_DATE = new DateTime();
//log.Info("Update Data form REGISTER WHERE " + form.REGISTER_ID
// + " REGISTER_MODEL : " + form.REGISTER_MODEL
// + " REGISTER_TYPE : " + form.REGISTER_TYPE
// + " REGISTER_SERIAL_NO : " + form.REGISTER_SERIAL_NO
// + " REGISTER_DEVICE_ID : " + form.REGISTER_DEVICE_ID
// + " REGISTER_PASSWORD_HASH : " + form.REGISTER_PASSWORD_HASH
// + " REGISTER_CODE : " + form.REGISTER_CODE
// + " CREATE_DATE : " + form.CREATE_DATE
// + " UPDATE_DATE : " + form.UPDATE_DATE
// );
}
db.SaveChanges();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... updateDataRegister");
}
return(new object[] { msgError });
}
public object[] updateDataStsSerialPort(STS_SERIAL_PORT param)
{
log.Info("Start log INFO... updateDataStsSerialPort");
MsgForm msgError = new MsgForm();
STS_SERIAL_PORT form = new STS_SERIAL_PORT();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.STS_SERIAL_PORT where row.SERIAL_PORT_ID == param.SERIAL_PORT_ID select row).FirstOrDefault();
if (Util.isNotEmpty(form))
{
form.SERIAL_PORT_PORT_NO = param.SERIAL_PORT_PORT_NO;
form.SERIAL_PORT_BAUD_RATE = param.SERIAL_PORT_BAUD_RATE;
form.SERIAL_PORT_DATA_BITS = param.SERIAL_PORT_DATA_BITS;
form.SERIAL_PORT_STOP_BITS = param.SERIAL_PORT_STOP_BITS;
form.SERIAL_PORT_PARITY = param.SERIAL_PORT_PARITY;
form.SERIAL_PORT_HAND_SHAKING = param.SERIAL_PORT_HAND_SHAKING;
form.SERIAL_PORT_STATUS_FLAG = param.SERIAL_PORT_STATUS_FLAG;
log.Info("Update Data form STS_SERIAL_PORT WHERE " + form.SERIAL_PORT_ID
+ " SERIAL_PORT_PORT_NO : " + form.SERIAL_PORT_PORT_NO
+ " SERIAL_PORT_BAUD_RATE : " + form.SERIAL_PORT_BAUD_RATE
+ " SERIAL_PORT_DATA_BITS : " + form.SERIAL_PORT_DATA_BITS
+ " SERIAL_PORT_STOP_BITS : " + form.SERIAL_PORT_STOP_BITS
+ " SERIAL_PORT_PARITY : " + form.SERIAL_PORT_PARITY
+ " SERIAL_PORT_HAND_SHAKING : " + form.SERIAL_PORT_HAND_SHAKING
+ " SERIAL_PORT_STATUS_FLAG : " + form.SERIAL_PORT_STATUS_FLAG
);
}
db.SaveChanges();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... updateDataStsSerialPort");
}
return(new object[] { msgError });
}
public object[] deleteDataMst009(MST_CUSTOMER param)
{
log.Info("Start log INFO... deleteDataMst009");
MsgForm msgError = new MsgForm();
MST_CUSTOMER form = new MST_CUSTOMER();
List <MST_CUSTOMER_SERVICE> lstFormCustomerService = new List <MST_CUSTOMER_SERVICE>();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.MST_CUSTOMER where row.CUSTOMER_ID == param.CUSTOMER_ID select row).FirstOrDefault();
if (Util.isNotEmpty(form))
{
db.MST_CUSTOMER.Remove(form);
}
lstFormCustomerService = (from row in db.MST_CUSTOMER_SERVICE where row.CUSTOMER_ID == param.CUSTOMER_ID select row).ToList();
if (Util.isNotEmpty(lstFormCustomerService))
{
db.MST_CUSTOMER_SERVICE.RemoveRange(lstFormCustomerService);
}
db.SaveChanges();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... deleteDataMst009");
}
return(new object[] { msgError });
}
public object[] updateDataMstVendor(MST_VENDOR param)
{
log.Info("Start log INFO... updateDataMstVendor");
MsgForm msgError = new MsgForm();
MST_VENDOR form = new MST_VENDOR();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.MST_VENDOR where row.VENDOR_ID == param.VENDOR_ID select row).FirstOrDefault();
if (Util.isNotEmpty(form))
{
form.VENDOR_NAME = param.VENDOR_NAME;
form.VENDOR_ADDRESS = param.VENDOR_ADDRESS;
form.VENDOR_DISTRICT = param.VENDOR_DISTRICT;
form.VENDOR_AMPHURE = param.VENDOR_AMPHURE;
form.VENDOR_PROVINCE = param.VENDOR_PROVINCE;
form.VENDOR_POSTCODE = param.VENDOR_POSTCODE;
form.VENDOR_TEL_NO = param.VENDOR_TEL_NO;
form.VENDOR_FAX = param.VENDOR_FAX;
}
db.SaveChanges();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... updateDataMstVendor");
}
return(new object[] { msgError });
}
public object[] insertOrUpdateDataMst009(MST_CUSTOMER param, List <MST_CUSTOMER_SERVICE> lstParamCustomerService, string flagAddEdit)
{
log.Info("Start log INFO... insertOrUpdateDataMst009");
MsgForm msgError = new MsgForm();
MST_CUSTOMER formInsert = new MST_CUSTOMER();
MST_CUSTOMER formUpdate = new MST_CUSTOMER();
MST_CUSTOMER_SERVICE formInsertCustomerService = new MST_CUSTOMER_SERVICE();
MST_CUSTOMER_SERVICE formUpdateCustomerService = new MST_CUSTOMER_SERVICE();
try
{
using (var db = new PaknampoScaleDBEntities())
{
formUpdate = (from row in db.MST_CUSTOMER where row.CUSTOMER_ID == param.CUSTOMER_ID select row).FirstOrDefault();
if (flagAddEdit.Equals("A"))
{
if (Util.isEmpty(formUpdate))
{
formInsert.CUSTOMER_ID = param.CUSTOMER_ID;
formInsert.CUSTOMER_STATEMENT_STATUS = param.CUSTOMER_STATEMENT_STATUS;
formInsert.CUSTOMER_NAME = param.CUSTOMER_NAME;
formInsert.CUSTOMER_ADDRESS = param.CUSTOMER_ADDRESS;
formInsert.CUSTOMER_DISTRICT = param.CUSTOMER_DISTRICT;
formInsert.CUSTOMER_AMPHURE = param.CUSTOMER_AMPHURE;
formInsert.CUSTOMER_PROVINCE = param.CUSTOMER_PROVINCE;
formInsert.CUSTOMER_POSTCODE = param.CUSTOMER_POSTCODE;
formInsert.CUSTOMER_TEL_NO = param.CUSTOMER_TEL_NO;
formInsert.CUSTOMER_FAX = param.CUSTOMER_FAX;
db.MST_CUSTOMER.Add(formInsert);
log.Info("Update Data form MST_CUSTOMER"
+ " CUSTOMER_ID : " + formInsert.CUSTOMER_ID
+ " CUSTOMER_STATEMENT_STATUS : " + formInsert.CUSTOMER_STATEMENT_STATUS
+ " CUSTOMER_NAME : " + formInsert.CUSTOMER_NAME
+ " CUSTOMER_ADDRESS : " + formInsert.CUSTOMER_ADDRESS
+ " CUSTOMER_DISTRICT : " + formInsert.CUSTOMER_DISTRICT
+ " CUSTOMER_AMPHURE : " + formInsert.CUSTOMER_AMPHURE
+ " CUSTOMER_PROVINCE : " + formInsert.CUSTOMER_PROVINCE
+ " CUSTOMER_POSTCODE : " + formInsert.CUSTOMER_POSTCODE
+ " CUSTOMER_TEL_NO : " + formInsert.CUSTOMER_TEL_NO
+ " CUSTOMER_FAX : " + formInsert.CUSTOMER_FAX
);
}
}
else if (flagAddEdit.Equals("E"))
{
if (Util.isNotEmpty(formUpdate))
{
formUpdate.CUSTOMER_STATEMENT_STATUS = param.CUSTOMER_STATEMENT_STATUS;
formUpdate.CUSTOMER_NAME = param.CUSTOMER_NAME;
formUpdate.CUSTOMER_ADDRESS = param.CUSTOMER_ADDRESS;
formUpdate.CUSTOMER_DISTRICT = param.CUSTOMER_DISTRICT;
formUpdate.CUSTOMER_AMPHURE = param.CUSTOMER_AMPHURE;
formUpdate.CUSTOMER_PROVINCE = param.CUSTOMER_PROVINCE;
formUpdate.CUSTOMER_POSTCODE = param.CUSTOMER_POSTCODE;
formUpdate.CUSTOMER_TEL_NO = param.CUSTOMER_TEL_NO;
formUpdate.CUSTOMER_FAX = param.CUSTOMER_FAX;
log.Info("Update Data form MST_CUSTOMER"
+ " CUSTOMER_STATEMENT_STATUS : " + formUpdate.CUSTOMER_STATEMENT_STATUS
+ " CUSTOMER_NAME : " + formUpdate.CUSTOMER_NAME
+ " CUSTOMER_ADDRESS : " + formUpdate.CUSTOMER_ADDRESS
+ " CUSTOMER_DISTRICT : " + formUpdate.CUSTOMER_DISTRICT
+ " CUSTOMER_AMPHURE : " + formUpdate.CUSTOMER_AMPHURE
+ " CUSTOMER_PROVINCE : " + formUpdate.CUSTOMER_PROVINCE
+ " CUSTOMER_POSTCODE : " + formUpdate.CUSTOMER_POSTCODE
+ " CUSTOMER_TEL_NO : " + formUpdate.CUSTOMER_TEL_NO
+ " CUSTOMER_FAX : " + formUpdate.CUSTOMER_FAX
);
}
}
foreach (MST_CUSTOMER_SERVICE dbean in lstParamCustomerService)
{
formUpdateCustomerService = (from row in db.MST_CUSTOMER_SERVICE where row.CUSTOMER_SERVICE_ID == dbean.CUSTOMER_SERVICE_ID select row).FirstOrDefault();
if (Util.isEmpty(formUpdateCustomerService))
{
//formInsertCustomerService.CUSTOMER_SERVICE_ID = dbean.CUSTOMER_SERVICE_ID;
formInsertCustomerService = new MST_CUSTOMER_SERVICE();
formInsertCustomerService.CUSTOMER_SERVICE_ID = db.MST_CUSTOMER_SERVICE.Count() + 1;
formInsertCustomerService.CUSTOMER_SERVICE_VALUE = dbean.CUSTOMER_SERVICE_VALUE;
formInsertCustomerService.CUSTOMER_ID = dbean.CUSTOMER_ID;
formInsertCustomerService.SERVICE_CHARGE_ID = dbean.SERVICE_CHARGE_ID;
db.MST_CUSTOMER_SERVICE.Add(formInsertCustomerService);
log.Info("Insert Data form MST_CUSTOMER_SERVICE"
+ " CUSTOMER_SERVICE_ID : " + formInsertCustomerService.CUSTOMER_SERVICE_ID
+ " CUSTOMER_SERVICE_VALUE : " + formInsertCustomerService.CUSTOMER_SERVICE_VALUE
+ " CUSTOMER_ID : " + formInsertCustomerService.CUSTOMER_ID
+ " SERVICE_CHARGE_ID : " + formInsertCustomerService.SERVICE_CHARGE_ID
);
}
else
{
formUpdateCustomerService.CUSTOMER_SERVICE_VALUE = dbean.CUSTOMER_SERVICE_VALUE;
formUpdateCustomerService.CUSTOMER_ID = dbean.CUSTOMER_ID;
formUpdateCustomerService.SERVICE_CHARGE_ID = dbean.SERVICE_CHARGE_ID;
log.Info("Update Data form MST_CUSTOMER_SERVICE"
+ " CUSTOMER_SERVICE_ID : " + formUpdateCustomerService.CUSTOMER_SERVICE_ID
+ " CUSTOMER_SERVICE_VALUE : " + formUpdateCustomerService.CUSTOMER_SERVICE_VALUE
+ " CUSTOMER_ID : " + formUpdateCustomerService.CUSTOMER_ID
+ " SERVICE_CHARGE_ID : " + formUpdateCustomerService.SERVICE_CHARGE_ID
);
}
//if (flagAddEdit.Equals("A"))
//{
// if (Util.isEmpty(formUpdateCustomerService))
// {
// //formInsertCustomerService.CUSTOMER_SERVICE_ID = dbean.CUSTOMER_SERVICE_ID;
// formInsertCustomerService = new MST_CUSTOMER_SERVICE();
// formInsertCustomerService.CUSTOMER_SERVICE_ID = db.MST_CUSTOMER_SERVICE.Count() + 1;
// formInsertCustomerService.CUSTOMER_SERVICE_VALUE = dbean.CUSTOMER_SERVICE_VALUE;
// formInsertCustomerService.CUSTOMER_ID = dbean.CUSTOMER_ID;
// formInsertCustomerService.SERVICE_CHARGE_ID = dbean.SERVICE_CHARGE_ID;
// db.MST_CUSTOMER_SERVICE.Add(formInsertCustomerService);
// log.Info("Insert Data form MST_CUSTOMER_SERVICE"
// + " CUSTOMER_SERVICE_ID : " + formInsertCustomerService.CUSTOMER_SERVICE_ID
// + " CUSTOMER_SERVICE_VALUE : " + formInsertCustomerService.CUSTOMER_SERVICE_VALUE
// + " CUSTOMER_ID : " + formInsertCustomerService.CUSTOMER_ID
// + " SERVICE_CHARGE_ID : " + formInsertCustomerService.SERVICE_CHARGE_ID
// );
// }
//}
//else if (flagAddEdit.Equals("E"))
//{
// if (Util.isNotEmpty(formUpdateCustomerService))
// {
// formUpdateCustomerService.CUSTOMER_SERVICE_VALUE = dbean.CUSTOMER_SERVICE_VALUE;
// formUpdateCustomerService.CUSTOMER_ID = dbean.CUSTOMER_ID;
// formUpdateCustomerService.SERVICE_CHARGE_ID = dbean.SERVICE_CHARGE_ID;
// log.Info("Update Data form MST_CUSTOMER_SERVICE"
// + " CUSTOMER_SERVICE_ID : " + formUpdateCustomerService.CUSTOMER_SERVICE_ID
// + " CUSTOMER_SERVICE_VALUE : " + formUpdateCustomerService.CUSTOMER_SERVICE_VALUE
// + " CUSTOMER_ID : " + formUpdateCustomerService.CUSTOMER_ID
// + " SERVICE_CHARGE_ID : " + formUpdateCustomerService.SERVICE_CHARGE_ID
// );
// }
//}
db.SaveChanges();
}
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... insertOrUpdateDataMst009");
}
return(new object[] { msgError, formUpdate });
}
public object[] insertOrUpdateDataManageUserLogin(USER_LOGIN param, LOGIN_STATUS paramStatus, string flagAddEdit)
{
log.Info("Start log INFO... insertOrUpdateDataManageUserLogin");
MsgForm msgError = new MsgForm();
USER_LOGIN formInsert = new USER_LOGIN();
USER_LOGIN formUpdate = new USER_LOGIN();
LOGIN_STATUS formUpdateStatusLogin = new LOGIN_STATUS();
try
{
using (var db = new PaknampoScaleDBEntities())
{
formUpdate = (from row in db.USER_LOGIN where row.USER_ID == param.USER_ID select row).FirstOrDefault();
formUpdateStatusLogin = (from row in db.LOGIN_STATUS where row.LOGIN_STATUS_ID == 1 select row).FirstOrDefault();
if (flagAddEdit.Equals("A"))
{
if (Util.isEmpty(formUpdate))
{
formInsert.USER_ID = param.USER_ID;
formInsert.USER_PASSWORD = param.USER_PASSWORD;
formInsert.USER_FIRSTNAME = param.USER_FIRSTNAME;
formInsert.USER_LASTNAME = param.USER_LASTNAME;
formInsert.STATUS_FLAG = param.STATUS_FLAG;
db.USER_LOGIN.Add(formInsert);
log.Info("Insert Data form USER_LOGIN"
+ " USER_ID : " + formInsert.USER_ID
+ " USER_PASSWORD : "******" USER_FIRSTNAME : " + formInsert.USER_FIRSTNAME
+ " USER_LASTNAME : " + formInsert.USER_LASTNAME
+ " STATUS_FLAG : " + formInsert.STATUS_FLAG
);
}
}
else if (flagAddEdit.Equals("E"))
{
if (Util.isNotEmpty(formUpdate))
{
formUpdate.USER_PASSWORD = param.USER_PASSWORD;
formUpdate.USER_FIRSTNAME = param.USER_FIRSTNAME;
formUpdate.USER_LASTNAME = param.USER_LASTNAME;
formUpdate.STATUS_FLAG = param.STATUS_FLAG;
log.Info("Update Data form USER_LOGIN"
+ " USER_ID : " + formUpdate.USER_ID
+ " USER_PASSWORD : "******" USER_FIRSTNAME : " + formUpdate.USER_FIRSTNAME
+ " USER_LASTNAME : " + formUpdate.USER_LASTNAME
+ " STATUS_FLAG : " + formUpdate.STATUS_FLAG
);
}
}
formUpdateStatusLogin.LOGIN_STATUS_VALUE = paramStatus.LOGIN_STATUS_VALUE;
log.Info("Update Data form LOGIN_STATUS"
+ " LOGIN_STATUS_ID : " + paramStatus.LOGIN_STATUS_ID
+ " LOGIN_STATUS_VALUE : " + paramStatus.LOGIN_STATUS_VALUE
);
db.SaveChanges();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... insertOrUpdateDataManageUserLogin");
}
return(new object[] { msgError, formUpdate });
}
public object[] insertOrUpdateDataMstDestination(MST_DESTINATION param, string flagAddEdit)
{
log.Info("Start log INFO... insertOrUpdateDataMstDestination");
MsgForm msgError = new MsgForm();
MST_DESTINATION formInsert = new MST_DESTINATION();
MST_DESTINATION formUpdate = new MST_DESTINATION();
try
{
using (var db = new PaknampoScaleDBEntities())
{
formUpdate = (from row in db.MST_DESTINATION where row.DESTINATION_ID == param.DESTINATION_ID select row).FirstOrDefault();
if (flagAddEdit.Equals("A"))
{
if (Util.isEmpty(formUpdate))
{
//formInsert.PRODUCT_ID = db.MST_PRODUCT.Count() + 1;
formInsert.DESTINATION_ID = param.DESTINATION_ID;
formInsert.DESTINATION_NAME = param.DESTINATION_NAME;
formInsert.DESTINATION_ADDRESS = param.DESTINATION_ADDRESS;
formInsert.DESTINATION_DISTRICT = param.DESTINATION_DISTRICT;
formInsert.DESTINATION_AMPHURE = param.DESTINATION_AMPHURE;
formInsert.DESTINATION_PROVINCE = param.DESTINATION_PROVINCE;
formInsert.DESTINATION_POSTCODE = param.DESTINATION_POSTCODE;
formInsert.DESTINATION_TEL_NO = param.DESTINATION_TEL_NO;
formInsert.DESTINATION_FAX = param.DESTINATION_FAX;
db.MST_DESTINATION.Add(formInsert);
log.Info("Insert Data form MST_DESTINATION"
+ " DESTINATION_ID : " + formInsert.DESTINATION_ID
+ " DESTINATION_NAME : " + formInsert.DESTINATION_NAME
+ " DESTINATION_ADDRESS : " + formInsert.DESTINATION_ADDRESS
+ " DESTINATION_DISTRICT : " + formInsert.DESTINATION_DISTRICT
+ " DESTINATION_AMPHURE : " + formInsert.DESTINATION_AMPHURE
+ " DESTINATION_PROVINCE : " + formInsert.DESTINATION_PROVINCE
+ " DESTINATION_POSTCODE : " + formInsert.DESTINATION_POSTCODE
+ " DESTINATION_TEL_NO : " + formInsert.DESTINATION_TEL_NO
+ " DESTINATION_FAX : " + formInsert.DESTINATION_FAX
);
}
}
else if (flagAddEdit.Equals("E"))
{
if (Util.isNotEmpty(formUpdate))
{
formUpdate.DESTINATION_ID = param.DESTINATION_ID;
formUpdate.DESTINATION_NAME = param.DESTINATION_NAME;
formUpdate.DESTINATION_ADDRESS = param.DESTINATION_ADDRESS;
formUpdate.DESTINATION_DISTRICT = param.DESTINATION_DISTRICT;
formUpdate.DESTINATION_AMPHURE = param.DESTINATION_AMPHURE;
formUpdate.DESTINATION_PROVINCE = param.DESTINATION_PROVINCE;
formUpdate.DESTINATION_POSTCODE = param.DESTINATION_POSTCODE;
formUpdate.DESTINATION_TEL_NO = param.DESTINATION_TEL_NO;
formUpdate.DESTINATION_FAX = param.DESTINATION_FAX;
log.Info("Update Data form MST_DESTINATION"
+ " DESTINATION_ID : " + formUpdate.DESTINATION_ID
+ " DESTINATION_NAME : " + formUpdate.DESTINATION_NAME
+ " DESTINATION_ADDRESS : " + formUpdate.DESTINATION_ADDRESS
+ " DESTINATION_DISTRICT : " + formUpdate.DESTINATION_DISTRICT
+ " DESTINATION_AMPHURE : " + formUpdate.DESTINATION_AMPHURE
+ " DESTINATION_PROVINCE : " + formUpdate.DESTINATION_PROVINCE
+ " DESTINATION_POSTCODE : " + formUpdate.DESTINATION_POSTCODE
+ " DESTINATION_TEL_NO : " + formUpdate.DESTINATION_TEL_NO
+ " DESTINATION_FAX : " + formUpdate.DESTINATION_FAX
);
}
}
db.SaveChanges();
msgError.statusFlag = MsgForm.STATUS_SUCCESS;
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
msgError.statusFlag = MsgForm.STATUS_ERROR;
msgError.messageDescription = ex.ToString();
}
finally
{
log.Info("End log INFO... insertOrUpdateDataMstDestination");
}
return(new object[] { msgError, formUpdate });
}
