internal DataTable SaveGSTR3BData(Gstr3BModel objGstr3BModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPGSTR3B";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objGstr3BModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objGstr3BModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objGstr3BModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objGstr3BModel.YrCD);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dt3bGstr = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dt3bGstr);
dt3bGstr.TableName = "success";
}
catch (Exception)
{
dt3bGstr = new DataTable();
dt3bGstr.TableName = "error";
return(dt3bGstr);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dt3bGstr);
}
internal DataSet GetGSTR3BData(Gstr3BModel objGstr3BModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPGSTR3B";
ClsCon.cmd.CommandTimeout = 120;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objGstr3BModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objGstr3BModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objGstr3BModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objGstr3BModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objGstr3BModel.GSTIN);
ClsCon.cmd.Parameters.AddWithValue("@TaxMonth", objGstr3BModel.TaxMonth);
ClsCon.cmd.Parameters.AddWithValue("@TaxYear", objGstr3BModel.TaxYear);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
ds3bgstr = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(ds3bgstr);
ds3bgstr.DataSetName = "success";
}
catch (Exception)
{
ds3bgstr = new DataSet();
ds3bgstr.DataSetName = "error";
return(ds3bgstr);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(ds3bgstr);
}
public DataTable SaveGSTR3BData(Gstr3BModel objGstr3BModel)
{
DataTable dtSaveGSTR3BData = objGstr3BDA.SaveGSTR3BData(objGstr3BModel);
return(dtSaveGSTR3BData);
}
public DataSet GetGSTR3BData(Gstr3BModel objGstr3BModel)
{
DataSet dsGetGSTR3BData = objGstr3BDA.GetGSTR3BData(objGstr3BModel);
return(dsGetGSTR3BData);
}
public DataTable FillGistnNo(Gstr3BModel objGstr3BModel)
{
DataTable GstinList = objGstr3BDA.FillGistnNo(objGstr3BModel);
return(GstinList);
}
