private void SaveImageInFolderAndAddInformationInCompanyTable(ref CompanyVsStaff companyStaff_info, string WhichPic, HttpPostedFileBase image)
{
if (!IsValidContentType(image.ContentType))
{
ViewBag.Error = "Only PNG image are allowed";
}
byte[] imagebyte = null;
string fileNameWithExtension = Path.GetFileName(image.FileName);
string fileNameWithoutExtension = Path.GetFileNameWithoutExtension(image.FileName);
string extension = Path.GetExtension(image.FileName);
var fileName = companyStaff_info.CompanyVsStaffID + "_" + WhichPic + "" + extension;
string fileSaveInFolder = Path.Combine(Server.MapPath("~/images/CompanyVsStaffImage"), fileName);
image.SaveAs(fileSaveInFolder);
BinaryReader reader = new BinaryReader(image.InputStream);
imagebyte = reader.ReadBytes(image.ContentLength);
Image returnImage = byteArrayToImage(imagebyte);
Bitmap bp = ResizeImage(returnImage, 200, 200);
imagebyte = imageToByteArray(bp);
companyStaff_info.CompanyStaffImageByte = imagebyte;
companyStaff_info.CompanyStaffImage = "/images/CompanyVsStaffImage/" + fileName;
}
private void RemoveOldImageAndThenSaveImageDuringClientUpdate(ref CompanyVsStaff Staff_DB, CompanyVsStaff Staff_details, string type, HttpPostedFileBase image)
{
RemoveImageFromServerFolder(type, Staff_DB);
byte[] imagebyte = null;
string fileNameWithoutExtension = Path.GetFileNameWithoutExtension(image.FileName);
string extension = Path.GetExtension(image.FileName);
var fileName = Staff_DB.CompanyVsStaffID + "_" + type + "" + extension;
string fileSaveInFolder = Path.Combine(Server.MapPath("~/images/CompanyVsStaffImage"), fileName);
image.SaveAs(fileSaveInFolder);
BinaryReader reader = new BinaryReader(image.InputStream);
imagebyte = reader.ReadBytes(image.ContentLength);
Image returnImage = byteArrayToImage(imagebyte);
Bitmap bp = ResizeImage(returnImage, 200, 200);
imagebyte = imageToByteArray(bp);
if (type == "LOGO")
{
Staff_DB.CompanyStaffImage = "/images/CompanyVsStaffImage/" + fileName;
}
}
public ActionResult GetDetailsByID(int CompanyVsStaffID)
{
CompanyVsStaff companyVsStaff = new CompanyVsStaff();
companyVsStaff = db.CompanyVsStaff.Find(CompanyVsStaffID);
var JSON = Json(new { companyVsStaff = companyVsStaff, success = true }, JsonRequestBehavior.AllowGet);
JSON.MaxJsonLength = int.MaxValue;
return(JSON);
}
private void RemoveImageFromServerFolder(string type, CompanyVsStaff Staff_DB)
{
string removeImageName = "";
if (type == "LOGO")
{
removeImageName = !string.IsNullOrEmpty(Staff_DB.CompanyStaffImage) ? Staff_DB.CompanyStaffImage.Split('/')[3] : "";
}
var filePath = Server.MapPath("~/images/CompanyVsStaffImage/" + removeImageName);
if (System.IO.File.Exists(filePath))
{
System.IO.File.Delete(filePath);
}
}
private void SetValuesFromClientModelToDBModel(ref CompanyVsStaff CompanyStaff_DB, ref CompanyVsStaff client_Staff_details)
{
CompanyStaff_DB.FirstName = client_Staff_details.FirstName;
CompanyStaff_DB.Address = client_Staff_details.Address;
CompanyStaff_DB.LastName = client_Staff_details.LastName;
CompanyStaff_DB.Password = client_Staff_details.Password;
CompanyStaff_DB.LoginName = client_Staff_details.LoginName;
CompanyStaff_DB.CompanyID = CompanyStaff_DB.CompanyID;
CompanyStaff_DB.Email = client_Staff_details.Email;
CompanyStaff_DB.Phone = client_Staff_details.Phone;
CompanyStaff_DB.RoleID = CompanyStaff_DB.RoleID;
CompanyStaff_DB.Status = client_Staff_details.Status;
CompanyStaff_DB.UserRightPermissionID = client_Staff_details.UserRightPermissionID;
CompanyStaff_DB.IsItSuperAdmin = client_Staff_details.IsItSuperAdmin;
CompanyStaff_DB.UpdateBy = AppUtils.GetLoginUserID();
//Company_DB.UpdateBy = AppUtils.GetLoginEmployeeName();
CompanyStaff_DB.UpdateDate = AppUtils.GetDateTimeNow();
}
private void AddGivenImageInCurrentRow(ref CompanyVsStaff Staff_DB, CompanyVsStaff Staff_details, string type, HttpPostedFileBase image, string imagePath)
{
if (type == "LOGO")
{
if (image != null && imagePath != null)
{
RemoveOldImageAndThenSaveImageDuringClientUpdate(ref Staff_DB, Staff_details, "LOGO", image);
}
else if (!string.IsNullOrEmpty(imagePath))
{
Staff_DB.CompanyStaffImage = Staff_details.CompanyStaffImage;
}
else
{
RemoveImageFromServerFolder(type, Staff_DB);
Staff_DB.CompanyStaffImage = null;
}
}
}
public ActionResult InsertCompanyVsStaffFromPopUp(FormCollection form, HttpPostedFileBase StaffImage)
{
CompanyVsStaff client_Staff_info = JsonConvert.DeserializeObject <CompanyVsStaff>(form["CompanyVsStaffDetails"]);
CompanyVsStaff CompanyStaffReturn = new CompanyVsStaff();
try
{
if (client_Staff_info.IsItSuperAdmin)
{
client_Staff_info.RoleID = AppUtils.CompanyAdminRole;
client_Staff_info.UserRightPermissionID = AppUtils.UserRightPermissionIDIsCompanyAdmin;
}
else
{
client_Staff_info.RoleID = AppUtils.CompanyStaffRole;
client_Staff_info.UserRightPermissionID = AppUtils.UserRightPermissionIDIsCompanyStaff;
}
client_Staff_info.Status = client_Staff_info.Status;
client_Staff_info.CreateBy = AppUtils.GetLoginUserID();
//Company_info.CreateBy = AppUtils.GetLoginEmployeeName();
client_Staff_info.CreateDate = AppUtils.GetDateTimeNow();
CompanyStaffReturn = db.CompanyVsStaff.Add(client_Staff_info);
db.SaveChanges();
if (StaffImage != null)
{
SaveImageInFolderAndAddInformationInCompanyTable(ref client_Staff_info, "LOGO", StaffImage);
}
if (CompanyStaffReturn.CompanyID > 0)
{
db.SaveChanges();
return(Json(new { success = true, }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateCompanyVsStaffFromPopUp(FormCollection form, HttpPostedFileBase StaffImageUpdate)
{
CompanyVsStaff client_Staff_details = JsonConvert.DeserializeObject <CompanyVsStaff>(form["Staff_details"]);
CompanyVsStaff CompanyStaff_DB = db.CompanyVsStaff.Where(s => s.CompanyVsStaffID == client_Staff_details.CompanyVsStaffID).FirstOrDefault();
try
{
AddGivenImageInCurrentRow(ref CompanyStaff_DB, client_Staff_details, "LOGO", StaffImageUpdate, client_Staff_details.CompanyStaffImage);
if (CompanyStaff_DB.CompanyID > 0)
{
SetValuesFromClientModelToDBModel(ref CompanyStaff_DB, ref client_Staff_details);
if (client_Staff_details.IsItSuperAdmin)
{
CompanyStaff_DB.RoleID = AppUtils.CompanyAdminRole;
CompanyStaff_DB.UserRightPermissionID = AppUtils.UserRightPermissionIDIsCompanyAdmin;
}
else
{
CompanyStaff_DB.RoleID = AppUtils.CompanyStaffRole;
CompanyStaff_DB.UserRightPermissionID = AppUtils.UserRightPermissionIDIsCompanyStaff;
}
db.Entry(CompanyStaff_DB).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetAllCallHistoryForCompanyStaffAjaxData()
{
JsonResult result = new JsonResult();
try
{
string search = Request.Form.GetValues("search[value]")[0];
string draw = Request.Form.GetValues("draw")[0];
string order = Request.Form.GetValues("order[0][column]")[0];
string orderDir = Request.Form.GetValues("order[0][dir]")[0];
int startRec = Convert.ToInt32(Request.Form.GetValues("start")[0]);
int pageSize = Convert.ToInt32(Request.Form.GetValues("length")[0]);
var StartDateID = Request.Form.Get("StartDateID");
var EndDateID = Request.Form.Get("EndDateID");
DateTime?startDate = new DateTime?();
DateTime?endDate = new DateTime?();
int totalRecords = 0;
if (!string.IsNullOrEmpty(StartDateID))
{
startDate = Convert.ToDateTime(StartDateID);
}
if (!string.IsNullOrEmpty(EndDateID))
{
endDate = Convert.ToDateTime(EndDateID);
}
var firstPartOfQuery = db.CallHistory.Where(a => a.Status == AppUtils.TableStatusIsActive && a.CompanyID == 4).AsQueryable();
int ifSearch = 0;
int loginUserID = AppUtils.GetLoginUserID();
CompanyVsStaff companyVsStaff = db.CompanyVsStaff.Where(x => x.CompanyVsStaffID == loginUserID).FirstOrDefault();
List <CallHistoryViewModel> data = new List <CallHistoryViewModel>();
DateTime dt = AppUtils.GetDateTimeNow();
if (!companyVsStaff.IsItSuperAdmin)
{
firstPartOfQuery = firstPartOfQuery.Where(x => x.CompanyVsStaffID == companyVsStaff.CompanyVsStaffID).AsQueryable();
var date = dt.AddHours(23).AddMinutes(59).AddSeconds(59).AddMilliseconds(59);
firstPartOfQuery =
(StartDateID != "" && EndDateID != "") ? firstPartOfQuery.Where(s => s.CallTime >= startDate && s.CallTime <= endDate).AsQueryable()
: (StartDateID != "" && EndDateID == "") ? firstPartOfQuery.Where(s => s.CallTime >= startDate).AsQueryable()
: (StartDateID == "" && EndDateID != "") ? firstPartOfQuery.Where(s => s.CallTime <= endDate).AsQueryable()
: firstPartOfQuery.Where(x => x.CallTime > dt && x.CallTime <= date).AsQueryable();
}
else
{
var date = dt.AddHours(23).AddMinutes(59).AddSeconds(59).AddMilliseconds(59);
firstPartOfQuery =
(StartDateID != "" && EndDateID != "") ? firstPartOfQuery.Where(s => s.CallTime >= startDate && s.CallTime <= endDate).AsQueryable()
: (StartDateID != "" && EndDateID == "") ? firstPartOfQuery.Where(s => s.CallTime >= startDate).AsQueryable()
: (StartDateID == "" && EndDateID != "") ? firstPartOfQuery.Where(s => s.CallTime <= endDate).AsQueryable()
: firstPartOfQuery.Where(x => x.CallTime > dt && x.CallTime <= date).AsQueryable();
}
var secondPartOfQuery = firstPartOfQuery.AsEnumerable();
if (!string.IsNullOrEmpty(search) && !string.IsNullOrWhiteSpace(search))
{
ifSearch = (secondPartOfQuery.Any()) ? secondPartOfQuery.Where(p => p.CallerName.ToString().ToLower().Contains(search.ToLower()) ||
p.CallerPhone.ToString().ToLower().Contains(search.ToLower()) ||
p.Subject.ToString().ToLower().Contains(search.ToLower())).Count() : 0;
secondPartOfQuery = secondPartOfQuery.Where(p => p.CallerName.ToString().ToLower().Contains(search.ToLower()) ||
p.CallerPhone.ToString().ToLower().Contains(search.ToLower()) ||
p.Subject.ToString().ToLower().Contains(search.ToLower())).AsEnumerable();
}
if (secondPartOfQuery.Count() > 0)
{
totalRecords = secondPartOfQuery.AsEnumerable().Count();
data = secondPartOfQuery.AsEnumerable().Skip(startRec).Take(pageSize).Select(
s => new CallHistoryViewModel
{
CallHistoryID = s.CallHistoryID,
CallerName = s.CallerName,
Subject = s.Subject,
Description = s.Description,
CallerPhone = s.CallerPhone,
EmployeeID = s.EmployeeID,
EmployeeName = GetEmpName(s.EmployeeID),
CountryID = db.Country.Find(s.CountryID).CountryName,
CompanyVsStaffID = GetStaffName(s.CompanyVsStaffID),
UpdateCallHistory = AppUtils.HasAccessInTheList(AppUtils.Update_CallHistory) ? true : false,
})
.ToList();
}
data = this.SortByColumnWithOrderForCompanyStaff(order, orderDir, data);
int recFilter = (!string.IsNullOrEmpty(search) && !string.IsNullOrWhiteSpace(search)) ? ifSearch : firstPartOfQuery.AsEnumerable().Count();
result = this.Json(new
{
draw = Convert.ToInt32(draw),
recordsTotal = totalRecords,
recordsFiltered = recFilter,
data = data
}, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
Console.Write(ex);
}
return(result);
}
