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