private ActionResult Add(EnqueryGridRecordBase data, int? masterCustomerID, int Status2)
{
bool isSuccess = false;
Member member = new Member("users");
recsys_customers masterCustomer = null;
recsys_relate_customers newCustomerData;
recsys_enquery newRecord;
try
{
if (masterCustomerID.HasValue)
masterCustomer = this._db.recsys_customers.FirstOrDefault(theCustomer => theCustomer.id == masterCustomerID);
newCustomerData = new recsys_relate_customers()
{
customer_id = masterCustomerID.HasValue ? masterCustomerID.Value : -1,
name = masterCustomer == null ? null : masterCustomer.name,
manual_input_code = masterCustomer == null ? null : masterCustomer.manual_input_code,
code = masterCustomer == null ? null : masterCustomer.code,
prefix = masterCustomer == null ? null : masterCustomer.prefix,
contact = data.Contact,
customer_code = masterCustomer == null ? null : masterCustomer.customer_code,
type = masterCustomer == null ? (byte?) null : masterCustomer.type,
tel2 = data.Tel,
email = data.EMail,
relate_type = (int)CustomerDataRelateType.Enquery
};
this._db.recsys_relate_customers.AddObject(newCustomerData);
this._db.SaveChanges();
this._db.Refresh(System.Data.Objects.RefreshMode.StoreWins, newCustomerData);
if (newCustomerData.id <= 0)
return Json(false, JsonRequestBehavior.AllowGet);
newRecord = new recsys_enquery()
{
create_date = DateTime.Now,
customer_id = newCustomerData.id,
last_update = DateTime.Now,
remark = data.Remark,
sBookingInformation = data.BookingInformation,
status = (byte) Status2,
update_user_id = (int)member.infoBySession("id")
};
this._db.recsys_enquery.AddObject(newRecord);
this._db.SaveChanges();
isSuccess = true;
}
catch (OptimisticConcurrencyException)
{
//# log down
}
return Json(isSuccess, JsonRequestBehavior.AllowGet);
}
public ActionResult Edit(EnqueryGridRecordBase data, int? masterCustomerID, int Status2)
{
bool isSuccess = false;
Member member = new Member("users");
recsys_enquery oldRecord;
recsys_relate_customers oldRecordCustomerData;
oldRecord = this._db.recsys_enquery.FirstOrDefault(theRecord => theRecord.id == data.ID);
if (oldRecord == null)
return Json(false, JsonRequestBehavior.AllowGet);
oldRecordCustomerData = this._db.recsys_relate_customers.FirstOrDefault(theCustomerData => theCustomerData.id == oldRecord.customer_id);
if (oldRecordCustomerData == null)
return Json(false, JsonRequestBehavior.AllowGet);
oldRecord.sBookingInformation = data.BookingInformation;
oldRecord.remark = data.Remark;
oldRecord.last_update = DateTime.Now;
oldRecord.status = (byte) Status2;
oldRecord.update_user_id = (int)member.infoBySession("id");
oldRecordCustomerData.contact = data.Contact;
oldRecordCustomerData.tel2 = data.Tel;
oldRecordCustomerData.email = data.EMail;
if (masterCustomerID.HasValue)
{
recsys_customers masterCustomer = this._db.recsys_customers.FirstOrDefault(theCustomer => theCustomer.id == masterCustomerID.Value);
if (masterCustomer != null)
{
oldRecordCustomerData.customer_id = masterCustomerID.Value;
oldRecordCustomerData.name = masterCustomer.name;
oldRecordCustomerData.manual_input_code = masterCustomer.manual_input_code;
oldRecordCustomerData.code = masterCustomer.code;
oldRecordCustomerData.prefix = masterCustomer.prefix;
oldRecordCustomerData.customer_code = masterCustomer.customer_code;
oldRecordCustomerData.type = masterCustomer.type;
}
}
try
{
this._db.SaveChanges();
isSuccess = true;
}
catch (OptimisticConcurrencyException)
{
//# log down
}
return Json(isSuccess, JsonRequestBehavior.AllowGet);
}