//
// GET: /CrmInterfacing/
public ActionResult CRM_Customer_Booking(
string customer_code,
string tel,
string contact,
string email,
string remark,
string bookings
)
{
if (!string.IsNullOrWhiteSpace(customer_code))
{
db _db = new db();
var customer = (from c in _db.recsys_customers
where c.status == 1 && c.customer_code.Contains(customer_code)
select c).FirstOrDefault();
if (customer != null)
{
recsys_relate_customers customer_data = new recsys_relate_customers()
{
customer_id = customer.id,
name = customer.name,
customer_code = customer.customer_code,
prefix = customer.prefix,
code = customer.code,
manual_input_code = customer.manual_input_code,
contact = contact,
relate_type = (int)CustomerDataRelateType.Enquery,
tel2 = tel,
email = email
};
_db.recsys_relate_customers.AddObject(customer_data);
_db.SaveChanges();
_db.Refresh(System.Data.Objects.RefreshMode.StoreWins, customer_data);
if (customer_data.id != 0)
{
recsys_enquery enquery = new recsys_enquery()
{
create_date = DateTime.Now,
customer_id = customer_data.id,
last_update = DateTime.Now,
remark = remark,
sBookingInformation = bookings,
status = (int) RecordStatus.Active
};
_db.recsys_enquery.AddObject(enquery);
_db.SaveChanges();
return Content("true");
}
}
}
return Content("false");
}
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 CRM_Customer_Enquery(
string tel,
string contact,
string email,
string remark,
string address,
string company_name
)
{
db _db = new db();
recsys_relate_customers customer_data = new recsys_relate_customers()
{
customer_id = -1,
contact = contact,
relate_type = (int)CustomerDataRelateType.Enquery,
tel2 = tel,
email = email,
address2 = address
};
_db.recsys_relate_customers.AddObject(customer_data);
_db.SaveChanges();
_db.Refresh(System.Data.Objects.RefreshMode.StoreWins, customer_data);
if (customer_data.id != 0)
{
recsys_enquery enquery = new recsys_enquery()
{
create_date = DateTime.Now,
customer_id = customer_data.id,
last_update = DateTime.Now,
remark = (string.IsNullOrEmpty(company_name) ? string.Empty : "[公司名稱] " + company_name + "\r\n") + remark,
status = (int)RecordStatus.Active
};
_db.recsys_enquery.AddObject(enquery);
_db.SaveChanges();
return Content("true");
}
return Content("false");
}
/// <summary>
/// Deprecated Method for adding a new object to the recsys_enquery EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTorecsys_enquery(recsys_enquery recsys_enquery)
{
base.AddObject("recsys_enquery", recsys_enquery);
}
/// <summary>
/// Create a new recsys_enquery object.
/// </summary>
/// <param name="id">Initial value of the id property.</param>
/// <param name="user_id">Initial value of the user_id property.</param>
/// <param name="customer_id">Initial value of the customer_id property.</param>
/// <param name="status">Initial value of the status property.</param>
/// <param name="create_date">Initial value of the create_date property.</param>
/// <param name="update_user_id">Initial value of the update_user_id property.</param>
public static recsys_enquery Createrecsys_enquery(global::System.Int32 id, global::System.Int32 user_id, global::System.Int32 customer_id, global::System.Byte status, global::System.DateTime create_date, global::System.Int32 update_user_id)
{
recsys_enquery recsys_enquery = new recsys_enquery();
recsys_enquery.id = id;
recsys_enquery.user_id = user_id;
recsys_enquery.customer_id = customer_id;
recsys_enquery.status = status;
recsys_enquery.create_date = create_date;
recsys_enquery.update_user_id = update_user_id;
return recsys_enquery;
}