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