public IEnumerable <Chat> GetAllChat(int RequestId, int FromId, int ToId) { List <Chat> lstChatController = null; try { //const int a = 10; //readonly int b = 12; ////readonly int myInt = 5; //directly //b = a +1; lstChatController = new List <Chat>(); using (SqlConnection con = new SqlConnection(m_sConnectionString)) { SqlCommand cmd = new SqlCommand("ReqGetChat", con); cmd.Parameters.Add(new SqlParameter("@RequestId", RequestId)); cmd.Parameters.Add(new SqlParameter("@FromId", FromId)); cmd.Parameters.Add(new SqlParameter("@ToId", ToId)); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Chat ChatController = new Chat(); //ChatController.PK = sPK; ChatController.PK = Convert.ToInt32(rdr["rclPK"]); ChatController.ChatMessage = Convert.ToString(rdr["rclText"] + ""); ChatController.IsRead = Convert.ToBoolean(rdr["rclIsRead"]); ChatController.SentDate = Convert.ToDateTime(rdr["rclSentDateTime"]); ChatController.ReceivedDate = Convert.ToDateTime(rdr["rclReceivedTime"]); ChatController.FromId = Convert.ToInt32(rdr["rclFrom"]); ChatController.ToId = Convert.ToInt32(rdr["rclTo"]); lstChatController.Add(ChatController); } con.Close(); } } catch (Exception ex) { ExcData.RegisterException((int)ExceptionDataAccessLayer.ExceptionEnum.Error, ex.Message); } return(lstChatController); }
public IEnumerable <Country> GetAllCountryControllers() { List <Country> lstCountryController = new List <Country>(); try { using (SqlConnection con = new SqlConnection(m_sConnectionString)) { SqlCommand cmd = new SqlCommand("CtyGetAllCountries", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Country CountryController = new Country(); CountryController.PK = Convert.ToInt32(rdr["ctyPK"]); CountryController.NameKey = rdr["ctyNameKey"].ToString(); lstCountryController.Add(CountryController); } con.Close(); } } catch (Exception ex) { ExcData.RegisterException((int)ExceptionDataAccessLayer.ExceptionEnum.Error, ex.Message); } return(lstCountryController); }
public string Delete(int id) { returnVal = "failed"; ExceptionDataAccessLayer ExcData = new ExceptionDataAccessLayer(); try { if (new RequestDataAccessLayer().RequestDelete(id)) { returnVal = "success"; } } catch (Exception ex) { ExcData.RegisterException((int)ExceptionDataAccessLayer.ExceptionEnum.Error, ex.Message); } return(returnVal); }
public string Post([FromBody] Beam.Models.Request RequestModel, int AcceptDecline) { returnVal = "failed"; ExceptionDataAccessLayer ExcData = new ExceptionDataAccessLayer(); try { if (new RequestDataAccessLayer().RequestInsert(RequestModel)) { returnVal = "success"; } } catch (Exception ex) { ExcData.RegisterException((int)ExceptionDataAccessLayer.ExceptionEnum.Error, ex.Message); } return(returnVal); }
public string Put([FromBody] Beam.Models.Chat ChatModel) { returnVal = "failed"; ExceptionDataAccessLayer ExcData = new ExceptionDataAccessLayer(); try { if (new ChatDataAccessLayer().ChatUpdate(ChatModel)) { returnVal = "success"; } } catch (Exception ex) { ExcData.RegisterException((int)ExceptionDataAccessLayer.ExceptionEnum.Error, ex.Message); returnVal = ex.Message; } return(returnVal); }
public string Put([FromBody] Beam.Models.Request RequestModel) { returnVal = "failed"; ExceptionDataAccessLayer ExcData = new ExceptionDataAccessLayer(); try { //if (new RequestDataAccessLayer().RequestUpdate(RequestModel)) //{ // returnVal = "success"; //} if (RequestModel.IsStatusChange) { // if (new RequestDataAccessLayer().RequestStatusUpdate(RequestModel)) { returnVal = "success"; } } else if (RequestModel.IsStatusChange == false) { if (new RequestDataAccessLayer().RequestUpdate(RequestModel)) { returnVal = "success"; } } } catch (Exception ex) { ExcData.RegisterException((int)ExceptionDataAccessLayer.ExceptionEnum.Error, ex.Message); returnVal = ex.Message; } return(returnVal); }
public IEnumerable <City> GetAllCityControllers(string sCountryCode) { List <City> lstCityController = null; try { lstCityController = new List <City>(); using (SqlConnection con = new SqlConnection(m_sConnectionString)) { SqlCommand cmd = new SqlCommand("CitGetAllCitiesFromCountryCode", con); cmd.Parameters.Add(new SqlParameter("@countryCode", sCountryCode)); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { City CityController = new City(); CityController.CountryCode = sCountryCode; CityController.PK = Convert.ToInt32(rdr["citPK"]); CityController.NameKey = rdr["citNameKey"].ToString(); lstCityController.Add(CityController); } con.Close(); } } catch (Exception ex) { ExcData.RegisterException((int)ExceptionDataAccessLayer.ExceptionEnum.Error, ex.Message); } return(lstCityController); }
public IEnumerable <Request> GetAllRequestControllers(int sPK) { List <Request> lstRequestController = null; try { lstRequestController = new List <Request>(); using (SqlConnection con = new SqlConnection(m_sConnectionString)) { SqlCommand cmd = new SqlCommand("ReqGetRequest", con); cmd.Parameters.Add(new SqlParameter("@reqPK", sPK)); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Request RequestController = new Request(); RequestController.PK = sPK; RequestController.PK = Convert.ToInt32(rdr["reqPK"]); RequestController.RequestTypeFK = Convert.ToInt32(rdr["reqRequestTypeFK"]); RequestController.FromCityFK = Convert.ToInt32(rdr["reqFromCityFK"]); RequestController.UserName = Convert.ToString(rdr["usrFirstName"]); RequestController.UserName = RequestController.UserName + " " + Convert.ToString(rdr["usrLastName"]); RequestController.Email = Convert.ToString(rdr["usrEmail"]); RequestController.ToCityFK = Convert.ToInt32(rdr["reqToCityFK"]); RequestController.DateTimeUtc = Convert.ToDateTime(rdr["reqDateTimeUtc"]); RequestController.IsUrgent = Convert.ToBoolean(rdr["reqIsUrgent"]); RequestController.FlexibilityDays = Convert.ToInt32(rdr["reqFlexibilityDays"]); RequestController.Subject = rdr["reqToCityFK"].ToString(); RequestController.ItemDescription = rdr["reqItemDescription"].ToString(); RequestController.Image = Convert.ToString(rdr["reqImage"]); RequestController.Options = Convert.ToInt32(rdr["reqOptions"]); RequestController.ShareOnFacebook = Convert.ToBoolean(rdr["reqShareOnFacebook"]); RequestController.AccompanyInfoFK = Convert.ToInt32(rdr["reqaAccompanyInfoFK"]); RequestController.PackageInfoFK = Convert.ToInt32(rdr["reqPackageInfoFK"]); RequestController.IsForwardingAllowed = Convert.ToBoolean(rdr["reqIsForwardingAllowed"]); RequestController.Status = Convert.ToInt32(rdr["reqStatus"]); RequestController.WillingToPay = Convert.ToInt32(rdr["reqWillingToPay"]); if (RequestController.Status == 0) { RequestController.StatusDescription = "undecided"; } else if (RequestController.Status == 1) { RequestController.StatusDescription = "Accepted by taker "; } else { RequestController.StatusDescription = "Declined by taker"; } RequestController.FromCitystr = Convert.ToString(rdr["CityFromName"]); RequestController.ToCitystr = Convert.ToString(rdr["CityToName"]); lstRequestController.Add(RequestController); } con.Close(); } } catch (Exception ex) { ExcData.RegisterException((int)ExceptionDataAccessLayer.ExceptionEnum.Error, ex.Message); } return(lstRequestController); }