public int Add(Scholarship obj) { try { var nowYear = DateTime.Now.ToString("yy"); var last = (from q in _db.Scholarships where q.ScholarshipMasterNo.Substring(0, 2) == nowYear orderby q.ScholarshipIndex descending select q).FirstOrDefault(); if (last == null) { obj.ScholarshipIndex = 1; } else { obj.ScholarshipIndex = last.ScholarshipIndex + 1; } obj.ScholarshipMasterNo = nowYear + '-' + new Random().Next(9999).ToString("D4") + '-' + obj.ScholarshipIndex.ToString("D6"); obj.CreatedDate = DateTime.Now; _db.Scholarships.InsertOnSubmit(obj); _db.SubmitChanges(); } catch (Exception ex) { Debug.Print(ex.Message); return(-1); } return(_db.Scholarships.Max(x => x.ScholarshipId)); }
public bool Update(Scholarship obj) { try { _db.SubmitChanges(); } catch (Exception ex) { Debug.Print(ex.Message); return(false); } return(true); }
//protected void LoadSite() //{ // var global = new CGlobal(); // RadComboBoxSite.DataSource = global.GetSiteId(); // RadComboBoxSite.DataTextField = "Name"; // RadComboBoxSite.DataValueField = "Value"; // RadComboBoxSite.DataBind(); // RadComboBoxSite.Items.Insert(0, new RadComboBoxItem("- Select Site - ")); //} protected void StudentButtonClicked(object sender, RadToolBarEventArgs e) { switch (e.Item.Text) { case "TempSave": case "Request": var cScholarshipReg = new CScholarship(); var scholarshipReg = new Erp2016.Lib.Scholarship(); // new if (Request["type"] == "0") { scholarshipReg = new Erp2016.Lib.Scholarship(); scholarshipReg.CreatedId = CurrentUserId; scholarshipReg.CreatedDate = DateTime.Now; } // modify else { scholarshipReg = cScholarshipReg.Get(Id); } scholarshipReg.AgencyId = Convert.ToInt32(ddlAgencyName.SelectedValue); if (rbAmount.Checked) { scholarshipReg.Amount = Convert.ToDecimal(RadNumericTextBoxAmount.Text == string.Empty ? "0" : RadNumericTextBoxAmount.Text); } if (rbWeeks.Checked) { scholarshipReg.Weeks = Convert.ToInt32(tbWeeks.Text); } scholarshipReg.ExpireDate = Convert.ToDateTime(tbExpireDate.SelectedDate); scholarshipReg.MininumRegistrationWeeks = Convert.ToInt32(RadComboBoxMinimum.SelectedValue); scholarshipReg.Memo = tbComment.Text; scholarshipReg.CreatedId = CurrentUserId; scholarshipReg.IsActive = false; int scholarshipId; // new if (Request["type"] == "0") { scholarshipReg.IsActive = false; scholarshipId = cScholarshipReg.Add(scholarshipReg); } // modify else { scholarshipReg.UpdatedId = CurrentUserId; scholarshipReg.UpdatedDate = DateTime.Now; cScholarshipReg.Update(scholarshipReg); scholarshipId = scholarshipReg.ScholarshipId; } var cScholarshipSiteLocation = new CScholarshipSiteLocation(); cScholarshipSiteLocation.DelScholarshipSiteLocation(scholarshipId); foreach (var siteLocation in RadComboBoxSiteLocation.CheckedItems) { var scholarshipSiteLocation = new ScholarshipSiteLocation() { CreatedId = CurrentUserId, ScholarshipId = scholarshipId, SiteLocationId = Convert.ToInt32(siteLocation.Value), CreatedDate = DateTime.Now }; cScholarshipSiteLocation.Add(scholarshipSiteLocation); } if (e.Item.Text == "TempSave") { RunClientScript("Close();"); } else { var cApprovalHistory = new CApprovalHistory(); cApprovalHistory.DelApprovalHistory((int)CConstValue.Approval.Scholarship, scholarshipId); var approval = new CApproval().ApproveRequstCreate((int)CConstValue.Approval.Scholarship, CurrentUserId, scholarshipId); if (approval > 0) { var cScholar = new CScholarship(); var scholar = cScholar.Get(scholarshipId); scholar.ApprovalStatus = approval; scholar.ApprovalId = CurrentUserId; scholar.ApprovalDate = DateTime.Now; cScholar.Update(scholar); new CMail().SendMail(CConstValue.Approval.Scholarship, CConstValue.MailStatus.ToApproveUser, scholar.ScholarshipId, scholar.ScholarshipMasterNo, CurrentUserId); RunClientScript("Close();"); } else { ShowMessage("error requesting"); } } break; case "Close": RunClientScript("Close();"); break; } }