//upload the images using usertalkid
public int UploadModuleImages(UploadModuleImagesModel model)
{
int res = 0;
try
{
using (TransactionScope trScope = new TransactionScope())
{
using (SqlConnection con = new SqlConnection(CONNECTION_STRING))
{
con.Open();
SqlCommand command = new SqlCommand("Upload_Module_Image", con);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@UserModuleImageId", model.UserModuleImageId);
command.Parameters.AddWithValue("@ImagePath", model.ImagePath);
command.Parameters.AddWithValue("@ModuleId", model.ModuleId);
command.Parameters.AddWithValue("@ModuleImageId", model.ModuleImageId);
command.Parameters.AddWithValue("@UserId", model.UserId);
res = Convert.ToInt32(command.ExecuteScalar());
}
trScope.Complete();
}
}
catch
{
throw;
}
return(res);
}
public async Task <IHttpActionResult> UploadImage()
{
var httpRequest = HttpContext.Current.Request;
int result = 0;
var model = new UploadModuleImagesModel();
model.UserId = Convert.ToInt32(httpRequest.Form[0]);
model.ModuleId = Convert.ToInt32(httpRequest.Form[1]);
model.ModuleImageId = Convert.ToInt32(httpRequest.Form[2]);
model.UserModuleImageId = Convert.ToInt32(httpRequest.Form[3]);
model.ModuleName = httpRequest.Form[4];
model.UserEmail = httpRequest.Form[5];
model.FacultyId = Convert.ToInt32(httpRequest.Form[6]);
foreach (string file in httpRequest.Files)
{
var postedFile = httpRequest.Files[file];
if (postedFile != null && postedFile.ContentLength > 0)
{
int MaxContentLength = 1024 * 1024 * 20; //Size = 20 MB
IList <string> AllowedFileExtensions = new List <string> {
".jpg", ".jpeg", ".gif", ".png"
};
var ext = postedFile.FileName.Substring(postedFile.FileName.LastIndexOf('.'));
var extension = ext.ToLower();
if (!AllowedFileExtensions.Contains(extension))
{
throw new Exception("Please upload image of type .jpg, .jpeg, .gif, .png.");
}
else if (postedFile.ContentLength > MaxContentLength)
{
throw new Exception("Please upload a file upto 1 mb.");
}
else
{
var fileName = Guid.NewGuid().ToString() + extension;
var filePath = HttpContext.Current.Server.MapPath("~/Images/" + fileName);
postedFile.SaveAs(filePath);
model.ImagePath = "/Images/" + fileName;
result = _businessLayer.UploadModuleImages(model, fileName);
return(Ok(result));
}
}
throw new Exception("Please upload a image.");
}
throw new Exception("Please upload a image.");
}
