Exemplo n.º 1
0
 internal DataTable BindUserRoll(UserRollModel objUserRollModel)
 {
     try
     {
         ClsCon.cmd             = new SqlCommand();
         ClsCon.cmd.CommandType = CommandType.StoredProcedure;
         ClsCon.cmd.CommandText = "SPUserRoll";
         ClsCon.cmd.Parameters.AddWithValue("@Ind", objUserRollModel.Ind);
         con = ClsCon.SqlConn();
         ClsCon.cmd.Connection = con;
         dtCUDA    = new DataTable();
         ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
         ClsCon.da.Fill(dtCUDA);
         dtCUDA.TableName = "success";
     }
     catch (Exception)
     {
         dtCUDA           = new DataTable();
         dtCUDA.TableName = "error";
         return(dtCUDA);
     }
     finally
     {
         con.Close();
         con.Dispose();
         ClsCon.da.Dispose();
         ClsCon.cmd.Dispose();
     }
     return(dtCUDA);
 }
Exemplo n.º 2
0
        public DataTable SaveUser(UserRollModel objUserRollModel)
        {
            DataTable dtSaveUser = objURDA.SaveUser(objUserRollModel);

            return(dtSaveUser);
        }
Exemplo n.º 3
0
        public DataTable BindUserRoll(UserRollModel objUserRollModel)
        {
            DataTable dtCUGrid = objURDA.BindUserRoll(objUserRollModel);

            return(dtCUGrid);
        }