internal DataTable Gstr1Search(Gstr1EntryModel objGstr1Model)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPGstr1Entry";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objGstr1Model.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objGstr1Model.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objGstr1Model.BrID);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objGstr1Model.GSTIN);
ClsCon.cmd.Parameters.AddWithValue("@MonthYear", objGstr1Model.MonthYear);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtbGstr1 = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtbGstr1);
dtbGstr1.TableName = "success";
}
catch (Exception)
{
dtbGstr1 = new DataTable();
dtbGstr1.TableName = "error";
return(dtbGstr1);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtbGstr1);
}
public DataTable Gstr1Search(Gstr1EntryModel objGstr1Model)
{
DataTable GstrSearch = objGstr1DA.Gstr1Search(objGstr1Model);
return(GstrSearch);
}
public DataTable Gstr1Saved(Gstr1EntryModel objGstr1Model)
{
DataTable GstrSave = objGstr1DA.Gstr1Saved(objGstr1Model);
return(GstrSave);
}
public DataTable FillGistnNo(Gstr1EntryModel objGstr1Model)
{
DataTable GstinList = objGstr1DA.FillGistnNo(objGstr1Model);
return(GstinList);
}