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