internal DataTable BindGSTIN(RCMLiabilityModel objRCMLiaModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPRCMLiability"; ClsCon.cmd.Parameters.AddWithValue("@Ind", objRCMLiaModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objRCMLiaModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BRID", objRCMLiaModel.BRID); ClsCon.cmd.Parameters.AddWithValue("@YRCD", objRCMLiaModel.YRCD); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtRCMLiability = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtRCMLiability); dtRCMLiability.TableName = "success"; } catch (Exception) { dtRCMLiability = new DataTable(); dtRCMLiability.TableName = "error"; return(dtRCMLiability); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtRCMLiability); }
internal DataSet DisplayPVItemRecord(RCMLiabilityModel objRCMLiaModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPRCMLiability"; ClsCon.cmd.Parameters.AddWithValue("@Ind", objRCMLiaModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objRCMLiaModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@MonthID", objRCMLiaModel.MonthID); ClsCon.cmd.Parameters.AddWithValue("@YearID", objRCMLiaModel.YearID); //ClsCon.cmd.Parameters.AddWithValue("@YearCode", objRCMLiaModel.YearCode); ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objRCMLiaModel.GSTIN); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dsRCMLiability = new DataSet(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dsRCMLiability); dsRCMLiability.DataSetName = "success"; } catch (Exception) { dsRCMLiability = new DataSet(); dsRCMLiability.DataSetName = "error"; return(dsRCMLiability); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dsRCMLiability); }
public DataTable SaveRCMLiability(RCMLiabilityModel objRCMLiaModel) { DataTable dtSave = objRCMLiaDA.SaveRCMLiability(objRCMLiaModel); return(dtSave); }
public DataTable BindGSTIN(RCMLiabilityModel objRCMLiaModel) { DataTable dtGSTIN = objRCMLiaDA.BindGSTIN(objRCMLiaModel); return(dtGSTIN); }
public DataSet DisplayPVItemRecord(RCMLiabilityModel objRCMLiaModel) { DataSet dsDisplayPVItemRecord = objRCMLiaDA.DisplayPVItemRecord(objRCMLiaModel); return(dsDisplayPVItemRecord); }