public ActionResult AddSave_Quotation(OrderRecord data)
{
Member member;
recsys_relate_customers masterCustomerData;
recsys_relate_customers customerData;
recsys_order order;
recsys_relate relation;
//# validation
if (data.MasterRecordID < 0)
throw new SystemException("Invalid Entity ID");
//# get old master customer record
var _masterCustomerData = from q in this._db.recsys_quotation
join cd in this._db.recsys_relate_customers on q.customer_id equals cd.id into cds
from cd in cds.DefaultIfEmpty()
where q.id == data.MasterRecordID
select new
{
cd
};
masterCustomerData = _masterCustomerData.Select(theRecord => theRecord.cd).FirstOrDefault();
//# validation
if (masterCustomerData == null)
throw new RecordNotFoundException();
member = new Member("users");
//# mapping
customerData = new recsys_relate_customers()
{
address1 = data.address1,
address2 = data.address2,
center = masterCustomerData.center,
code = masterCustomerData.code,
contact = data.contact,
customer_code = masterCustomerData.customer_code,
customer_id = masterCustomerData.customer_id,
district1 = data.district1,
district2 = data.district2,
email = data.email,
fax1 = data.fax1,
fax2 = data.fax2,
group_id = data.group_id,
manual_input_code = masterCustomerData.manual_input_code,
name = data.name,
chi_name = data.chi_name,
prefix = masterCustomerData.prefix,
relate_type = (int)Rec_System.Models.Customers.CustomerDataRelateType.Quotation,
remark = data.remark,
tel1 = data.tel1,
tel2 = data.tel2,
title = (byte)data.title,
type = (byte)masterCustomerData.type
};
this._db.recsys_relate_customers.AddObject(customerData);
TimeSpan? endTime = null;
if (!(String.IsNullOrEmpty(data.EndTimeHour)) && !(String.IsNullOrEmpty(data.EndTimeMinute)))
endTime = new TimeSpan(Convert.ToInt32(data.EndTimeHour), Convert.ToInt32(data.EndTimeMinute), 0);
TimeSpan? startTime = null;
if (!(String.IsNullOrEmpty(data.StartTimeHour)) && !(String.IsNullOrEmpty(data.StartTimeMinute)))
startTime = new TimeSpan(Convert.ToInt32(data.StartTimeHour), Convert.ToInt32(data.StartTimeMinute), 0);
order = new recsys_order()
{
by_system = 1,
completion_date = DateChecking(data.CompleteDate),
end_time = endTime,
engineer_id_1 = data.engineer_id_1,
engineer_id_2 = data.engineer_id_2,
engineer_id_3 = data.engineer_id_3,
engineer_id_4 = data.engineer_id_4,
fault = data.fault,
model = data.model,
repair = data.repair,
repair_date = DateChecking(data.repair_date),
report = data.report,
reviewer = data.reviewer,
start_time = startTime,
tc = (byte)(data.tc ? 1 : 0),
create_date = DateTime.Now,
last_update = DateTime.Now,
remark = data.remark2,
status = (byte)data.status,
update_user_id = (int)member.infoBySession("id"),
job_number = data.JobNumber,
order_status = data.order_status
};
//alter 故障內容
if (!string.IsNullOrEmpty(order.fault))
{
int index1 = order.fault.IndexOf("[");
int index2 = order.fault.IndexOf("]");
if (index1 > -1 && index2 > -1)
order.fault = order.fault.Substring(index2 + 1);
}
if (order.completion_date.HasValue)
{
order.order_status = OrderStatus.WarrantyCompleted.ID;
order.fault = "[" + OrderStatus.WarrantyCompleted.Name + "] " + order.fault;
}
else if (order.order_status == OrderStatus.DoingWarranty.ID)
{
order.fault = "[" + OrderStatus.DoingWarranty.Name + "] " + order.fault;
order.order_status = OrderStatus.DoingWarranty.ID;
}
else if (order.order_status == OrderStatus.AppointedWarranty.ID)
{
order.fault = "[" + OrderStatus.AppointedWarranty.Name + "] " + order.fault;
order.order_status = OrderStatus.AppointedWarranty.ID;
}
this._db.recsys_order.AddObject(order);
try
{
this._db.SaveChanges();
this._db.Refresh(System.Data.Objects.RefreshMode.StoreWins, customerData);
this._db.Refresh(System.Data.Objects.RefreshMode.StoreWins, order);
order.customer_id = customerData.id;
this._db.SaveChanges();
data.id = order.id;
relation = new recsys_relate()
{
id1 = data.MasterRecordID,
id2 = order.id,
table1 = "quotation",
table2 = "order"
};
this._db.recsys_relate.AddObject(relation);
this._db.SaveChanges();
data.SaveResult.SavedSuccessfully = true;
}
catch (OptimisticConcurrencyException)
{
//# log down
}
return Json(data);
}
public ActionResult Edit(string id,
DateTime? completion_date,
int? enquery_id,
TimeSpan? end_time,
int? engineer_id_1,
int? engineer_id_2,
string fault,
string model,
string remark2,
string repair,
DateTime? repair_date,
string report,
string reviewer,
TimeSpan? start_time,
byte? status,
byte? tc,
int? relate_id,
string relate_table)
{
Validator _val = new Validator();
string customer_code = Common.doPost("customer_code");
string mode = Common.doGet("mode");
string type = Common.doPost("type");
string prefix = Common.doPost("prefix");
string code = Common.doPost("code");
string name = Common.doPost("name");
string address1 = Common.doPost("address1");
string address2 = Common.doPost("address2");
string district1 = Common.doPost("district1");
string district2 = Common.doPost("district2");
string title = Common.doPost("title");
string contact = Common.doPost("contact");
string tel1 = Common.doPost("tel1");
string tel2 = Common.doPost("tel2");
string fax1 = Common.doPost("fax1");
string fax2 = Common.doPost("fax2");
string email = Common.doPost("email");
string remark = Common.doPost("remark");
//string model = Common.doPost("model");
//string fault = Common.doPost("fault");
//string repair = Common.doPost("repair");
//dynamic tc = Common.doPost("tc");
//string report = Common.doPost("report");
//string repair_date = Common.doPost("repair_date");
//string start_time = Common.doPost("start_time");
//string end_time = Common.doPost("end_time");
//string remark2 = Common.doPost("remark2");
//string status = Common.doPost("status");
string group_id = Common.doPost("group_id");
string last_update = Common.doPost("last_update");
string oper = Common.doPost("oper");
//string relate_id = Common.doPost("relate_id");
//string relate_table = Common.doPost("relate_table");
string sql;
if(oper != "del")
{
if (oper == "edit")
{
if (_val.val(id, new String[] { "req", "int" }))
{
int order_id = Convert.ToInt32(id);
string time = ((from o in this._db.recsys_order
where o.id == order_id
select o.last_update).FirstOrDefault()).ToString();
if (! _val.val(last_update, "equal=" + time))
{
return Content(Common.alert("資料已被其他使用者更新"));
}
}
}
else
{
if (type == "3")
{
_val.val(code, new String[] { "req", "int", "minlen=8", "maxlen=8" });
}
_val.val(type, new String[] { "req", "int", "get=1", "let=3" });
}
//_val.val(status, new String[] { "req", "int", "get=0", "let=1" });
_val.val(status.ToString(), new String[] { "req", "int", "get=0", "let=1" });
if(_val.getValStatus())
{
Member _member = new Member("users");
Hashtable data = new Hashtable() {
{ "type", type },
{ "prefix", prefix },
{ "code", code },
{ "group_id", group_id },
{ "name", name },
{ "address1", address1 },
{ "address2", address2 },
{ "district1", district1 },
{ "district2", district2 },
{ "title", title },
{ "contact", contact },
{ "tel1", tel1 },
{ "tel2", tel2 },
{ "fax1", fax1 },
{ "fax2", fax2 },
{ "email", email },
{ "remark", remark }
};
int count = (from c in this._db.recsys_customers
where c.customer_code == customer_code
select c.id).Count();
if (count == 0)
{
data["status"] = 1;
data["last_update"] = DateTime.Now.ToString("s");
data["update_user_id"] = _member.infoBySession("id");
data["create_date"] = DateTime.Now.ToString("s");
sql = Common.doInsert(data, "customers");
this._db.ExecuteStoreCommand(sql);
int cid = (from c in this._db.recsys_customers
orderby c.id descending
select c.id).FirstOrDefault();
Hashtable data2 = new Hashtable();
if (type != "3")
{
data2["auto_id"] = Convert.ToInt32((from c in this._db.recsys_customers
where c.type != 3 && c.auto_id != 0
orderby c.id descending
select c.auto_id).FirstOrDefault()) + 1;
code = data2["auto_id"].ToString().PadLeft(8, '0');
}
customer_code = this._type[type] + prefix + code;
data2["customer_code"] = customer_code;
sql = Common.doUpdate(data2, "customers", "id = '" + cid + "'");
this._db.ExecuteStoreCommand(sql);
data.Remove("status");
data.Remove("last_update");
data.Remove("update_user_id");
data.Remove("create_date");
}
int customer_id;
data["customer_code"] = customer_code;
customer_id = (from c in this._db.recsys_customers
where c.customer_code == customer_code
select c.id).FirstOrDefault();
data["customer_id"] = customer_id;
if (oper == "edit")
{
int order_id = Convert.ToInt32(id);
customer_id = (from o in this._db.recsys_order
where o.id == order_id
select o.customer_id).FirstOrDefault();
sql = Common.doUpdate(data, "relate_customers", "id = '" + customer_id + "'");
this._db.ExecuteStoreCommand(sql);
}
else
{
data["relate_type"] = 4;
sql = Common.doInsert(data, "relate_customers");
this._db.ExecuteStoreCommand(sql);
customer_id = (from c in this._db.recsys_relate_customers
orderby c.id descending
select c.id).FirstOrDefault();
}
recsys_order newOrder = new recsys_order()
{
by_system = 0,
completion_date = null,
create_date = DateTime.Now,
customer_id = customer_id,
enquery_id = enquery_id,
end_time = end_time,
engineer_id_1 = engineer_id_1,
engineer_id_2 = engineer_id_2,
fault = fault,
last_update = DateTime.Now,
model = model,
remark = remark2,
repair = repair,
repair_date = repair_date,
report = report,
reviewer = reviewer,
start_time = start_time,
status = status ?? 1,
tc = tc,
update_user_id = (int) _member.infoBySession("id")
};
if(oper == "edit")
{
////
//sql = Common.doUpdate(data3, "order", "id = '" + id + "'");
this._db.ExecuteStoreCommand(sql);
}
else
{
try
{
this._db.recsys_order.AddObject(newOrder);
this._db.SaveChanges();
this._db.Refresh(System.Data.Objects.RefreshMode.StoreWins, newOrder);
if (newOrder.id > 0 && relate_id > 0)
{
id = newOrder.id.ToString(); //# temp solution
recsys_relate newRelation = new recsys_relate()
{
id1 = relate_id.Value,
id2 = newOrder.id,
table1 = relate_table,
table2 = "order"
};
this._db.recsys_relate.AddObject(newRelation);
this._db.SaveChanges();
this._db.Refresh(System.Data.Objects.RefreshMode.StoreWins, newRelation);
}
//data3["customer_id"] = customer_id;
//data3["create_date"] = DateTime.Now.ToString("s");
//sql = Common.doInsert(data3, "order");
//this._db.ExecuteStoreCommand(sql);
//id = (from o in this._db.recsys_order
// orderby o.id descending
// select o.id).FirstOrDefault().ToString();
//if (!String.IsNullOrWhiteSpace(relate_id))
//{
// Hashtable data4 = new Hashtable()
//{
// { "id1", relate_id },
// { "id2", id },
// { "table1", relate_table },
// { "table2", "order" }
//};
// sql = Common.doInsert(data4, "relate");
// this._db.ExecuteStoreCommand(sql);
//}
}
catch(OptimisticConcurrencyException)
{
//# log down
}
}
return RedirectToAction("edit", new { id = id, mode = mode, customer_id = customer_id, relate_id = relate_id, relate_table = relate_table });
}
else
{
return Content(Common.alert("輸入錯誤"));
}
}
else
{
int order_id = Convert.ToInt32(id);
int customer_id = (from o in this._db.recsys_order
where o.id == order_id
select o.customer_id).FirstOrDefault();
sql = Common.doDelete("relate_customers", "id = '" + customer_id + "'");
this._db.ExecuteStoreCommand(sql);
int[] parts_id = (from r in this._db.recsys_relate
where r.id2 == order_id && r.table1 == "parts" && r.table2 == "order"
select r.id1).ToArray();
if (parts_id.Length > 0)
{
sql = Common.doDelete("parts", "id IN ('" + String.Join("','", parts_id) + "')");
this._db.ExecuteStoreCommand(sql);
}
int[] job_id = (from r in this._db.recsys_relate
where r.id1 == order_id && r.table1 == "order" && r.table2 == "job"
select r.id2).ToArray();
if (job_id.Length > 0)
{
sql = Common.doDelete("job", "id IN ('" + String.Join("','", job_id) + "')");
this._db.ExecuteStoreCommand(sql);
}
int[] extra_cost_id = (from r in this._db.recsys_relate
where r.id1 == order_id && r.table1 == "order" && r.table2 == "extra_cost"
select r.id2).ToArray();
if (extra_cost_id.Length > 0)
{
sql = Common.doDelete("extra_cost", "id IN ('" + String.Join("','", extra_cost_id) + "')");
this._db.ExecuteStoreCommand(sql);
}
sql = Common.doDelete("relate", "(id1 = '" + id + "' AND table1 = 'order') OR (id2 = '" + id + "' AND table2 = 'order')");
this._db.ExecuteStoreCommand(sql);
sql = Common.doDelete("order_report", "order_id = '" + id + "'");
this._db.ExecuteStoreCommand(sql);
sql = Common.doDelete("order", "id = '" + id + "'");
this._db.ExecuteStoreCommand(sql);
return Content(Common.json_encode(true));
}
}
public ActionResult AddSave_Quotation(ECallRecord data)
{
Member member;
recsys_relate_customers masterCustomerData;
recsys_relate_customers customerData;
recsys_order ecall;
recsys_relate relation;
//# validation
if (data.MasterRecordID < 0)
throw new SystemException("Invalid Entity ID");
//# get old master customer record
var _masterCustomerData = from q in this._db.recsys_quotation
join cd in this._db.recsys_relate_customers on q.customer_id equals cd.id into cds
from cd in cds.DefaultIfEmpty()
where q.id == data.MasterRecordID
select new
{
cd
};
masterCustomerData = _masterCustomerData.Select(theRecord => theRecord.cd).FirstOrDefault();
//# validation
if (masterCustomerData == null)
throw new RecordNotFoundException();
member = new Member("users");
//# mapping
customerData = new recsys_relate_customers()
{
address1 = data.address1,
address2 = data.address2,
center = masterCustomerData.center,
code = masterCustomerData.code,
contact = data.contact,
customer_code = masterCustomerData.customer_code,
customer_id = masterCustomerData.customer_id,
district1 = data.district1,
district2 = data.district2,
email = data.email,
fax1 = data.fax1,
fax2 = data.fax2,
group_id = data.group_id,
manual_input_code = masterCustomerData.manual_input_code,
name = data.name,
chi_name = data.chi_name,
prefix = masterCustomerData.prefix,
relate_type = (int)Rec_System.Models.Customers.CustomerDataRelateType.Quotation,
remark = data.remark,
reference_number = masterCustomerData.reference_number,
tel1 = data.tel1,
tel2 = data.tel2,
title = (byte)data.title,
type = (byte)masterCustomerData.type
};
this._db.recsys_relate_customers.AddObject(customerData);
ecall = new recsys_order()
{
by_system = 0,
completion_date = DateChecking(data.CompleteDate),
call_pickup_user_id = data.call_pickup_user_id,
end_time = new TimeSpan(Convert.ToInt32(data.EndTimeHour), Convert.ToInt32(data.EndTimeMinute), 0),
engineer_id_1 = data.engineer_id_1,
engineer_id_2 = data.engineer_id_2,
engineer_id_3 = data.engineer_id_3,
engineer_id_4 = data.engineer_id_4,
fault = data.fault,
model = data.model,
repair = data.repair,
repair_date = DateChecking(data.repair_date),
report = data.report,
reviewer = data.reviewer,
start_time = new TimeSpan(Convert.ToInt32(data.StartTimeHour), Convert.ToInt32(data.StartTimeMinute), 0),
tc = (byte) (data.tc ? 1 : 0),
create_date = DateTime.Now,
last_update = DateTime.Now,
remark = data.remark2,
status = (byte)data.status,
update_user_id = (int)member.infoBySession("id"),
job_number = data.JobNumber,
order_status = DateChecking(data.CompleteDate).HasValue ? 3 : (DateChecking(data.repair_date).HasValue ? 2 : 1)
};
this._db.recsys_order.AddObject(ecall);
try
{
this._db.SaveChanges();
this._db.Refresh(System.Data.Objects.RefreshMode.StoreWins, customerData);
this._db.Refresh(System.Data.Objects.RefreshMode.StoreWins, ecall);
ecall.customer_id = customerData.id;
this._db.SaveChanges();
data.id = ecall.id;
relation = new recsys_relate()
{
id1 = data.MasterRecordID,
id2 = ecall.id,
table1 = "quotation",
table2 = "order"
};
this._db.recsys_relate.AddObject(relation);
this._db.SaveChanges();
data.SaveResult.SavedSuccessfully = true;
}
catch (OptimisticConcurrencyException)
{
//# log down
}
return Json(data);
}
private bool TryGenerateOrdersForMaintenance(recsys_maintenance maintenance, recsys_routine routine, out IEnumerable<recsys_order> generatedOrders)
{
recsys_relate_customers masterCustomerData;
Member member;
List<recsys_relate_customers> customerDatas;
List<recsys_order> orders;
DateTime? startCalculationDate = null;
DateTime? endCalculationDate = null;
HolidaysController holidayController;
List<DateTime> holidays;
IEnumerable<DateTime> orderRepairDates;
bool isSuccessful = false;
generatedOrders = new List<recsys_order>();
//# validation
if (routine == null)
return false;
if (maintenance == null)
return true;
if (!routine.repair_date_frequency_in_month.HasValue)
return true;
if (!maintenance.start_date.HasValue && !maintenance.confirm_date.HasValue)
return true; //# start date of the calculation is counting on either the start date or confirm date; if null is given, just return true to indicate no order is generated
if (!maintenance.end_date.HasValue)
return true; //# if maintenace does not have an end date, do not do anything
//startCalculationDate = maintenance.confirm_date.HasValue ? maintenance.confirm_date.Value : maintenance.start_date;
startCalculationDate = maintenance.start_date;
endCalculationDate = maintenance.end_date;
holidayController = new HolidaysController();
holidays = holidayController.GetHolidays(startCalculationDate.Value, endCalculationDate.Value, true);
orderRepairDates = maintenance.GetOrderRepairDatesByRoutine(routine, holidays);
//# get old master customer record
var _masterCustomerData = from m in this._db.recsys_maintenance
join cd in this._db.recsys_relate_customers on m.customer_id equals cd.id into cds
from cd in cds.DefaultIfEmpty()
where m.id == maintenance.id
select new
{
cd
};
masterCustomerData = _masterCustomerData.Select(theRecord => theRecord.cd).FirstOrDefault();
//# validation
if (masterCustomerData == null)
throw new RecordNotFoundException();
member = new Member("users");
customerDatas = new List<recsys_relate_customers>();
//# customer data
for (int i = 0; i < orderRepairDates.Count(); i++)
{
//# mapping
recsys_relate_customers customerData = new recsys_relate_customers()
{
address1 = masterCustomerData.address1,
address2 = masterCustomerData.address2,
center = masterCustomerData.center,
code = masterCustomerData.code,
contact = masterCustomerData.contact,
customer_code = masterCustomerData.customer_code,
customer_id = masterCustomerData.customer_id,
district1 = masterCustomerData.district1,
district2 = masterCustomerData.district2,
email = masterCustomerData.email,
fax1 = masterCustomerData.fax1,
fax2 = masterCustomerData.fax2,
group_id = masterCustomerData.group_id,
manual_input_code = masterCustomerData.manual_input_code,
name = masterCustomerData.name,
chi_name = masterCustomerData.chi_name,
prefix = masterCustomerData.prefix,
relate_type = (int)Rec_System.Models.Customers.CustomerDataRelateType.Quotation,
reference_number = masterCustomerData.reference_number,
remark = masterCustomerData.remark,
tel1 = masterCustomerData.tel1,
tel2 = masterCustomerData.tel2,
title = (byte)masterCustomerData.title,
type = (byte)masterCustomerData.type
};
customerDatas.Add(customerData);
this._db.recsys_relate_customers.AddObject(customerData);
}
try
{
this._db.SaveChanges();
this._db.Refresh(System.Data.Objects.RefreshMode.StoreWins, customerDatas);
orders = new List<recsys_order>();
for (int j = 0; j < customerDatas.Count; j++)
{
recsys_relate_customers theCustomerData = customerDatas[j];
recsys_order order = new recsys_order()
{
by_system = 1,
create_date = DateTime.Now,
model = maintenance.model,
repair_date = orderRepairDates.ElementAt(j),
customer_id = theCustomerData.id,
fault = "[" + OrderStatus.AppointedWarranty.Name + "]", //# logic
last_update = DateTime.Now,
status = (byte) RecordStatus.Active,
update_user_id = (int)member.infoBySession("id"),
start_time = null,
end_time = null,
order_status = OrderStatus.AppointedWarranty.ID,
call_pickup_user_id = (int) member.infoBySession("id")
};
orders.Add(order);
this._db.recsys_order.AddObject(order);
}
this._db.SaveChanges();
this._db.Refresh(System.Data.Objects.RefreshMode.StoreWins, orders);
foreach (recsys_order theOrder in orders)
{
recsys_relate relation = new recsys_relate()
{
id1 = maintenance.id,
id2 = theOrder.id,
table1 = "maintenance",
table2 = "order"
};
this._db.recsys_relate.AddObject(relation);
}
this._db.SaveChanges();
generatedOrders = orders;
isSuccessful = true;
}
catch(OptimisticConcurrencyException)
{
//# log down
}
return isSuccessful;
}
/// <summary>
/// Deprecated Method for adding a new object to the recsys_order EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTorecsys_order(recsys_order recsys_order)
{
base.AddObject("recsys_order", recsys_order);
}
/// <summary>
/// Create a new recsys_order object.
/// </summary>
/// <param name="id">Initial value of the id property.</param>
/// <param name="customer_id">Initial value of the customer_id property.</param>
/// <param name="create_date">Initial value of the create_date property.</param>
/// <param name="status">Initial value of the status property.</param>
/// <param name="by_system">Initial value of the by_system property.</param>
public static recsys_order Createrecsys_order(global::System.Int32 id, global::System.Int32 customer_id, global::System.DateTime create_date, global::System.Byte status, global::System.Byte by_system)
{
recsys_order recsys_order = new recsys_order();
recsys_order.id = id;
recsys_order.customer_id = customer_id;
recsys_order.create_date = create_date;
recsys_order.status = status;
recsys_order.by_system = by_system;
return recsys_order;
}
