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();");
}
}
