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);
}
public DataTable SaveUser(UserRollModel objUserRollModel)
{
DataTable dtSaveUser = objURDA.SaveUser(objUserRollModel);
return(dtSaveUser);
}
public DataTable BindUserRoll(UserRollModel objUserRollModel)
{
DataTable dtCUGrid = objURDA.BindUserRoll(objUserRollModel);
return(dtCUGrid);
}