public List <InteEmployeeModels> GetListEmployee(string StoreID = null, string EmployeeId = null, List <string> ListOrganizationId = null) { List <InteEmployeeModels> listData = new List <InteEmployeeModels>(); try { InteSBEmployeeApiModels paraBody = new InteSBEmployeeApiModels(); paraBody.AppKey = Commons.AppKey; paraBody.AppSecret = Commons.AppSecret; paraBody.CreatedUser = Commons.CreateUser; paraBody.StoreID = StoreID; paraBody.ID = EmployeeId; //paraBody.Mode = 1; paraBody.ListOrgID = ListOrganizationId; var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.GetEmployee, null, paraBody); dynamic data = result.Data; var lstC = data["ListEmployee"]; var lstContent = JsonConvert.SerializeObject(lstC /*result.RawData*/); listData = JsonConvert.DeserializeObject <List <InteEmployeeModels> >(lstContent); return(listData); } catch (Exception e) { _logger.Error("Employee_GetList: " + e); return(listData); } }
public bool InsertOrUpdateEmployee(InteEmployeeModels model, ref string msg) { try { InteSBEmployeeApiModels paraBody = new InteSBEmployeeApiModels(); paraBody.AppKey = Commons.AppKey; paraBody.AppSecret = Commons.AppSecret; paraBody.CreatedUser = Commons.CreateUser; paraBody.RegisterToken = new RegisterTokenModels(); paraBody.ID = model.ID; paraBody.StoreID = model.StoreID; paraBody.EmployeeDTO = model; //==================== NSLog.Logger.Info("InsertOrUpdateEmployee Info", paraBody); var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.CreateOrEditEmployee, null, paraBody); if (result != null) { if (result.Success) { return(true); } else { msg = result.Message; _logger.Error(result.Message); return(false); } } else { //msg = result.ToString(); _logger.Error(result); return(false); } } catch (Exception e) { _logger.Error("Employee_InsertOrUpdate: " + e); //msg = e.ToString(); return(false); } }
public bool DeleteEmployee(string ID, string StoreID, ref string msg) { try { InteSBEmployeeApiModels paraBody = new InteSBEmployeeApiModels(); paraBody.AppKey = Commons.AppKey; paraBody.AppSecret = Commons.AppSecret; paraBody.CreatedUser = Commons.CreateUser; paraBody.RegisterToken = new RegisterTokenModels(); paraBody.ID = ID; paraBody.StoreID = StoreID; //==================== var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.DeleteEmployee, null, paraBody); if (result != null) { if (result.Success) { return(true); } else { msg = result.Message; _logger.Error(result.Message); return(false); } } else { _logger.Error(result); return(false); } } catch (Exception e) { msg = e.ToString(); _logger.Error("Employee_Delete: " + e); return(false); } }
public StatusResponse Export(ref IXLWorksheet ws, List <string> lstStore) { StatusResponse Response = new StatusResponse(); try { List <InteEmployeeModels> listData = new List <InteEmployeeModels>(); InteSBEmployeeApiModels paraBody = new InteSBEmployeeApiModels(); paraBody.AppKey = Commons.AppKey; paraBody.AppSecret = Commons.AppSecret; paraBody.CreatedUser = Commons.CreateUser; paraBody.ListStoreID = lstStore; var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.ExportEmployee, null, paraBody); dynamic data = result.Data; var lstC = data["ListEmployee"]; var lstContent = JsonConvert.SerializeObject(lstC); listData = JsonConvert.DeserializeObject <List <InteEmployeeModels> >(lstContent); int row = 1; string[] listSetMenuHeader = new string[] { _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Index") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Employee Name") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Pin Code") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Email") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Phone Number") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Gender") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Role Name") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Marital Status") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Hired Date") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Birthday") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Status") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Country") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Zip Code") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("City") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Street") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Image Url") , _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Store Name") }; for (int i = 1; i <= listSetMenuHeader.Length; i++) { ws.Cell(row, i).Value = listSetMenuHeader[i - 1]; } int cols = listSetMenuHeader.Length; //Item row = 2; int countIndex = 1; foreach (var item in listData) { foreach (var emp in item.ListEmpStore) { ws.Cell("A" + row).Value = countIndex; ws.Cell("B" + row).Value = item.Name; ws.Cell("C" + row).Value = "'" + item.Pincode; ws.Cell("D" + row).Value = item.Email; ws.Cell("E" + row).Value = "'" + item.Phone; ws.Cell("F" + row).Value = item.Gender ? _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Male") : _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Female"); ws.Cell("G" + row).Value = emp.RoleName; ws.Cell("H" + row).Value = item.Marital ? _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Married") : _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Single"); ws.Cell("I" + row).Value = "'" + item.HiredDate.ToString("dd/MM/yyyy"); ws.Cell("J" + row).Value = "'" + item.BirthDate.ToString("dd/MM/yyyy"); ws.Cell("K" + row).Value = item.IsActive ? _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Active") : _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("InActive"); ws.Cell("L" + row).Value = item.Country; ws.Cell("M" + row).Value = "'" + item.Zipcode; ws.Cell("N" + row).Value = item.City; ws.Cell("O" + row).Value = item.Street; ws.Cell("P" + row).Value = item.ImageURL.Replace(Commons._PublicImages, ""); ws.Cell("Q" + row).Value = emp.StoreName; row++; countIndex++; } } FormatExcelExport(ws, row, cols); Response.Status = true; } catch (Exception e) { Response.Status = false; Response.MsgError = e.Message; } finally { } return(Response); }
public ImportModel Import(string filePath, FileInfo[] listFileInfo, List <string> storeIndexes, ref string msg) { ImportModel importItems = new ImportModel(); DataTable dtEmployee = ReadExcelFile(filePath, "Sheet1"); string tmpExcelPath = System.Web.HttpContext.Current.Server.MapPath("~/ImportExportTemplate") + "/SBEmployeeInte.xlsx"; DataTable dtEmployeeTmp = ReadExcelFile(tmpExcelPath, "Sheet1"); if (dtEmployee.Columns.Count != dtEmployeeTmp.Columns.Count) { msg = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(Commons._MsgDoesNotMatchFileExcel); return(importItems); } ImportItem itemErr = null; bool flagInsert = true; string msgError = ""; List <InteEmployeeModels> listData = new List <InteEmployeeModels>(); //foreach (var store in storeIndexes) { foreach (DataRow item in dtEmployee.Rows) { flagInsert = true; msgError = ""; if (item[0].ToString().Equals("")) { continue; } int index = int.Parse(item[0].ToString()); string ImageUrl = ""; if (!string.IsNullOrEmpty(item[15].ToString())) { FileInfo file = listFileInfo.FirstOrDefault(m => m.Name.ToLower() == item[15].ToString().ToLower()); if (file != null) { if (file.Length > Commons._MaxSizeFileUploadImg) { flagInsert = false; msgError = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(Commons._MsgAllowedSizeImg) + "<br/>"; } else { ImageUrl = Guid.NewGuid() + file.Extension; byte[] photoByte = null; photoByte = System.IO.File.ReadAllBytes(file.FullName); //19/01/2018 //photoByte = file.ReadFully(); //Save Image on Server if (!string.IsNullOrEmpty(ImageUrl) && photoByte != null) { var originalDirectory = new DirectoryInfo(string.Format("{0}Uploads\\", System.Web.HttpContext.Current.Server.MapPath(@"\"))); var path = string.Format("{0}{1}", originalDirectory, ImageUrl); MemoryStream ms = new MemoryStream(photoByte, 0, photoByte.Length); ms.Write(photoByte, 0, photoByte.Length); System.Drawing.Image imageTmp = System.Drawing.Image.FromStream(ms, true); ImageHelper.Me.SaveCroppedImage(imageTmp, path, ImageUrl, ref photoByte); FTP.Upload(ImageUrl, photoByte); ImageHelper.Me.TryDeleteImageUpdated(path); } } } } List <InteEmployeeOnStoreModels> ListEmpStore = new List <InteEmployeeOnStoreModels>(); foreach (var storeId in storeIndexes) { //===== Role Name string RoleName = item[6].ToString(); if (string.IsNullOrEmpty(RoleName)) { flagInsert = false; msgError += "<br/>" + _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(("Role Name is required")); } ListEmpStore.Add(new InteEmployeeOnStoreModels { StoreID = storeId, RoleName = RoleName }); } string msgItem = ""; DateTime HiredDate = DateTimeHelper.GetDateImport(item[8].ToString(), ref msgItem); DateTime BirthDate = DateTimeHelper.GetDateImport(item[9].ToString(), ref msgItem); if (!msgItem.Equals("")) { flagInsert = false; msgError = msgItem; } InteEmployeeModels model = new InteEmployeeModels { Index = item[0].ToString(), Name = item[1].ToString(), Pincode = item[2].ToString(), Email = item[3].ToString(), Phone = item[4].ToString(), Gender = string.IsNullOrEmpty(item[5].ToString()) ? false : item[5].ToString().ToLower().Equals(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Male")) ? true : false, Marital = string.IsNullOrEmpty(item[7].ToString()) ? false : item[7].ToString().ToLower().Equals(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Married")) ? true : false, HiredDate = item[8].ToString().Equals("") ? Commons._ExpiredDate : HiredDate, BirthDate = item[9].ToString().Equals("") ? Commons._ExpiredDate : BirthDate, IsActive = string.IsNullOrEmpty(item[10].ToString()) ? false : bool.Parse(item[10].ToString().ToLower().Equals(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Active")).ToString()) ? true : false, Country = item[11].ToString(), Zipcode = item[12].ToString(), City = item[13].ToString(), Street = item[14].ToString(), ImageURL = ImageUrl, ListEmpStore = ListEmpStore }; //========= //===== Name if (string.IsNullOrEmpty(model.Name)) { flagInsert = false; msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Name is required"); msgError += "<br/>" + msgItem; } //===== PinCode if (model.Pincode.Equals("")) { flagInsert = false; msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Pin Code is required"); msgError += "<br/>" + msgItem; } else if (model.Pincode.Length < 3 || model.Pincode.Length > 20) { flagInsert = false; msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Number of characters should be between 3 and 20"); msgError += "<br/>" + msgItem; } else if (!CommonHelper.IsNumber(model.Pincode)) { flagInsert = false; msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Please enter a valid PIN Code"); msgError += "<br/>" + msgItem; } //===== Email if (model.Email.Equals("")) { flagInsert = false; msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Email is required"); msgError += "<br/>" + msgItem; } else if (!CommonHelper.IsValidEmail(model.Email)) { flagInsert = false; msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Please enter a valid email address."); msgError += "<br/>" + msgItem; } //=======Phone if (model.Phone.Equals("")) { flagInsert = false; msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Phone number is required"); msgError += "<br/>" + msgItem; } else if (!CommonHelper.IsNumber(model.Phone)) { flagInsert = false; msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Please enter a valid phone number"); msgError += "<br/>" + msgItem; } //===== Name if (model.HiredDate.Date > DateTime.Now.Date) { flagInsert = false; msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Hired date must be before or equal to the current date"); msgError += "<br/>" + msgItem; } if (model.BirthDate.Date > DateTime.Now.Date) { flagInsert = false; msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Birth date must be before or equal to the current date"); msgError += "<br/>" + msgItem; } //=========== if (flagInsert) { listData.Add(model); } else { itemErr = new ImportItem(); itemErr.Name = model.Name; itemErr.ListFailStoreName.Add(""); itemErr.ListErrorMsg.Add(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Row") + ":" + index + msgError); importItems.ListImport.Add(itemErr); } } } InteSBEmployeeApiModels paraBody = new InteSBEmployeeApiModels(); paraBody.AppKey = Commons.AppKey; paraBody.AppSecret = Commons.AppSecret; paraBody.CreatedUser = Commons.CreateUser; paraBody.RegisterToken = new RegisterTokenModels(); paraBody.ListEmployee = listData; //==================== var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.ImportEmployee, null, paraBody); if (result != null) { dynamic data = result.Data; var lstC = data["ListProperty"]; var lstContent = JsonConvert.SerializeObject(lstC); var listError = JsonConvert.DeserializeObject <List <ImportResult> >(lstContent); foreach (ImportResult itemError in listError) { ImportItem item = new ImportItem(); item.Name = itemError.Property; item.ListFailStoreName.Add(itemError.StoreName); item.ListErrorMsg.Add(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Row") + ": " + itemError.Index + "<br/>" + itemError.Error); importItems.ListImport.Add(item); } if (importItems.ListImport.Count == 0) { ImportItem item = new ImportItem(); item.Name = "Employee"; item.ListSuccessStoreName.Add(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Import Employee Successful")); importItems.ListImport.Add(item); } } return(importItems); }