internal static bool ExecuteNonQuery(string sprocName) { try { using (SqlConnection con = new SqlConnection(_Connection)) { SqlCommand cmd = new SqlCommand(sprocName, con); cmd.CommandType = CommandType.StoredProcedure; for (int index = 0; index < _ParamName.Count; index++) { cmd.Parameters.AddWithValue(_ParamName[index], _ParamValue[index]); } con.Open(); cmd.ExecuteNonQuery(); return(true); } } catch (Exception ex) { DBCommands.RecordError(ex); return(false); } finally { EmptyParams(); } }
internal static DataTable AdapterFill(string sprocName) { DataTable dataTable = new DataTable(); try { using (SqlConnection con = new SqlConnection(_Connection)) { SqlCommand cmd = new SqlCommand(sprocName, con); cmd.CommandType = CommandType.StoredProcedure; for (int index = 0; index < _ParamName.Count; index++) { cmd.Parameters.AddWithValue(_ParamName[index], _ParamValue[index]); } using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { sda.Fill(dataTable); } } } catch (Exception ex) { DBCommands.RecordError(ex); } finally { EmptyParams(); } return(dataTable); }
public override bool UserInfoUpdate(UserInfo user) { DBCommands.PopulateParams("@UserName", user.UserName); DBCommands.PopulateParams("@ProfileImage", user.ProfileImage); DBCommands.PopulateParams("@GroupUsers", MapGroupListToTable(user.GroupUsers)); return(DBCommands.ExecuteNonQuery("p_UserInfo_Update")); }
internal static string ExecuteScalar(string sprocName) { try { using (SqlConnection con = new SqlConnection(_Connection)) { SqlCommand cmd = new SqlCommand(sprocName, con); cmd.CommandType = CommandType.StoredProcedure; for (int index = 0; index < _ParamName.Count; index++) { cmd.Parameters.AddWithValue(_ParamName[index], _ParamValue[index]); } con.Open(); var result = cmd.ExecuteScalar(); if (result != null) { return(result.ToString()); } else { return(null); } } } catch (Exception ex) { DBCommands.RecordError(ex); return(null); } finally { EmptyParams(); } }
public override DataTable UserGroupsGetActive() { return(DBCommands.AdapterFill("p_UserGroup_GetActive")); }
public override DataTable GroupUsersGetByUserName(string userName) { DBCommands.PopulateParams("@UserName", userName); return(DBCommands.AdapterFill("p_GroupUsers_GetByUserName")); }
public override UserInfo UserInfoGetByUser(string userName) { DBCommands.PopulateParams("@UserName", userName); return((UserInfo)DBCommands.DataReader("p_UserInfo_GetByUser", DBCommands.ObjectTypes.UserInfo)); }
public override DataTable UserInfoGetAll() { return(DBCommands.AdapterFill("p_UserInfo_GetAll")); }