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