public async Task <ActionResult> InsertUpdateDoctorImage(DoctorImageModel doctorImage)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(ConfigurationManager.AppSettings["BaseUrl"]);
client.DefaultRequestHeaders.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
if (doctorImage.ImageFile != null)
{
MemoryStream target = new MemoryStream();
doctorImage.ImageFile.InputStream.CopyTo(target);
doctorImage.DoctorImageObject.FileData = target.ToArray();
doctorImage.DoctorImageObject.FileName = doctorImage.ImageFile.FileName;
}
var json = JsonConvert.SerializeObject(doctorImage.DoctorImageObject);
var content = new StringContent(json, Encoding.UTF8, "application/json");
HttpResponseMessage Res = await client.PostAsync("api/DoctorAPI/InsertUpdateDoctorImage", content);
DoctorImagesResponse result = new DoctorImagesResponse();
if (Res.IsSuccessStatusCode)
{
result.IsSuccess = true;
result.Message = Res.Content.ReadAsStringAsync().Result;
}
else
{
result.IsSuccess = false;
result.Message = Res.Content.ReadAsStringAsync().Result;
}
return(View("DoctorImageResponse", result));
}
}
public DoctorImagesResponse GetDoctorImageList(int doctorId, int?doctorImageId)
{
try
{
Log.Info("Started call to GetDoctorImageList");
Log.Info("parameter values" + JsonConvert.SerializeObject(new { doctorId = doctorId, doctorImageId = doctorImageId }));
Command.CommandText = "SP_GET_DOCTOR_IMAGE_LIST";
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.Clear();
Command.Parameters.AddWithValue("@DOCTOR_ID", doctorId);
if (doctorImageId.HasValue)
{
Command.Parameters.AddWithValue("@DOCTOR_IMAGE_ID", doctorImageId);
}
Connection.Open();
SqlDataAdapter dataAdapter = new SqlDataAdapter(Command);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);
DoctorImagesResponse result = new DoctorImagesResponse();
result.DoctorImagesList = new List <DoctorImageDisplay>();
foreach (DataRow drDoctorImage in ds.Tables[0].Rows)
{
result.DoctorImagesList.Add(new DoctorImageDisplay
{
Id = Convert.ToInt32(drDoctorImage["Id"].ToString()),
DoctorId = Convert.ToInt32(drDoctorImage["DoctorId"].ToString()),
DoctorName = drDoctorImage["DoctorName"] != DBNull.Value ? drDoctorImage["DoctorName"].ToString() : null,
IsPrimary = Convert.ToBoolean(drDoctorImage["IsPrimary"].ToString()),
FileName = drDoctorImage["FileName"] != DBNull.Value ? drDoctorImage["FileName"].ToString() : null,
FileData = drDoctorImage["FileData"] != DBNull.Value ? (byte[])drDoctorImage["FileData"] : null,
AddedBy = drDoctorImage["AddedBy"] != DBNull.Value ? Convert.ToInt32(drDoctorImage["AddedBy"].ToString()) : (int?)null,
AddedDate = drDoctorImage["AddedDate"] != DBNull.Value ? DateTime.Parse(drDoctorImage["AddedDate"].ToString()) : (DateTime?)null,
ModifiedBy = drDoctorImage["ModifiedBy"] != DBNull.Value ? Convert.ToInt32(drDoctorImage["ModifiedBy"].ToString()) : (int?)null,
ModifiedDate = drDoctorImage["ModifiedDate"] != DBNull.Value ? DateTime.Parse(drDoctorImage["ModifiedDate"].ToString()) : (DateTime?)null,
});
}
Log.Info("End call to GetDoctorImageList result " + JsonConvert.SerializeObject(result));
return(result);
}
catch (Exception ex)
{
throw;
}
finally
{
Connection.Close();
}
}
public DoctorImagesResponse InsertUpdateDoctorImage(DoctorImages doctorImage, string operation)
{
try
{
Log.Info("Started call to InsertUpdateDoctorImage");
Log.Info("parameter values" + JsonConvert.SerializeObject(new { doctorImage = doctorImage, operation = operation }));
Command.CommandText = "SP_DOCTOR_IMAGE_MANAGER";
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.Clear();
Command.Parameters.AddWithValue("@DOCTOR_IMAGE_XML", GetXMLFromObject(doctorImage));
if (doctorImage.FileData != null)
{
Command.Parameters.AddWithValue("@FILE_DATA", doctorImage.FileData);
}
if (doctorImage.AddedBy.HasValue)
{
Command.Parameters.AddWithValue("@USER_ID", doctorImage.AddedBy.Value);
}
else if (doctorImage.ModifiedBy.HasValue)
{
Command.Parameters.AddWithValue("@USER_ID", doctorImage.ModifiedBy.Value);
}
Connection.Open();
SqlDataReader reader = Command.ExecuteReader();
DoctorImagesResponse result = new DoctorImagesResponse();
if (reader.HasRows)
{
while (reader.Read())
{
result = new DoctorImagesResponse
{
Message = reader["ReturnMessage"] != DBNull.Value ? reader["ReturnMessage"].ToString() : null,
IsSuccess = Convert.ToBoolean(reader["Result"].ToString())
};
}
}
Log.Info("End call to InsertUpdateDoctorImage");
return(result);
}
catch (Exception ex)
{
throw;
}
finally
{
Connection.Close();
}
}
