public bool Update(BusinessTrip obj) { try { _db.SubmitChanges(); } catch (Exception ex) { Debug.Print(ex.Message); return(false); } return(true); }
//public void SetDelete(int businessTripId) //{ // var query = _db.BusinessTrips.FirstOrDefault(x => x.BusinessTripId == businessTripId); // if (query != null) // { // _db.BusinessTrips.DeleteOnSubmit(query); // var query1 = _db.BusinessTripFlights.FirstOrDefault(x => x.BusinessTripId == businessTripId); // var query2 = _db.BusinessTripAccoms.FirstOrDefault(x => x.BusinessTripId == businessTripId); // var query3 = _db.BusinessTripCashes.FirstOrDefault(x => x.BusinessTripId == businessTripId); // if (query1 != null) // _db.BusinessTripFlights.DeleteOnSubmit(query1); // if (query2 != null) // _db.BusinessTripAccoms.DeleteOnSubmit(query2); // if (query3 != null) // _db.BusinessTripCashes.DeleteOnSubmit(query3); // _db.SubmitChanges(); // } //} public int Add(BusinessTrip obj) { try { _db.BusinessTrips.InsertOnSubmit(obj); _db.SubmitChanges(); } catch (Exception ex) { Debug.Print(ex.Message); return(-1); } return(_db.BusinessTrips.Max(x => x.BusinessTripId)); }
protected void RadToolBar1_ButtonClick(object sender, RadToolBarEventArgs e) { // Save if (e.Item.Text == "TempSave" || e.Item.Text == "Request") { if (IsValid) { var cObj = new CBusinessTrip(); var obj = cObj.Get(Id); // new one if (obj == null) { obj = new Erp2016.Lib.BusinessTrip(); obj.CreatedId = Convert.ToInt32(CurrentUserId); obj.CreatedDate = DateTime.Now; int newIndex = Convert.ToInt32(cObj.Add(obj).ToString()); obj = cObj.Get(newIndex); ViewState["NewIndex"] = newIndex; } else { obj.UpdatedId = Convert.ToInt32(CurrentUserId); obj.UpdatedDate = DateTime.Now; ViewState["NewIndex"] = obj.BusinessTripId.ToString(); } obj.ApprovalId = CurrentUserId; obj.ApprovalDate = DateTime.Now; if (e.Item.Text == "TempSave") { obj.ApprovalStatus = null; } else { var cApprovalHistory = new CApprovalHistory(); cApprovalHistory.DelApprovalHistory((int)CConstValue.Approval.BusinessTrip, Convert.ToInt32(ViewState["NewIndex"])); // approve request var approval = new CApproval(); var approvalResult = approval.ApproveRequstCreate((int)CConstValue.Approval.BusinessTrip, CurrentUserId, Convert.ToInt32(ViewState["NewIndex"])); if (approvalResult > 0) { obj.ApprovalStatus = approvalResult; } else { ShowMessage("Failed"); return; } // mail new CMail().SendMail(CConstValue.Approval.BusinessTrip, CConstValue.MailStatus.ToApproveUser, Convert.ToInt32(ViewState["NewIndex"]), string.Empty, CurrentUserId); } obj.Type = RadButtonLocal.Checked ? RadButtonLocal.Text : RadButtonOverseas.Text; obj.AirSub = Convert.ToDecimal(GetAirRate().Value); obj.AccomSub = Convert.ToDecimal(GetAccomRate().Value); obj.GroundSub = Convert.ToDecimal(GetGroundRate().Value); obj.MealsSub = Convert.ToDecimal(GetMealsRate().Value); obj.CashSub = Convert.ToDecimal(GetCashAdvanceTotal().Value); obj.GrandSub = Convert.ToDecimal(RadNumericTextBoxGrandTotal.Value); cObj.Update(obj); // save uploading file FileDownloadList1.SaveFile(Convert.ToInt32(ViewState["NewIndex"])); // save other tables RunClientScript("SaveChanges();"); } } // Revise else if (e.Item.Text == "Revise") { RunClientScript("ShowApprovalReviseWindow('" + Id + "');"); } // Approval else if (e.Item.Text == "Approve") { RunClientScript("ShowApprovalWindow('" + Id + "');"); } // Reject else if (e.Item.Text == "Reject") { RunClientScript("ShowApprovalRejectWindow('" + Id + "');"); } // Accept else if (e.Item.Text == "Accept") { RunClientScript("ShowApprovalAcceptWindow('" + Id + "');"); } // Complete else if (e.Item.Text == "Complete") { RunClientScript("ShowApprovalCompleteWindow('" + Id + "');"); } // Cancel else if (e.Item.Text == "Cancel") { RunClientScript("ShowApprovalCancelWindow('" + Id + "');"); } // Print else if (e.Item.Text == "Print") { RunClientScript("ShowPrint();"); } // close else if (e.Item.Text == "Close") { RunClientScript("Close();"); } }