protected void QuarterNumber_change(object sender, EventArgs e) { tblAllottee _allotte = Allottee.GetAllottee(txtQuarterNumber.Text); if (_allotte != null) { tblUser _user = Users.getUserByAAN(_allotte.AAN); if (_user.designation.HasValue) { drpDesignation.SelectedValue = _user.designation.Value.ToString(); } if (_user.BaseOfficeId.HasValue) { drpOffice.SelectedValue = _user.BaseOfficeId.Value.ToString(); } txtAllotteeAAN.Text = _allotte.AAN; txtUserName.Text = _user.fullName; drpQuarterCatergory.SelectedValue = _allotte.tblQuarter.tblQuarterCategory.Id.ToString(); tblQuarterCategoryFee fee = LicenceFee.GetQuarterCategeryFee(_allotte.tblQuarter.tblQuarterCategory.Id); if (fee != null && fee.LicenceFee.HasValue) { txtLicenceFee.Text = fee.LicenceFee.Value.ToString(); } } else { lblmessage.Text = "This quarter is not allotted to anyone yet"; lblmessage.Visible = true; btnAddUpdate.Enabled = false; } }
protected void QuarterCategory_selectedindex(object sender, EventArgs e) { tblQuarterCategoryFee o = LicenceFee.GetQuarterCategeryFee(Convert.ToInt64(drpQuarterCat.SelectedValue)); if (o != null) { if (o.LicenceFee.HasValue) { txtLicenceFee.Text = o.LicenceFee.Value.ToString(); } } }
public static decimal GetLicenceFeebyCategory(long category) { DataClassesDataContext dataContext = new DataClassesDataContext(); var varlicFee = from iLicenceFee in dataContext.tblQuarterCategoryFees where iLicenceFee.QuarterCategoryId == category select iLicenceFee; tblQuarterCategoryFee val = varlicFee.FirstOrDefault(); if (val != null && val.LicenceFee.HasValue) { return(Convert.ToDecimal(val.LicenceFee)); } return(0); }
public static void Save(tblQuarterCategoryFee licFee) { DataClassesDataContext dataContext = new DataClassesDataContext(); var varlicFee = from iLicenceFee in dataContext.tblQuarterCategoryFees where iLicenceFee.QuarterCategoryId == licFee.QuarterCategoryId select iLicenceFee; tblQuarterCategoryFee oLicenceFee = varlicFee.FirstOrDefault(); if (oLicenceFee != null) { oLicenceFee.EffectiveDate = licFee.EffectiveDate; oLicenceFee.QuarterCategoryId = licFee.QuarterCategoryId; //oLicenceFee.Month = licFee.Month; oLicenceFee.LicenceFee = licFee.LicenceFee; //oLicenceFee.LastUpdatedBy = licFee.LastUpdatedBy; //oLicenceFee.LastUpdatedDate = DateTime.Now; } if (oLicenceFee == null) { dataContext.tblQuarterCategoryFees.InsertOnSubmit(licFee); } dataContext.SubmitChanges(); }
protected void btnadd_Click(object sender, EventArgs e) { tblQuarterCategoryFee categoryfee = new tblQuarterCategoryFee(); //categoryfee.LastUpdatedBy = 1; //categoryfee.Month = Convert.ToDateTime(txtmonth.Text); categoryfee.QuarterCategoryId = Convert.ToInt32(drpQuarterCat.SelectedValue); categoryfee.LicenceFee = Convert.ToDouble(txtLicenceFee.Text); categoryfee.EffectiveDate = Convert.ToDateTime(txtEffectiveDate.Text); LicenceFee.Save(categoryfee); tbluserhistory _userhistory = new tbluserhistory(); _userhistory.Action = "Licence fee"; //_userhistory.description = _user.Username + " has added Licence fee for quarter category " + categoryfee.tblQuarterCategory.Name; // Quartercategory name is selected from the drop down, not from database table.. _userhistory.description = _user.Username + " has added Licence fee for quarter category " + drpQuarterCat.SelectedItem.Text; _userhistory.time = DateTime.Now; _userhistory.useraan = _user.AAN; userHistory.Save(_userhistory); lblmessage.Visible = true; lblmessage.Text = "Information saved successfully!"; }