public static Entity.Accounts.OpeningBalanceMaster GetById(int OpBalId) { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; oDm.Add("@OpBalId", SqlDbType.Int, ParameterDirection.Input, OpBalId); SqlDataReader dr = oDm.ExecuteReader("usp_MstOpeningBalance_GetById"); Entity.Accounts.OpeningBalanceMaster OpBal = new Entity.Accounts.OpeningBalanceMaster(); if (dr.HasRows) { while (dr.Read()) { OpBal.OpBalId = OpBalId; OpBal.CompanyId = (dr["CompanyId"] == DBNull.Value) ? 0 : int.Parse(dr["CompanyId"].ToString()); OpBal.FinancialYrId = (dr["FinancialYrId"] == DBNull.Value) ? 0 : int.Parse(dr["FinancialYrId"].ToString()); OpBal.LedgerId = (dr["LedgerId"] == DBNull.Value) ? 0 : int.Parse(dr["LedgerId"].ToString()); OpBal.OpeningBalance = (dr["OpeningBalance"] == DBNull.Value) ? 0 : decimal.Parse(dr["OpeningBalance"].ToString()); OpBal.OpeningBalanceType = (dr["OpeningBalanceType"] == DBNull.Value) ? "0" : dr["OpeningBalanceType"].ToString(); } } return(OpBal); } }
protected void PopulateOpeningBalance() { BusinessLayer.Accounts.OpeningBalanceMaster OpBal = new OpeningBalanceMaster(); Entity.Accounts.OpeningBalanceMaster EntOpBal = OpBal.GetById(OpBalId); LoadLedger(); ddlLedger.SelectedValue = EntOpBal.LedgerId.ToString(); ddlLedger.Enabled = false; txtOpeningBalance.Text = EntOpBal.OpeningBalance.ToString(); ddlOpeningBalanceType.SelectedValue = EntOpBal.OpeningBalanceType; btnSave.Text = "Update"; }
public static int Save(Entity.Accounts.OpeningBalanceMaster OpBal) { using (DataManager oDm = new DataManager()) { oDm.Add("@OpBalId", SqlDbType.Int, ParameterDirection.Input, OpBal.OpBalId); oDm.Add("@CompanyId", SqlDbType.Int, OpBal.CompanyId); oDm.Add("@FinancialYrId", SqlDbType.Int, OpBal.FinancialYrId); oDm.Add("@LedgerId", SqlDbType.Int, OpBal.LedgerId); oDm.Add("@OpeningBalance", SqlDbType.Decimal, OpBal.OpeningBalance); oDm.Add("@OpeningBalanceType", SqlDbType.VarChar, 10, OpBal.OpeningBalanceType); oDm.Add("@CreatedBy", SqlDbType.Int, OpBal.CreatedBy); oDm.Add("@MessageCode", SqlDbType.Int, ParameterDirection.Output); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_MstOpeningBalance_Save"); return((int)oDm["@MessageCode"].Value); } }
protected void btnSave_Click(object sender, EventArgs e) { Entity.Accounts.OpeningBalanceMaster OpBal = new Entity.Accounts.OpeningBalanceMaster(); OpBal.OpBalId = OpBalId; OpBal.CompanyId = int.Parse(Session["CompanyId"].ToString()); OpBal.LedgerId = Convert.ToInt32(ddlLedger.SelectedValue); OpBal.FinancialYrId = Convert.ToInt32(Session["FinYrID"].ToString()); OpBal.OpeningBalance = Convert.ToDecimal(txtOpeningBalance.Text.Trim()); OpBal.OpeningBalanceType = ddlOpeningBalanceType.SelectedValue; OpBal.CreatedBy = int.Parse(Session["UserId"].ToString()); BusinessLayer.Accounts.OpeningBalanceMaster objOpBal = new OpeningBalanceMaster(); int MessageCode = objOpBal.OpeningBalanceSave(OpBal); if (MessageCode >= 0) { Message.IsSuccess = true; if (MessageCode == 0) { Message.Text = "Updated Successfully!"; } else { Message.Text = "Opening Balance Saved Successfully!"; } } else { Message.IsSuccess = false; if (MessageCode == -1) { Message.Text = "Sorry!! Already Exists OR Duplicate Entry is not allowed"; } } Message.Show = true; ResetControl(); }
public int OpeningBalanceSave(Entity.Accounts.OpeningBalanceMaster OpBal) { return(DataAccess.Accounts.OpeningBalanceMaster.Save(OpBal)); }