Пример #1
0
 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);
 }
Пример #2
0
        public DataTable Gstr1Search(Gstr1EntryModel objGstr1Model)
        {
            DataTable GstrSearch = objGstr1DA.Gstr1Search(objGstr1Model);

            return(GstrSearch);
        }
Пример #3
0
        public DataTable Gstr1Saved(Gstr1EntryModel objGstr1Model)
        {
            DataTable GstrSave = objGstr1DA.Gstr1Saved(objGstr1Model);

            return(GstrSave);
        }
Пример #4
0
        public DataTable FillGistnNo(Gstr1EntryModel objGstr1Model)
        {
            DataTable GstinList = objGstr1DA.FillGistnNo(objGstr1Model);

            return(GstinList);
        }