public static DataTable Subscription_GetAllByFinancialYear(Entity.Subscription subscription)
{
using (DataManager oDm = new DataManager())
{
if (subscription.MemberId == 0)
{
oDm.Add("@MemberId_FK", SqlDbType.Int, ParameterDirection.Input, DBNull.Value);
}
else
{
oDm.Add("@MemberId_FK", SqlDbType.Int, ParameterDirection.Input, subscription.MemberId);
}
oDm.Add("@FinancialYearId_FK", SqlDbType.Int, ParameterDirection.Input, subscription.FinancialYearId);
if (subscription.Status == 2)
{
oDm.Add("@Status", SqlDbType.Bit, DBNull.Value);
}
else
{
oDm.Add("@Status", SqlDbType.Bit, subscription.Status);
}
oDm.CommandType = CommandType.StoredProcedure;
return(oDm.ExecuteDataTable("usp_Subscription_GetAllByFinancialYear"));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
BusinessLayer.Subscription objSubscription = new BusinessLayer.Subscription();
Entity.Subscription subscription = new Entity.Subscription();
subscription.SubscriptionId = SubscriptionId;
subscription.FinancialYearId = int.Parse(ddlYear.SelectedValue);
subscription.MemberId = int.Parse(ddlMember.SelectedValue);
subscription.Amount = decimal.Parse(txtAmount.Text);
subscription.EntryDate = DateTime.Parse(txtEntryDate.Text);
subscription.Narration = txtNarration.Text.Trim();
subscription.CreatedBy = Session["UserId"].ToString();
subscription.MRNo = txtMrNo.Text.Trim();
int i = objSubscription.Subscription_Save(subscription);
if (i > 0)
{
LoadSubscriptionList();
ltrMsg.Text = "Saved successfully...";
//SendNewSubscriptionAlert(ddlYear.SelectedItem.ToString(), ddlMember.SelectedItem.ToString(), txtAmount.Text);
ClearControls();
}
else
{
ltrMsg.Text = "Sorry! can not save.";
}
}
catch
{
ltrMsg.Text = "Sorry! can not save.";
}
}
public static int Subscription_Save(Entity.Subscription subscription)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@SubscriptionId", SqlDbType.BigInt, ParameterDirection.Input, subscription.SubscriptionId);
oDm.Add("@MemberId_FK", SqlDbType.Int, ParameterDirection.Input, subscription.MemberId);
oDm.Add("@FinancialYearId_FK", SqlDbType.Int, ParameterDirection.Input, subscription.FinancialYearId);
oDm.Add("@Amount", SqlDbType.Decimal, ParameterDirection.Input, subscription.Amount);
oDm.Add("@EntryDate", SqlDbType.DateTime, ParameterDirection.Input, subscription.EntryDate);
oDm.Add("@Narration", SqlDbType.VarChar, 500, ParameterDirection.Input, subscription.Narration);
oDm.Add("@CreatedBy", SqlDbType.VarChar, 50, ParameterDirection.Input, subscription.CreatedBy);
oDm.Add("@MRNo", SqlDbType.VarChar, 50, ParameterDirection.Input, subscription.MRNo);
oDm.CommandType = CommandType.StoredProcedure;
return(oDm.ExecuteNonQuery("usp_Subscription_Save"));
}
}
protected void LoadSubscriptionList()
{
BusinessLayer.Subscription objSubscription = new BusinessLayer.Subscription();
Entity.Subscription subscription = new Entity.Subscription();
DataTable dt = new DataTable();
subscription.MemberId = int.Parse(ddlMember.SelectedValue);
subscription.FinancialYearId = 0;
subscription.EntryDate = (!String.IsNullOrEmpty(txtTransactionFromDate.Text)) ? Convert.ToDateTime(txtTransactionFromDate.Text) : DateTime.MinValue;
subscription.EntryDateTo = (!String.IsNullOrEmpty(txtTransactionToDate.Text)) ? Convert.ToDateTime(txtTransactionToDate.Text) : DateTime.MinValue;
subscription.Status = Convert.ToInt32(ddlStatus.SelectedValue);
subscription.MobileNo = "";
dt = objSubscription.Subscription_GetAll(subscription);
if (dt != null)
{
dgvSubscriptionList.DataSource = dt;
dgvSubscriptionList.DataBind();
}
}
protected void LoadSubscriptionList()
{
BusinessLayer.Subscription objSubscription = new BusinessLayer.Subscription();
Entity.Subscription subscription = new Entity.Subscription();
DataTable dt = new DataTable();
subscription.MemberId = int.Parse(ddlMember.SelectedValue);
subscription.FinancialYearId = int.Parse(ddlYear.SelectedValue);
subscription.EntryDate = DateTime.MinValue;
subscription.EntryDateTo = DateTime.MinValue;
subscription.Status = Convert.ToInt32(ddlStatus.SelectedValue);
subscription.MobileNo = txtMobNo.Text;
subscription.BlockName = ddlBlock.SelectedItem.Text;
subscription.Amount = (txtAmount.Text == "") ? 0 : Convert.ToDecimal(txtAmount.Text);
dt = objSubscription.Subscription_GetAll(subscription);
if (dt != null)
{
dgvSubscriptionList.DataSource = dt;
dgvSubscriptionList.DataBind();
}
}
public static DataTable Subscription_GetAll(Entity.Subscription subscription)
{
using (DataManager oDm = new DataManager())
{
if (subscription.MemberId == 0)
{
oDm.Add("@MemberId_FK", SqlDbType.Int, ParameterDirection.Input, DBNull.Value);
}
else
{
oDm.Add("@MemberId_FK", SqlDbType.Int, ParameterDirection.Input, subscription.MemberId);
}
if (subscription.FinancialYearId == 0)
{
oDm.Add("@FinancialYearId_FK", SqlDbType.Int, ParameterDirection.Input, DBNull.Value);
}
else
{
oDm.Add("@FinancialYearId_FK", SqlDbType.Int, ParameterDirection.Input, subscription.FinancialYearId);
}
if (subscription.EntryDate == DateTime.MinValue)
{
oDm.Add("@EntryDateFrom", SqlDbType.DateTime, ParameterDirection.Input, DBNull.Value);
}
else
{
oDm.Add("@EntryDateFrom", SqlDbType.DateTime, ParameterDirection.Input, subscription.EntryDate);
}
if (subscription.EntryDateTo == DateTime.MinValue)
{
oDm.Add("@EntryDateTo", SqlDbType.DateTime, ParameterDirection.Input, DBNull.Value);
}
else
{
oDm.Add("@EntryDateTo", SqlDbType.DateTime, ParameterDirection.Input, subscription.EntryDateTo);
}
if (subscription.Status == 2)
{
oDm.Add("@Status", SqlDbType.Bit, DBNull.Value);
}
else
{
oDm.Add("@Status", SqlDbType.Bit, subscription.Status);
}
if (subscription.MobileNo.Trim().Length == 0)
{
oDm.Add("@MobileNo", SqlDbType.VarChar, 10, DBNull.Value);
}
else
{
oDm.Add("@MobileNo", SqlDbType.VarChar, 10, subscription.MobileNo);
}
if (subscription.BlockName == "--SELECT--")
{
oDm.Add("@BlockName", SqlDbType.VarChar, 250, DBNull.Value);
}
else
{
oDm.Add("@BlockName", SqlDbType.VarChar, 250, subscription.BlockName);
}
if (subscription.Amount == 0)
{
oDm.Add("@Amount", SqlDbType.Decimal, DBNull.Value);
}
else
{
oDm.Add("@Amount", SqlDbType.Decimal, subscription.Amount);
}
oDm.CommandType = CommandType.StoredProcedure;
return(oDm.ExecuteDataTable("usp_Subscription_GetAll"));
}
}
public DataTable Subscription_GetAllByFinancialYear(Entity.Subscription subscription)
{
return(DataAccess.Subscription.Subscription_GetAllByFinancialYear(subscription));
}
public DataTable Subscription_GetAll(Entity.Subscription subscription)
{
return(DataAccess.Subscription.Subscription_GetAll(subscription));
}
public int Subscription_Save(Entity.Subscription subscription)
{
return(DataAccess.Subscription.Subscription_Save(subscription));
}
