public string CheckIfAirportsExists(ACRF_AirportsModel objModel)
{
string result = "";
try
{
string sqlstr = "Select * from ACRF_Airports Where ISNULL(Airports,'')=@Airports and Isnull(Id,0)!=@Id "
+ " and CountryId=@CountryId and ShortCode=@ShortCode ";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.Parameters.AddWithValue("@Airports", objModel.Airports);
cmd.Parameters.AddWithValue("@CountryId", objModel.CountryId);
cmd.Parameters.AddWithValue("@ShortCode", objModel.ShortCode);
cmd.Parameters.AddWithValue("@Id", objModel.Id);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
result = "Airports already exists!";
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(result);
}
public string UpdateAirports(ACRF_AirportsModel objModel)
{
string result = "Error on Updating Airports!";
try
{
result = CheckIfAirportsExists(objModel);
if (result == "")
{
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = connection.CreateCommand();
SqlTransaction transaction;
transaction = connection.BeginTransaction();
cmd.Transaction = transaction;
cmd.Connection = connection;
try
{
string sqlstr = "";
sqlstr = "update ACRF_Airports set Airports=@Airports, ShortCode=@ShortCode, CountryId=@CountryId,"
+ " UpdatedBy=@UpdatedBy,UpdatedOn=@UpdatedOn where Id=@Id";
cmd.CommandText = sqlstr;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Airports", objModel.Airports);
cmd.Parameters.AddWithValue("@ShortCode", objModel.ShortCode);
cmd.Parameters.AddWithValue("@CountryId", objModel.CountryId);
cmd.Parameters.AddWithValue("@Id", objModel.Id);
cmd.Parameters.AddWithValue("@UpdatedBy", objModel.UpdatedBy);
cmd.Parameters.AddWithValue("@UpdatedOn", StandardDateTime.GetDateTime());
cmd.ExecuteNonQuery();
transaction.Commit();
connection.Close();
result = "Airports Updated Successfully!";
}
catch (Exception ex)
{
transaction.Rollback();
connection.Close();
Global.ErrorHandlerClass.LogError(ex);
result = ex.Message;
}
}
else
{
return(result);
}
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(result);
}
public IHttpActionResult ViewOneAirports(int Id)
{
ACRF_AirportsModel objList = new ACRF_AirportsModel();
try
{
objList = objAirportsVM.GetOneAirports(Id);
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(Ok(new { results = objList }));
}
public List <ACRF_AirportsModel> ListAirports()
{
List <ACRF_AirportsModel> objList = new List <ACRF_AirportsModel>();
try
{
string sqlstr = "select Id, isnull(ShortCode,'') as ShortCode, isnull(Airports,'') as Airports, isnull(CountryId,0) as CountryId, "
+ " isnull(CreatedBy,'') as CreatedBy, isnull(createdon,'') as CreatedOn, "
+ " isnull(updatedby,'') as updatedby, isnull(updatedon,'') as updatedon from ACRF_Airports order by Id";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.Text;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ACRF_AirportsModel tempobj = new ACRF_AirportsModel();
tempobj.Id = Convert.ToInt32(sdr["Id"].ToString());
tempobj.Airports = sdr["Airports"].ToString();
tempobj.ShortCode = sdr["ShortCode"].ToString();
tempobj.CountryId = Convert.ToInt32(sdr["CountryId"].ToString());
tempobj.CreatedBy = sdr["CreatedBy"].ToString();
tempobj.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"].ToString());
objList.Add(tempobj);
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
public IHttpActionResult AddAirports(ACRF_AirportsModel objModel)
{
string result = "";
if (ModelState.IsValid)
{
try
{
objModel.CreatedBy = GlobalFunction.getLoggedInUser(Request.Headers.GetValues("Token").First());
result = objAirportsVM.CreateAirports(objModel);
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
result = ex.Message;
}
}
else
{
result = "Enter Valid Mandatory Fields";
}
return(Ok(new { results = result }));
}
public ACRF_AirportsModel GetOneAirports(int Id)
{
ACRF_AirportsModel objList = new ACRF_AirportsModel();
try
{
string sqlstr = "select Id, isnull(ShortCode,'') as ShortCode, isnull(Airports,'') as Airports, isnull(CountryId,0) as CountryId, "
+ " isnull(CreatedBy,'') as CreatedBy, isnull(createdon,'') as CreatedOn, "
+ " isnull(updatedby,'') as updatedby, isnull(updatedon,'') as updatedon from ACRF_Airports where Id=@Id";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@Id", Id);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
objList.Id = Convert.ToInt32(sdr["Id"].ToString());
objList.Airports = sdr["Airports"].ToString();
objList.ShortCode = sdr["ShortCode"].ToString();
objList.CountryId = Convert.ToInt32(sdr["CountryId"].ToString());
objList.CreatedBy = sdr["CreatedBy"].ToString();
objList.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"].ToString());
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
