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