public int Save(UsersEmployeeML usersEmployeeML)
{
try
{
return((usersEmployeeML.Id > 0) ? usersEmployeeDAL.Update(usersEmployeeML) : usersEmployeeDAL.Insert(usersEmployeeML));
}
catch (Exception ex)
{
throw new Exception(String.Format("{0}.Save: {1}", core, ex));
}
}
public void delete(int Id)
{
try
{
UsersEmployeeML usersEmployee = new UsersEmployeeML()
{
Id = Id
};
usersEmployeeDAL.Delete(usersEmployee);
}
catch (Exception ex)
{
throw new Exception(String.Format("{0}.Save: {1}", core, ex));
}
}
public UsersEmployeeML getEntityObject(DataRow drUserEmployee)
{
try
{
UsersEmployeeML usersEmployee = new UsersEmployeeML()
{
Id = (drUserEmployee[UsersEmployeeML.DataBase.Id] != DBNull.Value) ? int.Parse(drUserEmployee[UsersEmployeeML.DataBase.Id].ToString()) : 0,
IdEmployee = (drUserEmployee[UsersEmployeeML.DataBase.IdEmployee] != DBNull.Value) ? int.Parse(drUserEmployee[UsersEmployeeML.DataBase.IdEmployee].ToString()) : 0,
IdUser = (drUserEmployee[UsersEmployeeML.DataBase.IdUser] != DBNull.Value) ? int.Parse(drUserEmployee[UsersEmployeeML.DataBase.IdUser].ToString()) : 0
};
return(usersEmployee);
}
catch (Exception ex)
{
throw new Exception(String.Format("{0}.getEntityObject : {1}", core, ex));
}
}
public int Insert(UsersEmployeeML usersEmployee)
{
try
{
ModelDAL ModelDAL = new ModelDAL();
String Response = ModelDAL.InsertModel(usersEmployee, TableName, IdUserSession);
SqlConnection Conexion = new SqlConnection
{
ConnectionString = ConnectionString
};
Conexion.Open();
SqlCommand cmd2 = new SqlCommand(Response.ToString(), Conexion);
return(cmd2.ExecuteNonQuery());
}
catch (Exception ex)
{
throw new Exception(String.Format("{0}.Insert : {1}", core, ex));
}
}
/// <summary>
/// Función que recibe una lista de usuario para guardar al lector
/// </summary>
/// <param name="ListUser"></param>
/// <returns></returns>
public int SetUserInfo(BiometricCore.UserInfo UserInfo, int NumUser)
{
try
{
for (int index = 1; index < NumUser + 1; index++)
{
try
{
string id = string.Format("{0}00{1}", UserInfo.EnrollNumber, index);
UsersEmployeeBLL usersEmployeeBLL = new UsersEmployeeBLL();
if (!usersEmployeeBLL.UserExists(int.Parse(id)))
{
SetUserInfo(int.Parse(id), UserInfo.Name, UserInfo.Privelage, "", id);
UsersEmployeeML usersEmployeeML = usersEmployeeBLL.GetEntityByIdUser(int.Parse(UserInfo.EnrollNumber));
if (usersEmployeeML == null)
{
usersEmployeeML = new UsersEmployeeML()
{
Id = 0,
IdUser = int.Parse(id),
IdEmployee = int.Parse(UserInfo.EnrollNumber)
};
}
usersEmployeeBLL.Save(usersEmployeeML);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
return(0);
}catch (Exception ex)
{
throw new Exception(string.Format("setUserInfo: {0}", ex.Message));
}
}
public void Delete(UsersEmployeeML usersEmployee)
{
try
{
ModelDAL ModelDAL = new ModelDAL();
String Response = ModelDAL.DeleteModel(usersEmployee, TableName, IdUserSession);
SqlConnection Conexion = new SqlConnection()
{
ConnectionString = ConnectionString
};
Conexion.Open();
SqlCommand cmd2 = new SqlCommand(Response.ToString(), Conexion);
cmd2.ExecuteNonQuery();
Conexion.Close();
}
catch (Exception ex)
{
throw new Exception(String.Format("{0}.delete: {1}", core, ex));
}
}
