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