public static List <object> FetchProblemByIncedentAndHotelId(int hotelid, int userid) { SqlCommand cmd = new SqlCommand("spFetchSingleProblemByHotelandId"); cmd.Parameters.AddWithValue("@hotelid", hotelid); cmd.Parameters.AddWithValue("@incedentId", userid); cmd.CommandType = System.Data.CommandType.StoredProcedure; DataTable dt = DBOperations.FetchValues(cmd).Tables[0]; Incedent incedent = new Incedent(); User user = new User(); List <object> result = null; if (dt.Rows.Count > 0) { incedent.IncedentID = dt.Rows[0]["Id"].ToString(); incedent.IncedentType = int.Parse(dt.Rows[0]["Type"].ToString()); incedent.IncedentDescription = dt.Rows[0]["Descrp"].ToString(); incedent.RoomNo = dt.Rows[0]["Room"].ToString(); incedent.IncedentTime = DateTime.Parse(dt.Rows[0]["Time"].ToString()); incedent.FeedbackValue = int.Parse(dt.Rows[0]["FeedbackValue"].ToString()); incedent.IsSolved = bool.Parse(dt.Rows[0]["IsResolved"].ToString()); user.Email = dt.Rows[0]["Email"].ToString(); user.LastName = dt.Rows[0]["name"].ToString(); user.Phone = dt.Rows[0]["Phone"].ToString(); result = new List <object>() { user, incedent }; } return(result); }
public static int UpdateProblem(Incedent incedent) { SqlCommand cmd = new SqlCommand("spUpdateProblem"); cmd.Parameters.AddWithValue("@incedentId", incedent.IncedentIDNum); cmd.Parameters.AddWithValue("@description", incedent.IncedentDescription); cmd.Parameters.AddWithValue("@incedentType", incedent.IncedentType); cmd.Parameters.AddWithValue("@feedbackValue", incedent.FeedbackValue); cmd.Parameters.AddWithValue("@isSolved", incedent.IsSolved); cmd.CommandType = CommandType.StoredProcedure; return(DBOperations.UpdateOrInsert(cmd)); }
public static int ReportProblem(Incedent incedent) { SqlCommand cmd = new SqlCommand("spReportProblem"); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@IncedentType", incedent.IncedentType); cmd.Parameters.AddWithValue("@IncedentDescription", incedent.IncedentDescription); cmd.Parameters.AddWithValue("@RoomNo", incedent.RoomNo); cmd.Parameters.AddWithValue("@HotelID", incedent.HotelID); cmd.Parameters.AddWithValue("@IncedentTime", incedent.IncedentTime); cmd.Parameters.AddWithValue("@UserID", incedent.UserID); cmd.Parameters.AddWithValue("@FeedbackValue", incedent.FeedbackValue); return(DBOperations.UpdateOrInsert(cmd)); }