internal DataSet DisplayAdvance(AdvanceLiabilityModel ObjALModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SpAdvanceLiability";
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjALModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjALModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjALModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YearID", ObjALModel.YearID);
ClsCon.cmd.Parameters.AddWithValue("@MonthID", ObjALModel.MonthID);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsAdvanceLia = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsAdvanceLia);
dsAdvanceLia.DataSetName = "success";
}
catch (Exception)
{
dsAdvanceLia = new DataSet();
dsAdvanceLia.DataSetName = "error";
return(dsAdvanceLia);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsAdvanceLia);
}
public DataTable SaveAdvance(AdvanceLiabilityModel ObjALModel)
{
DataTable dtSaveAdvance = ObjAdvLiaDA.SaveAdvance(ObjALModel);
return(dtSaveAdvance);
}
public DataSet DisplayAdvance(AdvanceLiabilityModel ObjALModel)
{
DataSet dsDisplayAdvance = ObjAdvLiaDA.DisplayAdvance(ObjALModel);
return(dsDisplayAdvance);
}
