public bool deleteDelivery(Delivery delivery, UserAC user)
{
IDatabase db = DAOFactory.getInstance().getDatabase();
DbConnection conn = db.getConnection();
DbTransaction transaction = db.beginTransaction(conn);
try
{
IDeliveryDAO ccDao = DAOFactory.getInstance().createDeliveryDAO();
delivery.updateBy = user.eng_name;
delivery.updateDate = DateTime.Now;
delivery.isDeleted = false;
ccDao.delete(delivery, transaction);
transaction.Commit();
return true;
}
catch (Exception e)
{
transaction.Rollback();
throw e;
}
finally
{
conn.Close();
}
}
public bool addDelivery(Delivery delivery, UserAC user)
{
IDatabase db = DAOFactory.getInstance().getDatabase();
DbConnection conn = db.getConnection();
DbTransaction transaction = db.beginTransaction(conn);
try
{
IDeliveryDAO ccDao = DAOFactory.getInstance().createDeliveryDAO();
ISequenceDAO seqDAO = DAOFactory.getInstance().createSequenceDAO();
delivery.objectId = seqDAO.getNextObjectId(transaction);
delivery.number = "DAA" + delivery.objectId;
delivery.updateBy = user.eng_name;
delivery.createDate = DateTime.Now;
delivery.updateDate = DateTime.Now;
delivery.isDeleted = false;
ccDao.Add(delivery, transaction);
transaction.Commit();
return true;
}
catch (Exception e)
{
transaction.Rollback();
throw e;
}
finally
{
conn.Close();
}
}
public object add(
string objectid,
string city,
string companyname,
string contact,
string deadline,
string district,
string handleby,
string height,
string length,
string mobile,
string nonorder,
string notes,
string number,
string partno,
string remarks,
string requestby,
string street1,
string street2,
string street3,
string tel,
string updateby,
string updatedate,
string weight,
string width,
string code,
string delivery_type,
string status,
string goods_type
)
{
try
{
int objid = 0;
int.TryParse(objectid, out objid);
var q = Request["width"];
if (q == null)
q = Request.Params["query"];
UserAC user = (UserAC)Session["user"];
IFPService service = (IFPService)FPServiceHolder.getInstance().getService("fpService");
IFPObjectService objectService = (IFPObjectService)FPServiceHolder.getInstance().getService("fpObjectService");
Delivery delivery = objectService.getDeliveryById(objid, user);
// CustomerContact cc = new CustomerContact();
// if (code == null)
// throw new Exception("null contact code !");
Customer customer = objectService.getCustomerByCustomerID(code.Trim(), user);
// if (customer == null)
// throw new Exception("this customer is not exist,please input exist customer .");
if (customer == null)
customer = new Customer();
int handuserid = 0;
int.TryParse(handleby, out handuserid);
UserAC handuser = objectService.getUserByID(handuserid, user);
int requestuserid = 0;
int.TryParse(requestby, out requestuserid);
UserAC requestuser = objectService.getUserByID(requestuserid, user);
DateTime dead = new DateTime();
if (string.IsNullOrEmpty(deadline))
dead = DateTime.Now;
else
{
var m = deadline.Substring(deadline.Length - 2);
if (m.ToLower().Contains("pm") || m.ToLower().Contains("am"))
{
var datetime = deadline.Split(' ');
var date = datetime[0].Split('/');
var time = datetime[1].Replace(m, string.Empty).Split(':');
if (m.ToLower().Trim() == "pm")
{
dead = new DateTime(int.Parse(date[2]), int.Parse(date[1]), int.Parse(date[0]), int.Parse(time[0]) + 12, int.Parse(time[1]), 0);
}
else
{
dead = new DateTime(int.Parse(date[2]), int.Parse(date[1]), int.Parse(date[0]), int.Parse(time[0]), int.Parse(time[1]), 0);
}
}
else
{
dead = DateTime.Now;
}
}
// if (customer == null)
// customer = new Customer();
if (delivery != null)
{
delivery.assigned_by = user;
delivery.deadline = dead;
delivery.status = "processing";
delivery.handled_by = handuser;
delivery.height = height;
delivery.isDeleted = false;
delivery.length = length;
delivery.goods_type = goods_type;
delivery.non_order = nonorder;
delivery.notes = notes;
delivery.number = number;
delivery.objectId = objid;
delivery.part_no = partno;
delivery.requested_by = requestuser;
delivery.weight = weight;
delivery.width = width;
delivery.delivery_type = delivery_type;
delivery.status = status;
delivery.remarks = remarks;
delivery.customer = customer;
//cc = delivery.contact;
//if (cc != null)
//{
// cc.city = city;
// cc.cid = code;
// cc.cname = companyname;
// cc.contact_person = contact;
// cc.createDate = DateTime.Now;
// cc.ctype = "normal";
// cc.customer = customer;
// cc.district = district;
// cc.tel = tel;
// cc.isDeleted = false;
// cc.mobile = mobile;
// // cc.remarks = remarks;
// cc.street1 = street1;
// cc.street2 = street2;
// cc.street3 = street3;
// service.updateCustomerContact(cc, user);
//}
//else
//{
// cc = new CustomerContact();
// cc.city = city;
// cc.cid = code;
// cc.cname = companyname;
// cc.contact_person = contact;
// cc.createDate = DateTime.Now;
// cc.ctype = "normal";
// cc.customer = customer;
// cc.district = district;
// cc.tel = tel;
// cc.isDeleted = false;
// cc.mobile = mobile;
// // cc.remarks = remarks;
// cc.street1 = street1;
// cc.street2 = street2;
// cc.street3 = street3;
// service.addCustomerContact(cc, user);
//}
// delivery.contact = cc;
service.updateDelivery(delivery, user);
}
else
{
delivery = new Delivery();
delivery.assigned_by = user;
delivery.deadline = dead;
delivery.status = "processing";
delivery.handled_by = handuser;
delivery.height = height;
delivery.isDeleted = false;
delivery.length = length;
delivery.non_order = nonorder;
delivery.notes = notes;
delivery.number = number;
delivery.objectId = objid;
delivery.part_no = partno;
delivery.requested_by = requestuser;
delivery.weight = weight;
delivery.width = width;
delivery.delivery_type = delivery_type;
delivery.remarks =remarks ;
delivery.goods_type = goods_type;
delivery.customer = customer;
// cc.city = city;
// cc.cid = code;
// cc.cname = companyname;
// cc.contact_person = contact;
// cc.createDate = DateTime.Now;
// cc.ctype = "normal";
// cc.customer = customer;
// cc.district = district;
// cc.tel = tel;
// cc.isDeleted = false;
// cc.mobile = mobile;
//// cc.remarks = remarks;
// cc.street1 = street1;
// cc.street2 = street2;
// cc.street3 = street3;
// service.addCustomerContact(cc, user);
// delivery.contact = cc;
service.addDelivery(delivery, user);
}
List<CustomerContact> customercontacts = new List<CustomerContact>(); //1.1
if (Session["customercontacts"] != null) //1.1
customercontacts = Session["customercontacts"] as List<CustomerContact>;//1.1
foreach (var cc in customercontacts)
{
cc.deliveryid = delivery.objectId;
service.addCustomerContact(cc, user);
if (delivery != null)
{
if (delivery.customer != null && delivery.customer.objectId != customer.objectId)
{
delivery.customer = customer;
service.updateDelivery(delivery, user);
}
}
}
Session["customercontacts"] = null;
return Content("{success:true,result:\"successfully !\",objectid:" + delivery.objectId + "}");
}
catch (Exception ex)
{
return Content("{success:false,result:\"" + ex.Message + "\",objectid:" + 0 + "}");
}
}
private List<Delivery> getQueryResult(SqlCommand cmd)
{
DbDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
// IPrintItemDAO printItemDAO = DAOFactory.getInstance().createPrintJobDAO();
IUserDAO userDAO = DAOFactory.getInstance().createUserDAO();
ICustomerContactDAO contactDAO = DAOFactory.getInstance().createCustomerContactDAO();
ICustomerDAO customerDAO = DAOFactory.getInstance().createCustomerDAO();
List<Delivery> deliveries = new List<Delivery>();
Delivery delivery = null;
dt.Load(reader);
reader.Close();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
delivery = new Delivery();
delivery.objectId = getInt(dt.Rows[i]["ObjectId"]);
delivery.createDate = getDateTime(dt.Rows[i]["CreateDate"]);
delivery.updateDate = getDateTime(dt.Rows[i]["UpdateDate"]);
delivery.updateBy = getString(dt.Rows[i]["UpdateBy"]);
delivery.isDeleted = (getInt(dt.Rows[i]["IsDeleted"]) == 1);
delivery.assigned_by = userDAO.get(getInt(dt.Rows[i]["assigned_by"]), cmd.Transaction);
delivery.contact = contactDAO.get(getInt(dt.Rows[i]["contact"]), cmd.Transaction);
delivery.deadline = getDateTime(dt.Rows[i]["deadline"]);
delivery.delivery_type = getString(dt.Rows[i]["delivery_type"]);
delivery.handled_by = userDAO.get(getInt(dt.Rows[i]["handled_by"]), cmd.Transaction);
delivery.height = getString(dt.Rows[i]["height"]);
delivery.length = getString(dt.Rows[i]["length"]);
delivery.non_order = getString(dt.Rows[i]["non_order_num"]);
delivery.notes = getString(dt.Rows[i]["notes"]);
delivery.number = getString(dt.Rows[i]["number"]);
delivery.part_no = getString(dt.Rows[i]["part_no"]);
delivery.requested_by = userDAO.get(getInt(dt.Rows[i]["requested_by"]), cmd.Transaction);
delivery.status = getString(dt.Rows[i]["status"]);
delivery.weight = getString(dt.Rows[i]["weight"]);
delivery.width = getString(dt.Rows[i]["width"]);
delivery.remarks = getString(dt.Rows[i]["remarks"]);
delivery.goods_type = getString(dt.Rows[i]["goods_type"]);
delivery.customer = customerDAO.getByID(getInt(dt.Rows[i]["cid"]), cmd.Transaction);
deliveries.Add(delivery);
}
}
return deliveries;
}
public bool delete(Delivery delivery, System.Data.Common.DbTransaction transaction)
{
IFPObjectDAO fpObjectDAO = DAOFactory.getInstance().createFPObjectDAO();
return fpObjectDAO.delete(delivery, transaction);
}
internal static string getDeliveryJson(Delivery delivery)
{
if (delivery == null)
delivery = new Delivery();
if (delivery.customer == null)
delivery.customer = new Customer();
if (delivery.handled_by == null)
delivery.handled_by = new UserAC();
if (delivery.requested_by == null)
delivery.requested_by = new UserAC();
StringBuilder deliveryJson = new StringBuilder();
deliveryJson.Append("{").Append("objectid:'").Append(delivery.objectId.ToString()).Append("',")
.Append("customerid:'").Append(delivery.customer.objectId.ToString ()).Append("',")
.Append("company_code:'").Append(delivery.customer.company_code == null ? string.Empty : delivery.customer.company_code.ToString().Replace("'", "\\\'")).Append("',")
.Append("company_name:'").Append(delivery.customer.company_name == null ? string.Empty : filter(delivery.customer.company_name.ToString())).Append("',")
.Append("number:'").Append(delivery.number.ToString()).Append("',")
.Append("district:'").Append(delivery.contact.district == null ? string.Empty : delivery.contact.district.ToString()).Append("',")
.Append("delivery_type:'").Append(delivery.delivery_type == null ? string.Empty : delivery.delivery_type.ToString()).Append("',")
.Append("date:'").Append(delivery.deadline == null ? string.Empty : delivery.deadline.Value.ToShortDateString()).Append("',")
.Append("time:'").Append(delivery.deadline == null ? string.Empty : delivery.deadline.Value.ToShortTimeString()).Append("',")
.Append("handledby:'").Append(delivery.handled_by.eng_name == null ? string.Empty : delivery.handled_by.eng_name.ToString()).Append("',")
.Append("partno:'").Append(delivery.part_no == null ? string.Empty : delivery.part_no.ToString()).Append("',")
.Append("nonorder:'").Append(delivery.non_order == null ? string.Empty : delivery.non_order.ToString()).Append("',")
.Append("length:'").Append(delivery.length == null ? string.Empty : delivery.length.ToString()).Append("',")
.Append("width:'").Append(delivery.width == null ? string.Empty : delivery.width.ToString()).Append("',")
.Append("goods_type:'").Append(delivery.goods_type == null ? string.Empty : delivery.goods_type.ToString()).Append("',")
.Append("height:'").Append(delivery.height == null ? string.Empty : delivery.height.ToString()).Append("',")
.Append("weight:'").Append(delivery.weight == null ? string.Empty : delivery.weight.ToString()).Append("',")
.Append("street1:'").Append(delivery.contact.street1 == null ? string.Empty : delivery.contact.street1.ToString().Replace("'", "\\\'").Replace ("\n","").Replace ("\r","")).Append("',")
.Append("street2:'").Append(delivery.contact.street2 == null ? string.Empty : delivery.contact.street2.ToString().Replace("'", "\\\'").Replace("\n", "").Replace("\r", "")).Append("',")
.Append("street3:'").Append(delivery.contact.street3 == null ? string.Empty : delivery.contact.street3.ToString().Replace("'", "\\\'").Replace("\n", "").Replace("\r", "")).Append("',")
.Append("city:'").Append(delivery.contact.city == null ? string.Empty : delivery.contact.city.ToString()).Append("',")
.Append("tel:'").Append(delivery.contact.tel == null ? string.Empty : delivery.contact.tel.ToString()).Append("',")
.Append("mobile:'").Append(delivery.contact.mobile == null ? string.Empty : delivery.contact.mobile.ToString()).Append("',")
.Append("contact:'").Append(delivery.contact.contact_person == null ? string.Empty : delivery.contact.contact_person.ToString()).Append("',")
.Append("remark:'").Append(filter(delivery.remarks == null ? string.Empty : delivery.remarks.ToString().Replace ("'","\\\\'").Replace ("\n","\\n").Replace ("\r","\\r"))).Append("',")
.Append("requestby:'").Append(delivery.requested_by == null ? string.Empty : delivery.requested_by.objectId.ToString()).Append("',")
.Append("handledbyid:'").Append(delivery.handled_by == null ? string.Empty : delivery.handled_by.objectId.ToString()).Append("',")
.Append("deadline:'").Append(delivery.deadline == null ? string.Empty : delivery.deadline.Value.ToString("yyyy-MM-dd")).Append("',")
.Append("notes:'").Append(delivery.notes == null ? string.Empty : delivery.notes.ToString().Replace("'", "\\\\'").Replace("\n", "\\n").Replace("\r", "\\r")).Append("',")
.Append("status:'").Append(delivery.status == null ? string.Empty : delivery.status.ToString()).Append("'}");
return deliveryJson.ToString();
}
