protected void btnadd_Click(object sender, EventArgs e) { tblAllottee _allotte = Allottee.GetAllottee(txtQuarterNumber.Text); if (_allotte != null) { tbQuarterLicenceFee fee = new tbQuarterLicenceFee(); fee.AAN = _allotte.AAN; fee.ActualFee = 0; fee.Fee = Convert.ToDecimal(txtLicenceFee.Text); fee.Month = Convert.ToDateTime(txtMonth.Text); fee.QuarterId = _allotte.tblQuarter.Id; fee.ActualFee = LicenceFee.GetLicenceFeebyCategory(_allotte.tblQuarter.Category); fee.Remarks = txtRemarks.Text; LicenceFee.SaveMonthLicencefee(fee); lblmessage.Text = "Information saved sucessfully!"; lblmessage.Visible = true; empty(); tbluserhistory _userhistory = new tbluserhistory(); _userhistory.Action = "Licence fee"; _userhistory.description = _user.Username + " has added Licence fee for quarter " + _allotte.tblQuarter.QuarterNumber; _userhistory.time = DateTime.Now; _userhistory.useraan = _user.AAN; userHistory.Save(_userhistory); } else { lblmessage.Text = "This quarter is not allotted to anyone yet"; lblmessage.Visible = true; } }
protected void btnadd_Click(object sender, EventArgs e) { tblQuarter quarter = Quarters.GetQuarter(txtQuarterNumber.Text); if (quarter == null) { lblmessage.Text = "invalid quarter number!"; lblmessage.Visible = true; return; } tbQuarterLicenceFee fee = new tbQuarterLicenceFee(); fee.QuarterId = quarter.Id; decimal Lfee = 0; decimal.TryParse(txtLicenceFee.Text, out Lfee); fee.Fee = Lfee; DateTime dMonth; DateTime.TryParse(txtmonth.Text, out dMonth); if (dMonth == DateTime.MinValue) { lblmessage.Text = "invalid Date!"; lblmessage.Visible = true; return; } DataClassesDataContext datacontext = new DataClassesDataContext(); datacontext.tbQuarterLicenceFees.InsertOnSubmit(fee); datacontext.SubmitChanges(); }
public static void SaveMonthLicencefee(tbQuarterLicenceFee licFee) { DataClassesDataContext dataContext = new DataClassesDataContext(); var varlicFee = from iLicenceFee in dataContext.tbQuarterLicenceFees where iLicenceFee.Month.Value.Month == licFee.Month.Value.Month select iLicenceFee; tbQuarterLicenceFee oLicenceFee = varlicFee.FirstOrDefault(); if (oLicenceFee != null) { oLicenceFee.AAN = licFee.AAN; oLicenceFee.Month = licFee.Month; oLicenceFee.Fee = oLicenceFee.Fee + licFee.Fee; oLicenceFee.QuarterId = licFee.QuarterId; oLicenceFee.ActualFee = licFee.ActualFee; oLicenceFee.Remarks = licFee.Remarks; } if (oLicenceFee == null) { dataContext.tbQuarterLicenceFees.InsertOnSubmit(licFee); } dataContext.SubmitChanges(); }