public int UpdateKeyStatuses(KeyStatuses p_KeyStatuses) { MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("p_StatusID", p_KeyStatuses.StatusID), new MySqlParameter("p_StatusType", p_KeyStatuses.StatusType) }; return(MySQLDB.MySQLDBHelper.ExecuteNonQuery("UpdateKeyStatus", CommandType.StoredProcedure, parameters)); }
public int InsertKeyStatuses(KeyStatuses p_KeyStatuses) { int result = 0; MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("p_StatusType", p_KeyStatuses.StatusType), new MySqlParameter("p_result", MySqlDbType.Int32, 2, ParameterDirection.Output, false, 1, 1, "Out", DataRowVersion.Default, result) }; return(MySQLDB.MySQLDBHelper.ExecuteNonQuery("AddKeyStatus", CommandType.StoredProcedure, parameters)); //if (result == 1) return true; //else return false; }
public List <KeyStatuses> SelectKeyStatuses(int currentUserType, int deploymentId) { List <KeyStatuses> VisitorTypesCol = new List <KeyStatuses>(); DataTable dt = MySQLDB.MySQLDBHelper.ExecuteSelectCommand("GetKeyStatuses", CommandType.StoredProcedure); KeyStatuses objKeyStatus = null; foreach (DataRow dr in dt.Rows) { objKeyStatus = new KeyStatuses(); objKeyStatus.StatusID = Convert.ToInt32(dr["StatusID"].ToString()); objKeyStatus.StatusType = dr["StatusType"].ToString(); VisitorTypesCol.Add(objKeyStatus); } dt.Clear(); dt.Dispose(); return(VisitorTypesCol); }
public KeyStatuses SelectKeyStatusesByID(int p_StatusID) { MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("p_StatusID", p_StatusID) }; DataTable dt = MySQLDB.MySQLDBHelper.ExecuteSelectCommand("GetKeyStatusByID", CommandType.StoredProcedure, parameters); KeyStatuses objKeyStatus = null; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; objKeyStatus = new KeyStatuses(); objKeyStatus.StatusID = Convert.ToInt32(dr["StatusID"].ToString()); objKeyStatus.StatusType = dr["StatusType"].ToString(); } dt.Clear(); dt.Dispose(); return(objKeyStatus); }
public int ModifyKeyStatus(KeyStatuses p_KeyStatuses) { return(objKeyStatusesDBA.UpdateKeyStatuses(p_KeyStatuses)); }
public int AddKeyStatus(KeyStatuses p_KeyStatuses) { return(objKeyStatusesDBA.InsertKeyStatuses(p_KeyStatuses)); }