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); }