public int UpdateCvDetails(string fullName, /* HttpPostedFileBase profilePhoto,*/ string emailId, string phoneNo, string website, string addline1, string addline2, /* string jobTitle, string companyName, string dateStartWork, string dateEndWork, string otherWorkInformation,*/ string qualificationText, string objectivesText, /*string CourseName, string institutionName, string dateStartEdu, string dateEndEdu, string otherEduInfo,*/ string interestsText, string referenceText)
{
if (Session["UserId"] == null || Session["CvId"] == null)
{
return(0);
}
List <SP_GetCvBasicInformationByCvId_Result> objListBasicInformationDetails = dbEntities.SP_GetCvBasicInformationByCvId(Convert.ToInt32(Session["CvId"])).ToList();
SP_GetCvBasicInformationByCvId_Result objSinglebasicInfo = objListBasicInformationDetails[0];
//int k = dbEntities.SP_UpdateCvInformationWithoutPhoto(Convert.ToInt32(Session["CvId"]), fullName, emailId, phoneNo, website, addline1, addline2, jobTitle, companyName, dateStartWork, dateEndWork, otherWorkInformation, qualificationText, objectivesText, CourseName, institutionName, dateStartEdu, dateEndEdu, otherEduInfo, interestsText, referenceText);
int k = dbEntities.SP_UpdateCvInformationWithoutPhotoAndWithoutEduAndWorkInfo(Convert.ToInt32(Session["CvId"]), fullName, emailId, phoneNo, website, addline1, addline2, qualificationText, objectivesText, interestsText, referenceText);
//if (profilePhoto != null)
//{
// string oldFilePath = Server.MapPath(objSinglebasicInfo.UserPhoto);
// if (System.IO.File.Exists(oldFilePath))
// System.IO.File.Delete(oldFilePath);
// profilePhoto.SaveAs(serverFilePath);
//}
dbEntities.SaveChanges();
return(k);
}
public JsonResult DeletePhoto()
{
if (Session["UserId"] == null || Session["CvId"] == null)
{
return(Json(0));
}
List <SP_GetCvBasicInformationByCvId_Result> objListBasicInformationDetails = dbEntities.SP_GetCvBasicInformationByCvId(Convert.ToInt32(Session["CvId"])).ToList();
SP_GetCvBasicInformationByCvId_Result objSinglebasicInfo = objListBasicInformationDetails[0];
string oldFilePath = Server.MapPath(objSinglebasicInfo.UserPhoto);
if (System.IO.File.Exists(oldFilePath))
{
System.IO.File.Delete(oldFilePath);
}
objSinglebasicInfo.UserPhoto = null;
int k = dbEntities.SaveChanges();
return(Json(k, JsonRequestBehavior.AllowGet));
}
public ActionResult Testview()
{
if (Session["UserId"] == null || Session["CvId"] == null)
{
return(RedirectToAction("Login", "Home"));
}
List <SP_GetSingleCvDetailsByUserIdAndCvId_Result> objListCvDetails = dbEntities.SP_GetSingleCvDetailsByUserIdAndCvId(Convert.ToInt32(Session["UserId"]), Convert.ToInt32(Session["CvId"])).ToList();
//foreach (SP_GetSingleCvDetailsByUserIdAndCvId_Result objSingleCvDetails in objListCvDetails)
//{
// Relationships.Add(new SelectListItem() { Text = relationship.RelationshipName, Value = relationship.RelationshipId.ToString() });
//}
SP_GetSingleCvDetailsByUserIdAndCvId_Result objSingleCvDetails = objListCvDetails[0];
ViewBag.CvDetails = objSingleCvDetails;
List <SP_GetCvBasicInformationByCvId_Result> objListBasicInformationDetails = dbEntities.SP_GetCvBasicInformationByCvId(Convert.ToInt32(Session["CvId"])).ToList();
SP_GetCvBasicInformationByCvId_Result objSinglebasicInfo = objListBasicInformationDetails[0];
ViewBag.CvbasicInfoDetails = objSinglebasicInfo;
//To aler if needed List
List <SP_GetCvEducationDetailsByCvId_Result> objListEducationDetails = dbEntities.SP_GetCvEducationDetailsByCvId(Convert.ToInt32(Session["CvId"])).ToList();
ViewBag.CvEducationInfoDetails = objListEducationDetails;
List <SP_GetCvInterestDetailsByCvId_Result> objListInterestInformationDetails = dbEntities.SP_GetCvInterestDetailsByCvId(Convert.ToInt32(Session["CvId"])).ToList();
SP_GetCvInterestDetailsByCvId_Result objSingInterestInfo = objListInterestInformationDetails[0];
ViewBag.CvInterestInfoDetails = objSingInterestInfo;
List <SP_GetCvObjectiveDetailsByCvId_Result> objListObjectiveDetails = dbEntities.SP_GetCvObjectiveDetailsByCvId(Convert.ToInt32(Session["CvId"])).ToList();
SP_GetCvObjectiveDetailsByCvId_Result objSingleObjectiveInfo = objListObjectiveDetails[0];
ViewBag.CvObjectiveInfoDetails = objSingleObjectiveInfo;
List <SP_GetCvQualificationDetailsByCvId_Result> objListQualificationDetails = dbEntities.SP_GetCvQualificationDetailsByCvId(Convert.ToInt32(Session["CvId"])).ToList();
SP_GetCvQualificationDetailsByCvId_Result objSingleQualificationInfo = objListQualificationDetails[0];
ViewBag.CvQualificationInfoDetails = objSingleQualificationInfo;
List <SP_GetCvReferencesDetailsByCvId_Result> objListReferencesDetails = dbEntities.SP_GetCvReferencesDetailsByCvId(Convert.ToInt32(Session["CvId"])).ToList();
SP_GetCvReferencesDetailsByCvId_Result objSingleReferencesInfo = objListReferencesDetails[0];
ViewBag.CvReferencesInfoDetails = objSingleReferencesInfo;
//To aler if needed List
List <SP_GetCvWorkExperienceDetailsByCvId_Result> objListWorkExperienceDetails = dbEntities.SP_GetCvWorkExperienceDetailsByCvId(Convert.ToInt32(Session["CvId"])).ToList();
ViewBag.CvWorkExperienceInfoDetails = objListWorkExperienceDetails;
return(View());
}
//public JsonResult UploadPhoto1(PhotoModel model)
//{
// if (model.ImageFile.File.ContentLength > 0)
// {
// var fileName = Path.GetFileName(picture.File.FileName);
// var path = Path.Combine(Server.MapPath("~/Content/Images"), fileName);
// picture.File.SaveAs(path);
// }
//}
public JsonResult UploadPhoto(PhotoModel model)
{
if (Session["UserId"] == null || Session["CvId"] == null)
{
return(Json(0));
}
var file = model.ImageFile;
List <SP_GetCvBasicInformationByCvId_Result> objListBasicInformationDetails = dbEntities.SP_GetCvBasicInformationByCvId(Convert.ToInt32(Session["CvId"])).ToList();
SP_GetCvBasicInformationByCvId_Result objSinglebasicInfo = objListBasicInformationDetails[0];
//if(file != null)
//{
// var fileName = Path.GetFileName(file.FileName);
// var fileExtention = Path.GetExtension(file.FileName);
// var fileNameWithoutExtention = Path.GetFileNameWithoutExtension(file.FileName);
// file.SaveAs(Server.MapPath("/images/" + file.FileName));
//}
string virtualFilePath = objSinglebasicInfo.UserPhoto;
string serverFilePath = string.Empty;
if (file != null)
{
string fileType = file.ContentType;
if (fileType == "image/jpg" || fileType == "image/jpeg" || fileType == "image/gif" || fileType == "image/png" || fileType == "image/bmp")
{
int fileSize = file.ContentLength;
//if (fileSize <= 512000)
if (fileSize <= 5000000)
{
string serverFoldepath = Server.MapPath("/images/UserPhotos\\");
//if (!Directory.Exists(serverFilePath))
// Directory.CreateDirectory(serverFoldepath);
string fileName = Path.GetFileName(file.FileName);
string primaryFileName = Path.GetFileNameWithoutExtension(fileName);
string fileExtensionName = Path.GetExtension(fileName);
//Generate New FileName
Random objRandom = new Random();
int num = objRandom.Next(999999999);
DateTime dt = DateTime.Now;
string newFileName = primaryFileName + num.ToString() + dt.Day.ToString() + dt.Month.ToString() + dt.Year.ToString() + dt.Second.ToString() + dt.Millisecond.ToString() + fileExtensionName;
// for locally
serverFilePath = serverFoldepath + newFileName;
virtualFilePath = "/images/UserPhotos/" + newFileName;
//for server
//serverFilePath = "http://belal0khanjar-001-site1.gtempurl.com" + virtualFilePath;
//serverFilePath = "http://belal0khanjar-001-site1.gtempurl.com" + virtualFilePath;
}
else
{
ViewBag.FileUploadError = "Please upload max 500 kb size file only";
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
else
{
ViewBag.FileUploadError = "Please upload Image file only";
return(Json(0));
}
}
dbEntities.SP_UpdateCvPhoto(Convert.ToInt32(Session["CvId"]), virtualFilePath);
int status = 0;
if (file != null)
{
string oldFilePath = Server.MapPath(objSinglebasicInfo.UserPhoto);
if (System.IO.File.Exists(oldFilePath))
{
System.IO.File.Delete(oldFilePath);
}
file.SaveAs(serverFilePath);
status = 1;
}
//ViewBag.StatusPhoto = "User Profile photo has Updated successfully!!!";
return(Json(/*serverFilePath*/ status, JsonRequestBehavior.AllowGet));
}
public ActionResult CvUserEditCv(string fullName, HttpPostedFileBase profilePhoto, string emailId, string phoneNo, string website, string addline1, string addline2, string jobTitle, string companyName, string dateStartWork, string dateEndWork, string otherWorkInformation, string qualificationText, string objectivesText, string CourseName, string institutionName, string dateStartEdu, string dateEndEdu, string otherEduInfo, string interestsText, string referenceText)
{
if (Session["UserId"] == null || Session["CvId"] == null)
{
return(RedirectToAction("Login", "Home"));
}
List <SP_GetCvBasicInformationByCvId_Result> objListBasicInformationDetails = dbEntities.SP_GetCvBasicInformationByCvId(Convert.ToInt32(Session["CvId"])).ToList();
SP_GetCvBasicInformationByCvId_Result objSinglebasicInfo = objListBasicInformationDetails[0];
string virtualFilePath = objSinglebasicInfo.UserPhoto;
string serverFilePath = string.Empty;
if (profilePhoto != null)
{
string fileType = profilePhoto.ContentType;
if (fileType == "image/jpg" || fileType == "image/jpeg" || fileType == "image/gif" || fileType == "image/png" || fileType == "image/bmp")
{
int fileSize = profilePhoto.ContentLength;
if (fileSize <= 512000)
{
//HttpContext.Current.Server.MapPath("/") + "\\emails\\template1.html";
string serverFoldepath = Server.MapPath("../../Images/UserPhotos\\");
if (!Directory.Exists(serverFilePath))
{
Directory.CreateDirectory(serverFoldepath);
}
string fileName = Path.GetFileName(profilePhoto.FileName);
string primaryFileName = Path.GetFileNameWithoutExtension(fileName);
string fileExtensionName = Path.GetExtension(fileName);
//Generate New FileName
Random objRandom = new Random();
int num = objRandom.Next(999999999);
DateTime dt = DateTime.Now;
string newFileName = primaryFileName + num.ToString() + dt.Day.ToString() + dt.Month.ToString() + dt.Year.ToString() + dt.Second.ToString() + dt.Millisecond.ToString() + fileExtensionName;
serverFilePath = serverFoldepath + newFileName;
virtualFilePath = "../../Images/UserPhotos/" + newFileName;
}
else
{
ViewBag.FileUploadError = "Please upload max 500 kb size file only";
return(View(objSinglebasicInfo));
}
}
else
{
ViewBag.FileUploadError = "Please upload Image file only";
return(View(objSinglebasicInfo));
}
}
dbEntities.SP_UpdateCvInformation(Convert.ToInt32(Session["CvId"]), fullName, virtualFilePath, emailId, phoneNo, website, addline1, addline2, jobTitle, companyName, dateStartWork, dateEndWork, otherWorkInformation, qualificationText, objectivesText, CourseName, institutionName, dateStartEdu, dateEndEdu, otherEduInfo, interestsText, referenceText);
if (profilePhoto != null)
{
string oldFilePath = Server.MapPath(objSinglebasicInfo.UserPhoto);
if (System.IO.File.Exists(oldFilePath))
{
System.IO.File.Delete(oldFilePath);
}
profilePhoto.SaveAs(serverFilePath);
}
ViewBag.Status = "User Profile has Updated successfully!!!";
return(View());
}
