protected void btnSave_Click(object sender, EventArgs e) { BusinessLayer.Common.MemberBill objBill = new BusinessLayer.Common.MemberBill(); Entity.Common.MemberBill bill = new Entity.Common.MemberBill(); bill.Month = Convert.ToInt32(ddlMonth.SelectedValue); bill.Year = Convert.ToInt32(ddlYear.SelectedValue); bill.MemberId = Convert.ToInt32(ddlMember.SelectedValue); bill.CreatedBy = Convert.ToInt32(Session["UserId"].ToString()); objBill.Generate(bill); Message.IsSuccess = true; Message.Text = "Bill Generated Successfully"; Message.Show = true; }
protected void btnSave_Click(object sender, EventArgs e) { BusinessLayer.Common.MemberBill objBill = new BusinessLayer.Common.MemberBill(); Entity.Common.MemberBill bill = new Entity.Common.MemberBill(); bill.Month = Convert.ToInt32(ddlFromMonth.SelectedValue); bill.MonthTo = Convert.ToInt32(ddlToMonth.SelectedValue); bill.Year = Convert.ToInt32(ddlYear.SelectedValue); bill.MemberId = Convert.ToInt32(ddlMember.SelectedValue); bill.CreatedBy = Convert.ToInt32(Session["UserId"].ToString()); bill.Amount = Convert.ToInt32(txtAmount.Text); //objBill.DevelopmentFeeGenerate(bill); objBill.RenewalFeeUpdate(bill); Message.IsSuccess = true; Message.Text = "Bill Updated Successfully"; Message.Show = true; //LoadDevelopmentFeeDetails(); }
public static bool CheckingDevelopmentFeeGeneration(Entity.Common.MemberBill bill) { using (DataManager oDm = new DataManager()) { oDm.Add("@Month", SqlDbType.Int, bill.Month); oDm.Add("@Year", SqlDbType.Int, bill.Year); oDm.CommandType = CommandType.StoredProcedure; DataTable dt = oDm.ExecuteDataTable("usp_DevelopmentFeeGeneration_Checking"); if (dt.Rows.Count > 5) { return(true); } else { return(false); } } }
private void GoDevelopmentFeeGenerate() { DateTime dateTime = DateTime.Now.AddHours(12).AddMinutes(30); Entity.Common.MemberBill bill = new Entity.Common.MemberBill(); bill.Month = dateTime.Month; bill.Year = dateTime.Year; bill.MemberId = 0; bill.CreatedBy = Convert.ToInt32(Session["UserId"].ToString()); //Int32.Parse(Context.User.Identity.Name); BusinessLayer.Common.MemberBill objBill = new BusinessLayer.Common.MemberBill(); bool IsGenerate = objBill.CheckingDevelopmentFeeGeneration(bill); if (IsGenerate == false) { objBill.DevelopmentFeeGenerate(bill); BusinessLayer.Common.FeeNotification notification = new BusinessLayer.Common.FeeNotification(); notification.MailToMember(); } }
public static void DevelopmentFeeGenerate(Entity.Common.MemberBill bill) { using (DataManager oDm = new DataManager()) { oDm.Add("@Month", SqlDbType.Int, bill.Month); oDm.Add("@Year", SqlDbType.Int, bill.Year); if (bill.MemberId != 0) { oDm.Add("@MemberId", SqlDbType.Int, bill.MemberId); } else { oDm.Add("@MemberId", SqlDbType.Int, DBNull.Value); } oDm.Add("@CreatedBy", SqlDbType.Int, bill.CreatedBy); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_MemberDevelopmentFee_Generate"); } }
public static void RenewalFeeUpdate(Entity.Common.MemberBill bill) { using (DataManager oDm = new DataManager()) { oDm.Add("@FromMonth", SqlDbType.Int, bill.Month); oDm.Add("@ToMonth", SqlDbType.Int, bill.MonthTo); oDm.Add("@Year", SqlDbType.Int, bill.Year); oDm.Add("@NewAmount", SqlDbType.Int, bill.Amount); if (bill.MemberId != 0) { oDm.Add("@MemberId", SqlDbType.Int, bill.MemberId); } else { oDm.Add("@MemberId", SqlDbType.Int, DBNull.Value); } oDm.Add("@CreatedBy", SqlDbType.Int, bill.CreatedBy); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_MemberRenewalFee_Update"); } }
public bool CheckingDevelopmentFeeGeneration(Entity.Common.MemberBill bill) { return(DataAccess.Common.MemberBill.CheckingDevelopmentFeeGeneration(bill)); }
public void RenewalFeeUpdate(Entity.Common.MemberBill bill) { DataAccess.Common.MemberBill.RenewalFeeUpdate(bill); }
public void DevelopmentFeeUpdate(Entity.Common.MemberBill bill) { DataAccess.Common.MemberBill.DevelopmentFeeUpdate(bill); }
public void Generate(Entity.Common.MemberBill bill) { DataAccess.Common.MemberBill.Generate(bill); }