// GET: Client/AddClient
public ActionResult AddClient()
{
if (Session["Usuario"] == null)
{
return RedirectToAction("Login", "User");
}
var ObjAccesUser = ((MSerUser)Session["Usuario"]).UserAcces;
var ObjAcces = ObjAccesUser.Where(p => p.Action == "ListClient").First();
if (ObjAcces != null)
{
if (ObjAcces.Create == false)
{
return RedirectToAction("Index", "Home");
}
}
MPerson objPersonClient = new MPerson();
objPersonClient.Birthday = DateTime.Now.Date;
objPersonClient.listPersonContact = new List<MPersonContact>();
if (TempData["Success"] != null)
{
ViewBag.SuccessSave = TempData["Success"];
}
return View(objPersonClient);
}
public Person Save(MPerson person)
{
var institutionId = 0;
if (!string.IsNullOrEmpty(person.Institution?.Name))
{
institutionId = _uInstitution.GetExact(person.Institution.Name)?.Id ?? 0;
if (institutionId == 0)
{
institutionId = _bInstitution.Save(person.Institution.Name).Id;
}
}
var cPerson = new Person
{
Id = person.Id,
Name = person.Name,
Cpf = person.Cpf.RCpf(),
Email = person.Email,
BirthDate = person.BirthDate,
Sex = person.Sex,
Password = person.Password.Sha256Hash(),
Profile = person.Profile
};
if (institutionId != 0)
{
cPerson.InstitutionId = institutionId;
}
Save(cPerson);
_context.SaveChanges();
return(cPerson);
}
public void TestSaveConsigoCadastrarUmProfessorComInstituicaoJaExistente()
{
var institution = new Institution
{
Name = "UFLA"
};
_context.Institution.Add(institution);
_context.SaveChanges();
var mPerson = new MPerson
{
BirthDate = DateTime.Now,
Institution = new MInstitution
{
Name = "UFLA"
},
Cpf = "37551053654",
Email = "*****@*****.**",
Name = "Nome professor",
Password = "******",
Profile = (int)EProfile.Teacher,
Sex = (int)ESex.Male
};
var res = _controller.Save(mPerson) as ObjectResult;
Assert.NotNull(res);
Assert.Equal((int)HttpStatusCode.OK, res.StatusCode);
Assert.Equal("Cadastro realizado com sucesso!", ((MResponseContent)res.Value).message);
}
public ObservableCollection <MStunden> LoadStunden(MPerson value)
{
ObservableCollection <MStunden> result = new ObservableCollection <MStunden>();
_XDoc = new XmlDocument();
FileStream Stream = new FileStream(_FilePath, FileMode.Open);
_XDoc.Load(Stream);
XmlNodeList list = _XDoc.GetElementsByTagName(_SubName);
for (int i = 0; i < list.Count; i++)
{
XmlElement cl = (XmlElement)_XDoc.GetElementsByTagName(_SubName)[i];
if (cl.GetAttribute("Id").Equals(value.Id))
{
XmlNodeList l = cl.ChildNodes;
for (int j = 0; j < l.Count; j++)
{
XmlElement ca = (XmlElement)cl.GetElementsByTagName(_SubStunden)[i];
result.Add(new MStunden()
{
Id = ca.GetAttribute("Id"),
Start = ca.GetAttribute("Start"),
Ende = ca.GetAttribute("Ende"),
Pause = ca.GetAttribute("Pause")
});
}
}
}
Stream.Close();
return(result);
}
private static void AssertPerson(MPerson expected, MPerson actual)
{
Assert.AreEqual(expected.ID, actual.ID);
Assert.AreEqual(expected.Gender, actual.Gender);
Assert.AreEqual(expected.FirstName, actual.FirstName);
Assert.AreEqual(expected.LastName, actual.LastName);
Assert.AreEqual(expected.MiddleName, actual.MiddleName);
}
public void LoadStunden(MPerson value = null)
{
if (value != null)
{
foreach (MStunden std in value.Stunden)
{
ValueStunden.Add(std);
}
}
}
public void Add(MPerson value)
{
_XDoc = new XmlDocument();
_Stream = new FileStream(_FilePath, FileMode.Open);
_XDoc.Load(_Stream);
XmlElement cl = _XDoc.CreateElement(_SubName);
cl.SetAttribute("Id", value.Id);
cl.SetAttribute("VName", Crypt.EncryptString(value.VName, value.Id));
cl.SetAttribute("NName", Crypt.EncryptString(value.NName, value.Id));
cl.SetAttribute("Mid", Crypt.EncryptString(value.Mid, value.Id));
cl.SetAttribute("TaughtNr", value.TaughtNr);
_XDoc.DocumentElement.AppendChild(cl);
_Stream.Close();
_XDoc.Save(_FilePath);
}
/// <summary>
/// 测试修改
/// </summary>
public static void UpdatePerson()
{
try
{
MPerson model = new MPerson();
model.PersonName = "张三";
model.PersonHome = "上海";
BPerson bll = new BPerson();
int result = bll.UpdatePerson(model);
Console.WriteLine("结果:" + result);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
// GET: Employee/EditEmployee/5
public ActionResult EditEmployee(int?id)
{
if (Session["Usuario"] == null)
{
return(RedirectToAction("Login", "User"));
}
var ObjAccesUser = ((MSerUser)Session["Usuario"]).UserAcces;
var ObjAcces = ObjAccesUser.Where(p => p.Action == "ListEmployee").First();
if (ObjAcces != null)
{
if (ObjAcces.Edit == false)
{
return(RedirectToAction("Index", "Home"));
}
}
//Aqui se trae el modelo enviado por POST desde la Lista, para que no se vea en la Url
if (TempData["DataPersonEmployee"] != null)
{
var objTempData = Newtonsoft.Json.JsonConvert.DeserializeObject <MPerson>((string)TempData["DataPersonEmployee"]);
if (objTempData != null && objTempData.IdPerson > 0)
{
id = objTempData.IdPerson;
}
else
{
return(RedirectToAction("ListEmployee", "Employee"));
}
}
if (id == null)
{
return(RedirectToAction("ListEmployee", "Employee"));
}
//-----------------------------------------------------
MPerson objPersonEmployee = new MPerson();
objPersonEmployee = PersonController.fnListPerson(id, 2).First(); //2-empleado
if (TempData["Success"] != null)
{
ViewBag.SuccessSave = TempData["Success"];
}
return(View(objPersonEmployee));
}
public ActionResult EditClient(MPerson objPersonClient)
{
try
{
if (ModelState.IsValid)
{
//valores por defecto
objPersonClient.IdPersonType = 1; //tipo cliente
string mensaje = "";
int resultDb = PersonController.fnGNTranPerson(objPersonClient, "U", ref mensaje);
if (resultDb != 0)
{
TempData["Success"] = mensaje;
//Para evitar que se vea el id en la Url------------
MPerson objMPerson = new MPerson();
objMPerson.IdPerson = objPersonClient.IdPerson;
var jsonString = Newtonsoft.Json.JsonConvert.SerializeObject(objMPerson);
TempData["DataPersonClient"] = jsonString;
return RedirectToAction("EditClient");
//---------------------------------------------------
//return RedirectToAction("EditClient", new { id = objPersonClient.IdPerson });
}
else
{
ViewBag.ErrorSave = mensaje;
return View(objPersonClient);
}
}
else
{
ViewBag.ErrorSave = "Error al grabar, Por favor verifique los datos ingresados.";
return View(objPersonClient);
}
}
catch (Exception ex)
{
ViewBag.ErrorSave = "Error al grabar datos del cliente: " + ex.Message;
return View(objPersonClient);
}
}
public void Delete(MPerson value)
{
_XDoc = new XmlDocument();
_Stream = new FileStream(_FilePath, FileMode.Open);
_XDoc.Load(_Stream);
XmlNodeList list = _XDoc.GetElementsByTagName(_SubName);
for (int i = 0; i < list.Count; i++)
{
XmlElement cl = (XmlElement)_XDoc.GetElementsByTagName(_SubName)[i];
if (value.Id.Equals(cl.GetAttribute("Id")))
{
_XDoc.DocumentElement.RemoveChild(cl);
break;
}
}
_Stream.Close();
_XDoc.Save(_FilePath);
}
public void TestSaveConsigoCadastrarUmProfessorSemInstituicao()
{
var mPerson = new MPerson
{
BirthDate = DateTime.Now,
Cpf = "43754264206",
Email = "*****@*****.**",
Name = "Nome professor",
Password = "******",
Profile = (int)EProfile.Teacher,
Sex = (int)ESex.Male
};
var res = _controller.Save(mPerson) as ObjectResult;
Assert.NotNull(res);
Assert.Equal((int)HttpStatusCode.OK, res.StatusCode);
Assert.Equal("Cadastro realizado com sucesso!", ((MResponseContent)res.Value).message);
}
public ActionResult ListClient()
{
if (Session["Usuario"] == null)
{
return RedirectToAction("Login", "User");
}
var ObjAccesUser = ((MSerUser)Session["Usuario"]).UserAcces;
var ObjAcces = ObjAccesUser.Where(p => p.Action == "ListClient").First();
if(ObjAcces!=null)
{
if(ObjAcces.Visible ==false)
{
return RedirectToAction("Index", "Home");
}
}
MPerson objMPerson = new MPerson();
return View(objMPerson);
}
public ActionResult ListClient(string submit, MPerson objMPerson)
{
if (objMPerson == null || objMPerson.IdPerson == 0)
{
return View();
}
var jsonString = Newtonsoft.Json.JsonConvert.SerializeObject(objMPerson);
TempData["DataPersonClient"] = jsonString;
switch (submit)
{
case "searchRow":
return RedirectToAction("DetailClient", "Client");
case "editRow":
return RedirectToAction("EditClient", "Client");
default:
return View();
}
}
public void TestSaveNaoConsigoCadastrarUmaPessoaComEmailExistente()
{
var mPerson = new MPerson
{
BirthDate = DateTime.Now,
Institution = null,
Cpf = "02820214428",
Email = "*****@*****.**",
Name = "Nome professor",
Password = "******",
Profile = (int)EProfile.Teacher,
Sex = (int)ESex.Male
};
var res = _controller.Save(mPerson) as ObjectResult;
Assert.NotNull(res);
Assert.Equal((int)HttpStatusCode.BadRequest, res.StatusCode);
Assert.Equal("Campo(s) inválido(s)!", ((MResponseContent)res.Value).message);
}
public void TestSaveNaoConsigoCadastrarUmaPessoaComSenhaInvalida()
{
var mPerson = new MPerson
{
BirthDate = DateTime.Now,
Institution = null,
Cpf = "52660410216",
Email = "*****@*****.**",
Name = "Nome professor",
Password = "******",
Profile = (int)EProfile.Teacher,
Sex = (int)ESex.Male
};
var res = _controller.Save(mPerson) as ObjectResult;
Assert.NotNull(res);
Assert.Equal((int)HttpStatusCode.BadRequest, res.StatusCode);
Assert.Equal("Campo(s) inválido(s)!", ((MResponseContent)res.Value).message);
}
// GET: Client/DetailClient/5
public ActionResult DetailClient(int? id)
{
if (Session["Usuario"] == null)
{
return RedirectToAction("Login", "User");
}
var ObjAccesUser = ((MSerUser)Session["Usuario"]).UserAcces;
var ObjAcces = ObjAccesUser.Where(p => p.Action == "ListClient").First();
if (ObjAcces != null)
{
if (ObjAcces.Search == false)
{
return RedirectToAction("Index", "Home");
}
}
//Aqui se trae el modelo enviado por POST desde la Lista, para que no se vea en la Url
if (TempData["DataPersonClient"] != null)
{
var objTempData = Newtonsoft.Json.JsonConvert.DeserializeObject<MPerson>((string)TempData["DataPersonClient"]);
if (objTempData != null && objTempData.IdPerson > 0)
{
id = objTempData.IdPerson;
}
else
{
return RedirectToAction("ListClient", "Client");
}
}
if (id == null)
{
return RedirectToAction("ListClient", "Client");
}
//-----------------------------------------------------
MPerson objPersonClient = new MPerson();
objPersonClient = PersonController.fnListPerson(id, 1).First(); //1-cliente
return View(objPersonClient);
}
/// <summary>
/// 测试添加人员列表
/// </summary>
public static void AddPersonList()
{
try
{
BPerson bll = new BPerson();
MPerson model = new MPerson();
model.PersonName = "艾玛";
model.PersonHome = "美国";
List <MPerson> list = new List <MPerson>();
list.Add(model);
model = new MPerson();
model.PersonName = "汤姆";
model.PersonHome = "美国";
list.Add(model);
bool result = bll.AddPersonList(list);
Console.WriteLine(result);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public void Update(MPerson value)
{
_XDoc = new XmlDocument();
_Stream = new FileStream(_FilePath, FileMode.Open);
_XDoc.Load(_Stream);
XmlNodeList list = _XDoc.GetElementsByTagName(_SubName);
for (int i = 0; i < list.Count; i++)
{
XmlElement cl = (XmlElement)_XDoc.GetElementsByTagName(_SubName)[i];
if (value.Id.Equals(cl.GetAttribute("Id")))
{
cl.SetAttribute("VName", Crypt.EncryptString(value.VName, value.Id));
cl.SetAttribute("NName", Crypt.EncryptString(value.NName, value.Id));
cl.SetAttribute("Mid", Crypt.EncryptString(value.Mid, value.Id));
cl.SetAttribute("TaughtNr", value.TaughtNr);
break;
}
}
_Stream.Close();
_XDoc.Save(_FilePath);
}
public IActionResult Save([FromBody] MPerson person)
{
if (person == null)
{
return(BadRequest(ResponseContent.Create(null, HttpStatusCode.BadRequest, "Existe(m) campo(s) obrigatório(s) vazio(s)!")));
}
var errors = new List <MModelError>();
person.ListErrors(_uPerson, ref errors);
if (errors.Any())
{
return(BadRequest(ResponseContent.Create(errors, HttpStatusCode.BadRequest, "Campo(s) inválido(s)!")));
}
var newPerson = _bPerson.Save(person);
_bHistory.SaveHistory(newPerson.Id, "Usuário registrou no sistema");
return(Ok(ResponseContent.Create(null, HttpStatusCode.Created, "Cadastro realizado com sucesso!")));
}
public IActionResult Me()
{
if (!HttpContext.Session.IsAuth())
{
return(StatusCode((int)HttpStatusCode.Unauthorized, ResponseContent.Create(null, HttpStatusCode.Unauthorized, "Não autorizado!")));
}
var person = _uPerson.GetById(HttpContext.Session.GetSessionPersonId());
var mPerson = new MPerson
{
Name = person.Name,
Cpf = person.Cpf,
Email = person.Email,
Institution = new MInstitution
{
Id = person.Institution?.Id ?? 0,
Name = person.Institution?.Name
},
Profile = person.Profile,
Photo = person.PhotoPath
};
return(Ok(ResponseContent.Create(mPerson, HttpStatusCode.OK, null)));
}
public ObservableCollection <MPerson> Load()
{
ObservableCollection <MPerson> result = new ObservableCollection <MPerson>();
_XDoc = new XmlDocument();
_Stream = new FileStream(_FilePath, FileMode.Open);
_XDoc.Load(_Stream);
XmlNodeList list = _XDoc.GetElementsByTagName(_SubName);
for (int i = 0; i < list.Count; i++)
{
XmlElement cl = (XmlElement)_XDoc.GetElementsByTagName(_SubName)[i];
MPerson r = new MPerson()
{
Id = cl.GetAttribute("Id"),
VName = Crypt.DecryptString(cl.GetAttribute("VName"), cl.GetAttribute("Id")),
NName = Crypt.DecryptString(cl.GetAttribute("NName"), cl.GetAttribute("Id")),
Mid = Crypt.DecryptString(cl.GetAttribute("Mid"), cl.GetAttribute("Id")),
TaughtNr = cl.GetAttribute("TaughtNr"),
Stunden = new ObservableCollection <MStunden>()
};
for (int j = 0; j < cl.ChildNodes.Count; j++)
{
XmlElement ca = (XmlElement)cl.ChildNodes[j];
r.Stunden.Add(new MStunden()
{
Id = ca.GetAttribute("Id"),
Start = ca.GetAttribute("Start"),
Ende = ca.GetAttribute("Ende"),
Pause = ca.GetAttribute("Pause")
});
}
result.Add(r);
}
_Stream.Close();
return(result);
}
public ActionResult AddClient(MPerson objPersonClient)
{
try
{
if (ModelState.IsValid)
{
//valores por defecto
objPersonClient.Status = true; //activo
objPersonClient.IdPersonType = 1; //tipo cliente
string mensaje = "";
int resultDb = PersonController.fnGNTranPerson(objPersonClient, "I", ref mensaje);
if (resultDb != 0)
{
TempData["Success"] = mensaje;
return RedirectToAction("AddClient");
}
else
{
ViewBag.ErrorSave = mensaje;
return View(objPersonClient);
}
}
else
{
ViewBag.ErrorSave = "Error al grabar, Por favor verifique los datos ingresados.";
return View(objPersonClient);
}
}
catch (Exception ex)
{
ViewBag.ErrorSave = "Error al grabar datos del cliente: " + ex.Message;
return View(objPersonClient);
}
}
public void AddStunden(MStunden stunden, MPerson person)
{
_XDoc = new XmlDocument();
_Stream = new FileStream(_FilePath, FileMode.Open);
_XDoc.Load(_Stream);
XmlNodeList list = _XDoc.GetElementsByTagName(_SubName);
for (int i = 0; i < list.Count; i++)
{
XmlElement cl = (XmlElement)_XDoc.GetElementsByTagName(_SubName)[i];
if (person.Id.Equals(cl.GetAttribute("Id")))
{
XmlElement ca = _XDoc.CreateElement(_SubStunden);
ca.SetAttribute("Id", stunden.Id);
ca.SetAttribute("Start", stunden.Start);
ca.SetAttribute("Ende", stunden.Ende);
ca.SetAttribute("Pause", stunden.Pause);
cl.AppendChild(ca);
break;
}
}
_Stream.Close();
_XDoc.Save(_FilePath);
}
public DPersonAddEdit(MPerson person = null)
{
InitializeComponent();
this.WindowStyle = WindowStyle.None;
if (person == null)
{
Value = new MPerson()
{
Id = Guid.NewGuid().ToString(),
VName = "Max",
NName = "Mustermann",
Mid = "000",
TaughtNr = ""
};
}
else
{
Value = person;
}
VName.Text = Value.VName;
NName.Text = Value.NName;
Mid.Text = Value.Mid;
TaughtNr.Text = Value.TaughtNr;
}
public static int fnGNTranPerson(MPerson objPerson, string TransactionType, ref string Mensaje)
{
try
{
TextInfo ti = CultureInfo.CurrentCulture.TextInfo; //para capitalizar textos
MMEnterprisesEntities db = new MMEnterprisesEntities();
int IdPerson;
int IdContact;
int SqlResultPerson;
int SqlResult;
SqlParameter paramOutIdPerson = new SqlParameter();
paramOutIdPerson.ParameterName = "@IdPerson";
paramOutIdPerson.SqlDbType = System.Data.SqlDbType.Int;
paramOutIdPerson.Direction = System.Data.ParameterDirection.InputOutput;
paramOutIdPerson.Value = objPerson.IdPerson;
SqlParameter paramIdContactType = new SqlParameter();
paramIdContactType.ParameterName = "@IdContactType";
paramIdContactType.SqlDbType = System.Data.SqlDbType.Int;
paramIdContactType.Direction = System.Data.ParameterDirection.Input;
paramIdContactType.IsNullable = true;
if (objPerson.IdContactType != null)
{
paramIdContactType.Value = objPerson.IdContactType;
}
else
{
paramIdContactType.Value = DBNull.Value;
}
SqlParameter paramIdPosition = new SqlParameter();
paramIdPosition.ParameterName = "@IdPosition";
paramIdPosition.SqlDbType = System.Data.SqlDbType.Int;
paramIdPosition.Direction = System.Data.ParameterDirection.Input;
paramIdPosition.IsNullable = true;
if (objPerson.IdPosition != null)
{
paramIdPosition.Value = objPerson.IdPosition;
}
else
{
paramIdPosition.Value = DBNull.Value;
}
SqlParameter paramIdDepartment = new SqlParameter();
paramIdDepartment.ParameterName = "@IdDepartment";
paramIdDepartment.SqlDbType = System.Data.SqlDbType.Int;
paramIdDepartment.Direction = System.Data.ParameterDirection.Input;
paramIdDepartment.IsNullable = true;
if (objPerson.IdDepartment != null)
{
paramIdDepartment.Value = objPerson.IdDepartment;
}
else
{
paramIdDepartment.Value = DBNull.Value;
}
MUser objUser = new MUser();
SqlResultPerson = db.Database.ExecuteSqlCommand("GNTranPerson @TransactionType, @IdPerson OUT, @IdPersonType " +
", @IdIdentificationType, @strNumIdentification, @strName, @strLastName, @dttBirthday " +
", @strAddress, @strEmail, @IdContactType, @IdPosition, @btClientPermission, @btStatus, @IdDepartment ",
new SqlParameter[] {
new SqlParameter("@TransactionType", TransactionType),
paramOutIdPerson,
new SqlParameter("@IdPersonType", objPerson.IdPersonType),
new SqlParameter("@IdIdentificationType", objPerson.IdIdentificationType),
new SqlParameter("@strNumIdentification", objUser.Encriptar(objPerson.NumIdentification)),
new SqlParameter("@strName", ti.ToTitleCase(objPerson.Name)),
new SqlParameter("@strLastName", ti.ToTitleCase(objPerson.LastName)),
new SqlParameter("@dttBirthday", objPerson.Birthday),
new SqlParameter("@strAddress", objUser.Encriptar(objPerson.Address)),
new SqlParameter("@strEmail", objPerson.Email),
paramIdContactType,
paramIdPosition,
new SqlParameter("@btClientPermission", objPerson.ClientPermission),
new SqlParameter("@btStatus", objPerson.Status),
paramIdDepartment
}
);
IdPerson = Int32.Parse(paramOutIdPerson.Value.ToString());
if (IdPerson != 0)
{
if (objPerson.listPersonContact != null)
{
if (objPerson.listPersonContact.Count() > 0)
{
//si va a actualizar, se eliminan los telefonos de contacto para volver a insertar
if (TransactionType == "U")
{
SqlParameter paramOutIdContact = new SqlParameter("@IdContact", System.Data.SqlDbType.Int);
paramOutIdContact.Direction = System.Data.ParameterDirection.Output;
SqlResult = db.Database.ExecuteSqlCommand("GNTranPersonContact @TransactionType, @IdContact OUT, @IdPerson " +
", @IdPhoneNumberType, @strIdIsoCountry, @strPhoneNumber, @btStatus ",
new SqlParameter[] {
new SqlParameter("@TransactionType", TransactionType),
paramOutIdContact,
new SqlParameter("@IdPerson", IdPerson),
new SqlParameter("@IdPhoneNumberType", DBNull.Value),
new SqlParameter("@strIdIsoCountry", DBNull.Value),
new SqlParameter("@strPhoneNumber", DBNull.Value),
new SqlParameter("@btStatus", DBNull.Value)
}
);
}
//Inserta los telefonos de contacto
foreach (var item in objPerson.listPersonContact)
{
SqlParameter paramOutIdContact = new SqlParameter("@IdContact", System.Data.SqlDbType.Int);
paramOutIdContact.Direction = System.Data.ParameterDirection.Output;
SqlResult = db.Database.ExecuteSqlCommand("GNTranPersonContact @TransactionType, @IdContact OUT, @IdPerson " +
", @IdPhoneNumberType, @strIdIsoCountry, @strPhoneNumber, @btStatus ",
new SqlParameter[] {
new SqlParameter("@TransactionType", "I"),
paramOutIdContact,
new SqlParameter("@IdPerson", IdPerson),
new SqlParameter("@IdPhoneNumberType", item.IdPhoneNumberType),
new SqlParameter("@strIdIsoCountry", item.IdIsoCountry),
new SqlParameter("@strPhoneNumber", objUser.Encriptar(item.PhoneNumber)),
new SqlParameter("@btStatus", true)
}
);
IdContact = Int32.Parse(paramOutIdContact.Value.ToString());
}
}
}
//Mensaje = "Datos grabados exitosamente para el Código de empleado: (" + IdPerson + ").";
Mensaje = "Datos grabados exitosamente.";
}
else
{
Mensaje = "No se pudo realizar la transaccion, intente nuevamente.";
}
return(SqlResultPerson);
}
catch (SqlException ex)
{
Mensaje = "Error al grabar datos: " + ex.Message;
return(0);
}
}
