public ActionResult getEmployeeByProfile(string idProfile)
{
List <BsonDocument> employees = _employeeTable.get("profileId", idProfile);
List <BsonDocument> profiles = _employeeProfileTable.getRows();
ViewBag.canDelete = true;
ViewBag.profiles = profiles;
ViewBag.idProfile = idProfile;
return(View(employees));
}
public String saveEmployee(FormCollection formData, HttpPostedFileBase file)
{
bool access = false;
String dataPermissions = Session["Permissions"].ToString();
String dataPermissionsClient = Session["PermissionsClient"].ToString();
bool accessClient = false;
access = validatepermissions.getpermissions("employee", "u", dataPermissions);
accessClient = validatepermissions.getpermissions("employee", "u", dataPermissionsClient);
//if (access == true && accessClient == true)
if (true)
{
if (this.Request.IsAjaxRequest())
{
formData = CustomForm.unserialize(formData); //use the method serialize to parse the string into an array
String employeeID = (formData["employeeID"] == "null") ? null : formData["employeeID"]; //check insert new or update existing
String EmployeeName = "";
JObject employee = new JObject();
//get employee if update
if (employeeID != null)
{
String employeestring = employeetable.GetRow(employeeID);
employee = JsonConvert.DeserializeObject <JObject>(employeestring);
}
/*check when update , employee exist or not*/
if (employeeID != null && (employee == null))
{
return("{\"msg\":\"El id especificado no existe\", \"status\":\"error\"}");
}
/*The selected emoloyee Id is already in use and is not the employee who has it*/
if (employeeExists(formData["employee"]) == "true" && (employeeID == null || employeetable.get("employee", formData["employee"])[0].GetElement("_id").Value.ToString() != employeeID))
{
return("{\"msg\":\"El empleado ya está siendo utilizado\", \"status\":\"error\"}");
}
//due that the Employee's id is unique we use it has the image's name, so we store only the extension in the db
string ext = null;
if (file != null)
{
ext = file.FileName.Split('.').Last(); //getting the extension
}
else if (employeeID != null)
{
try
{
ext = employee["imgext"].ToString();
}
catch (Exception e) { }
}
//JArray listp = new JArray();
/* Format validations */
if (!Regex.IsMatch(formData["name"], "[A-ZÁÉÍÓÚÑa-záéíóúñ]+( [A-ZÁÉÍÓÚÑa-záéíóúñ]+){0,2}"))
{
return("{\"msg\":\"Formato incorrecto para: name\", \"status\":\"error\"}");
}
else if (!Regex.IsMatch(formData["lastname"], "[A-ZÁÉÍÓÚÑa-záéíóúñ]+( [A-ZÁÉÍÓÚÑa-záéíóúñ]+){0,1}"))
{
return("{\"msg\":\"Formato incorrecto para: Apellido Paterno\", \"status\":\"error\"}");
}
else if (!Regex.IsMatch(formData["motherlastname"], "[A-ZÁÉÍÓÚÑa-záéíóúñ]+( [A-ZÁÉÍÓÚÑa-záéíóúñ]+){0,1}"))
{
return("{\"msg\":\"Formato incorrecto para: Apellido Materno\", \"status\":\"error\"}");
}
else if (!Regex.IsMatch(formData["employee"], "([a-zA-Z0-9-_.]){4,}"))
{
return("{\"msg\":\"Formato incorrecto para: ID Empleado\", \"status\":\"error\"}");
}
///check selected profile id exist or not
///
else if (formData["profileId"] == "null")
{
return("{\"msg\":\"Elija El perfil\", \"status\":\"error\"}");
}
else if (employeeprofileTable.getRow(formData["profileId"]) == null)
{
return("{\"msg\":\"El perfil especificado no existe\", \"status\":\"error\"}");
}
else if (formData["type"] == "null")
{
return("{\"msg\":\"Elija El Tipo de Empleado\", \"status\":\"error\"}");
}
else if (formData["area"] == "null")
{
return("{\"msg\":\"Elija El Área\", \"status\":\"error\"}");
}
else
{
EmployeeName = formData["employee"];
}
/* Format validations */
//Change name representation
formData["name"] = CultureInfo.InvariantCulture.TextInfo.ToTitleCase(formData["name"].ToString().ToLower().Trim());
formData["lastname"] = CultureInfo.InvariantCulture.TextInfo.ToTitleCase(formData["lastname"].ToString().ToLower().Trim());
//there are fields that we know that exists so we set them into the json
String jsonData = "{'employee':'" + formData["employee"] + "','name':'" + formData["name"].Replace("+", " ") + "','imgext':'" + ext
+ "','lastname':'" + formData["lastname"].Replace("+", " ")
+ "','motherlastname':'" + formData["motherlastname"].Replace("+", " ") + "','type':'" + formData["type"]
+ "','profileId':'" + formData["profileId"] + "','area':'" + formData["area"];
try //trying to set the creator's id
{
jsonData += "','creatorId':'";
jsonData += this.Session["_id"];
jsonData += "'";
}
catch (Exception e) { /*Ignored*/ }
//remove the setted data in the json from the formData
formData.Remove("employeeID");
formData.Remove("employee");
formData.Remove("name");
formData.Remove("lastname");
formData.Remove("motherlastname");
formData.Remove("type");
formData.Remove("profileId");
formData.Remove("area");
jsonData += ", 'profileFields':{";
//foreach element in the formData, let's append it to the jsonData in the profileFields
int cont = 0;
foreach (String key in formData.Keys)
{
jsonData += "'" + key + "':'" + formData[key] + "'";
cont++;
if (cont < formData.Keys.Count)
{
jsonData += ", ";
}
}
jsonData += "}}";
//now that we have the json and we know the data is ok, let's save it
string id = employeetable.saveRow(jsonData, employeeID);
//Notify this action
if (employeeID == null)
{
Notificate.saveNotification("Employees", "Create", "El empleado '" + EmployeeName + "' ha sido creado");
_logTable.SaveLog(Session["_id"].ToString(), "empleados", "Insert: " + EmployeeName, "Employee", DateTime.Now.ToString());
}
else
{
Notificate.saveNotification("Employees", "Update", "El empleado '" + EmployeeName + "' ha sido modificado");
_logTable.SaveLog(Session["_id"].ToString(), "empleados", "Update: " + EmployeeName, "Employee", DateTime.Now.ToString());
}
//TODO:Aqui se guarda la imagen
if (file != null)
{
string relativepath = "\\Uploads\\Images\\";
string absolutepath = Server.MapPath(relativepath);
if (!System.IO.Directory.Exists(absolutepath))
{
System.IO.Directory.CreateDirectory(absolutepath);
}
file.SaveAs(absolutepath + "\\" + id + "." + ext);
Images resizeImage = new Images(absolutepath + "\\" + id + "." + ext, absolutepath, id + "." + ext);
// If image bigger than 1MB, resize to 1024px max
if (file.ContentLength > 1024 * 1024)
{
resizeImage.resizeImage(new System.Drawing.Size(1024, 1024));
}
// Create the thumbnail of the image
resizeImage.createThumb();
}
return("{\"msg\":\"" + id + "\", \"status\":\"success\"}"); //returns the saved user's id
}
return(null);
}
else
{
return(null);
}
}