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