public string UpdateToApprove(string uid, string username, string newStatus) { //Checking permission before update status //Open => Approved By CM => Approved By F&B (Order(Converted) or Reject or Classify) => To be Deleted POWaitingForApproveDataContext db = new POWaitingForApproveDataContext(); try { string lichsu = ""; POWaitingForApprove r = db.POWaitingForApproves.SingleOrDefault(u => u.UID.ToString() == uid); if (r == null) { return("Object cannot be found"); } lichsu = r.ChangeLog; string status_before_update = r.Status; if (r.Converted == false) { if (r.Status == "Open" && newStatus == "Approved By CM") { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Status: {2}->{3}.\n", DateTime.Now, username, r.Status, newStatus) + lichsu; r.Status = newStatus; r.ChangeLog = lichsu; db.SubmitChanges(); return(string.Format("{0}: Change status {1} -> {2}", r.No, status_before_update, newStatus)); } else if (r.Status == "Approved By CM" && newStatus == "Approved By F&B") { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Status: {2}->{3}.\n", DateTime.Now, username, r.Status, newStatus) + lichsu; r.Status = newStatus; r.ChangeLog = lichsu; db.SubmitChanges(); return(string.Format("{0}: Change status {1} -> {2}", r.No, status_before_update, newStatus)); } else { return("You cannot do this action"); } } else { return("Converted equal true, you cannot update!"); } } catch (Exception ex) { return(ex.Message); } }
public string InsertComment(string uid, string commentText, string username) { POWaitingForApproveDataContext db = new POWaitingForApproveDataContext(); POWaitingForApprove r = db.POWaitingForApproves.SingleOrDefault(p => p.UID.ToString().Equals(uid)); if (r == null) { return("Object cannot be found"); } string lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} add comment: {2}.\n", DateTime.Now, username, commentText) + r.Comment; r.Comment = lichsu; db.SubmitChanges(); return(""); }
public string UpdateConverted(string uid, string convertType, string username) { POWaitingForApproveDataContext db = new POWaitingForApproveDataContext(); try { string lichsu = ""; POWaitingForApprove r = db.POWaitingForApproves.SingleOrDefault(u => u.UID.ToString() == uid); if (r == null) { return("Object cannot be found"); } lichsu = r.ChangeLog; if (r.Converted == false) { if (r.Status == "Approved By F&B") { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Converted: {2}->{3}.\n", DateTime.Now, username, r.Converted, "True") + lichsu; r.Converted = true; r.ConvertType = convertType; r.Status = "Completed"; r.ChangeLog = lichsu; db.SubmitChanges(); return(string.Format("{0}: Converted to {1}", r.No, convertType)); } else { return("You cannot do this action"); } } else { return("Converted equal true, you cannot update!"); } } catch (Exception ex) { return(ex.Message); } }
public string TobeDeleted(string uid, string username, string newStatus) { POWaitingForApproveDataContext db = new POWaitingForApproveDataContext(); try { POWaitingForApprove r = db.POWaitingForApproves.SingleOrDefault(u => u.UID.ToString() == uid); if (r == null) { return("Object cannot be found"); } string lichsu = r.ChangeLog; if (r.Converted == false) { if (r.Status == "Open") { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Status: {2}->{3}.\n", DateTime.Now, username, r.Status, newStatus) + lichsu; r.Status = newStatus; r.ChangeLog = lichsu; db.SubmitChanges(); return(""); } else { return("You cannot do this action"); } } else { return("Converted equal true, you cannot delete!"); } } catch (Exception ex) { return(ex.Message); } }
public string UpdateData(string uid, data_POWaitingForApprove data, string username) { POWaitingForApproveDataContext db = new POWaitingForApproveDataContext(); bool isAddNew = uid == ""; string lichsu = ""; POWaitingForApprove dt; if (isAddNew && true) { dt = new POWaitingForApprove(); dt.UID = Guid.NewGuid(); dt.CreatedBy = username; dt.CreatedOn = DateTime.Now; lichsu = string.Format("{0:dd/MM/yyyy hh:mm:ss}: Create by {1}.\n", DateTime.Now, username); db.POWaitingForApproves.InsertOnSubmit(dt); } else { dt = db.POWaitingForApproves.SingleOrDefault(p => p.UID.ToString().Equals(uid)); if (dt == null) { return("Object cannot be found"); } else { lichsu = dt.ChangeLog; } } if (dt.Batch != data.Batch) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Batch: {2}->{3}.\n", DateTime.Now, username, dt.Batch, data.Batch) + lichsu; dt.Batch = data.Batch; } if (dt.No != data.No) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change No: {2}->{3}.\n", DateTime.Now, username, dt.No, data.No) + lichsu; dt.No = data.No; } if (dt.Type != data.Type) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Type: {2}->{3}.\n", DateTime.Now, username, dt.Type, data.Type) + lichsu; dt.Type = data.Type; } if (dt.Action_Message != data.Action_Message) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Action_Message: {2}->{3}.\n", DateTime.Now, username, dt.Action_Message, data.Action_Message) + lichsu; dt.Action_Message = data.Action_Message; } if (dt.Accept_Action_Message != data.Accept_Action_Message) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Accept_Action_Message: {2}->{3}.\n", DateTime.Now, username, dt.Accept_Action_Message, data.Accept_Action_Message) + lichsu; dt.Accept_Action_Message = data.Accept_Action_Message; } if (dt.Description != data.Description) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Description: {2}->{3}.\n", DateTime.Now, username, dt.Description, data.Description) + lichsu; dt.Description = data.Description; } if (dt.Remark != data.Remark) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Remark: {2}->{3}.\n", DateTime.Now, username, dt.Remark, data.Remark) + lichsu; dt.Remark = data.Remark; } if (dt.Location_Code != data.Location_Code) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Location_Code: {2}->{3}.\n", DateTime.Now, username, dt.Location_Code, data.Location_Code) + lichsu; dt.Location_Code = data.Location_Code; } if (dt.Original_Quantity != data.Original_Quantity) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Original_Quantity: {2}->{3}.\n", DateTime.Now, username, dt.Original_Quantity, data.Original_Quantity) + lichsu; dt.Original_Quantity = data.Original_Quantity; } if (dt.Quantity != data.Quantity) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Quantity: {2}->{3}.\n", DateTime.Now, username, dt.Quantity, data.Quantity) + lichsu; dt.Quantity = data.Quantity; } if (dt.Unit_of_Measure_Code != data.Unit_of_Measure_Code) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Unit_of_Measure_Code: {2}->{3}.\n", DateTime.Now, username, dt.Unit_of_Measure_Code, data.Unit_of_Measure_Code) + lichsu; dt.Unit_of_Measure_Code = data.Unit_of_Measure_Code; } if (dt.Direct_Unit_Cost != data.Direct_Unit_Cost) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Direct_Unit_Cost: {2}->{3}.\n", DateTime.Now, username, dt.Direct_Unit_Cost, data.Direct_Unit_Cost) + lichsu; dt.Direct_Unit_Cost = data.Direct_Unit_Cost; } if (dt.Due_Date != data.Due_Date) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Due_Date: {2}->{3}.\n", DateTime.Now, username, dt.Due_Date, data.Due_Date) + lichsu; dt.Due_Date = data.Due_Date; } if (dt.Vendor_No != data.Vendor_No) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Vendor_No: {2}->{3}.\n", DateTime.Now, username, dt.Vendor_No, data.Vendor_No) + lichsu; dt.Vendor_No = data.Vendor_No; } if (dt.Vendor_Item_No != data.Vendor_Item_No) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Vendor_Item_No: {2}->{3}.\n", DateTime.Now, username, dt.Vendor_Item_No, data.Vendor_Item_No) + lichsu; dt.Vendor_Item_No = data.Vendor_Item_No; } if (dt.Replenishment_System != data.Replenishment_System) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Replenishment_System: {2}->{3}.\n", DateTime.Now, username, dt.Replenishment_System, data.Replenishment_System) + lichsu; dt.Replenishment_System = data.Replenishment_System; } if (dt.Status != data.Status) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Status: {2}->{3}.\n", DateTime.Now, username, dt.Status, data.Status) + lichsu; dt.Status = data.Status; } //Insert/ Update khong insert du lieu comment. //if (dt.Comment != data.Comment) //{ // lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Comment: {2}->{3}.\n", // DateTime.Now, username, dt.Comment, data.Comment) + lichsu; // dt.Comment = data.Comment; //} if (dt.ConvertType != data.ConvertType) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change ConvertType: {2}->{3}.\n", DateTime.Now, username, dt.ConvertType, data.ConvertType) + lichsu; dt.ConvertType = data.ConvertType; } if (dt.Converted != data.Converted) { lichsu = String.Format("{0:dd/MM/yyyy hh:mm:ss}: {1} Change Converted: {2}->{3}.\n", DateTime.Now, username, dt.Converted, data.Converted) + lichsu; dt.Converted = data.Converted; } dt.UpdatedBy = username; dt.UpdatedOn = DateTime.Now; dt.ChangeLog = lichsu; db.SubmitChanges(); return(dt.UID.ToString()); }