public static user convertToDal(User_Entity u)
{
return(new user()
{
u_id = u.u_id,
u_phone = u.u_phone
});
}
public List <User_Entity> GetLogin()
{
string query = "SELECT Username,Password FROM User_base";
SqlDataReader reader = Connection_Database.GetData(query);
User_Entity login = null;
List <User_Entity> loginlist = new List <User_Entity>();
int count = 0;
while (reader.Read())
{
count = count + 1;
}
if (count == 1)
{
login.Username = reader["Username"].ToString();
login.Password = reader["Password"].ToString();
loginlist.Add(login);
}
return(loginlist);
}
private void pictureBox8_Click(object sender, EventArgs e)
{
User_Entity user = new User_Entity();
user.Name = nameTextbox.Text;
user.Email = EmailTextbox.Text;
user.Username = usernametextbox.Text;
user.Phone = phntextbox.Text;
user.Password = paswrdtextbox.Text;
User_service userservice = new User_service();
if (userservice.Add(user) > 0)
{
MessageBox.Show("Registration successfully");
}
User go = new User();
go.Show();
this.Hide();
}
public string GetUserInfoDetailById(clsUser_Info obj)
{
string result = "";
try
{
User_Entity objEntities = new User_Entity();
List <SP_UserInfo_SelectOneResult> objResult = new List <SP_UserInfo_SelectOneResult>();
objResult = objEntities.GetUserInfoDetailById(obj);
result = objResult.ToJSON();
}
catch (Exception ex)
{
LoggerFactory.LoggerInstance.LogException(ex);
}
finally
{
LoggerFactory.LoggerInstance.LogDebug("Response Value : " + result);
}
return(result);
}
public string UpdateUserInfo(clsUser_Info obj)
{
string result = "";
try
{
User_Entity objEntities = new User_Entity();
// SP_customers_SelectOneResult CustomerData = new SP_customers_SelectOneResult();
int objResult;
objResult = objEntities.UpdateUserInfo(obj);
result = objResult.ToJSON();
}
catch (Exception ex)
{
LoggerFactory.LoggerInstance.LogException(ex);
}
finally
{
LoggerFactory.LoggerInstance.LogDebug("Response Value : " + result);
}
return(result);
}
private void submit_Click(object sender, EventArgs e)
{
User_service service = new User_service();
User_Entity passenger = new User_Entity();
Choch set = new Choch();
passenger.Name = nametextbox.Text;
passenger.Phone = phntextbox.Text;
passenger.Choch_No = Coach.Text;
passenger.Seat_no = membertextbox.Text;
User_service userservice = new User_service();
if (userservice.Add_passrnger(passenger) > 0)
{
MessageBox.Show("passenger add successfully");
}
set.Seat_no = seatnotextbox.Text;
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "UPDATE Choach SET No_Seat=No_Seat+'" + seatnotextbox.Text + "' where Choach_No='" + Coach.Text + "'";
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Succesfully submitted");
passengername = nametextbox.Text;
date = dateTimePicker.Text;
bus_no = Coach.Text;
seat_member = seatnotextbox.Text;
No_of_seat = membertextbox.Text;
source = fromComboBox.SelectedValue.ToString();
destination = toComboBox.SelectedValue.ToString();
Payment pay = new Payment();
pay.Show();
this.Hide();
}
public IHttpActionResult addUser(User_Entity newUser)
{
BLL.BLL_User.AddUser(newUser);
return(Ok("user added successfuly"));
}
public int Add_passrnger(User_Entity passenger)
{
return(useraccess.Add_passenger(passenger));
}
public int Add(User_Entity user)
{
return(useraccess.Add(user));
}
//הוספת משתמש
public static void AddUser(User_Entity user)
{
db.users.Add(Convert_User.convertToDal(user));
db.SaveChanges();
}
public int AddUser(User_Entity user_Entity)
{
return(1);
}
//add passenger
public int Add_passenger(User_Entity passenger)
{
string query = string.Format("INSERT INTO Passenger(Name,Phone,Choach_no,Seat_name) VALUES('{0}', '{1}','{2}','{3}')", passenger.Name, passenger.Phone, passenger.Choch_No, passenger.Seat_no);
return(Connection_Database.ExecuteQuery(query));
}
public int Add(User_Entity user)
{
string query = string.Format("INSERT INTO User_base(Name,Email,Username,Phone,Password) VALUES('{0}', '{1}','{2}','{3}','{4}')", user.Name, user.Email, user.Username, user.Phone, user.Password);
return(Connection_Database.ExecuteQuery(query));
}
public async Task <ActionResult <User_Entity> > PostManager([FromBody] InviteViewModel input)
{
var user = _userEntityRepository.GetByUserId(input.InviterId, input.EntityId);
var Newuser = _userEntityRepository.GetByUserId(input.NewMemberId, input.EntityId);
User New = await _userRepository.Get(input.NewMemberId);
Entity ent = await _entityRepository.Get(input.EntityId);
var userEntity = new User_Entity(New, ent, Role.Manager);
Boolean admin = false;
if (user.Role == Role.Manager)
{
admin = true;
}
var childEntity = _childRepository.GetByParentId(input.EntityId);
List <int> childs = new List <int>();
foreach (ChildEntity ee in childEntity)
{
int childId = ee.ChildId;
childs.Add(childId);
}
if (Newuser is null) // sig que the new user is not a (member , manager or observer ) in this entity
{
System.Diagnostics.Debug.WriteLine("the new user is not a (member , manager or observer ) in this entity ");
if (admin)
{
if (input.NewRole == 0) // we want to invite the new user as a manager to the entity
{
foreach (int i in childs) // we make the journey on all the chids of the entity to make the newuser as a manager also at thoses entities
{
Entity ii = await _entityRepository.Get(i);
var childuserEnt = new User_Entity(New, ii, Role.Manager); //make the new user as a manager to the child af the entity
var childwallPerm = new WallPermission(input.NewMemberId, i, true, true, true, true, true, true, true);
var childokrPerm = new OKRPermission(input.NewMemberId, i, true, true, true, true, true, true, true, true, true, true);
var childorgPerm = new OrganizationPermission(input.NewMemberId, i, true, true, true);
var childnotifPerm = new NotificationPermission(input.NewMemberId, i, true);
await _wallRepository.Add(childwallPerm);
await _okrRepository.Add(childokrPerm);
await _organizationRepository.Add(childorgPerm);
await _notificationRepository.Add(childnotifPerm);
await _userEntityRepository.Add(childuserEnt);
}
var wallPerm = new WallPermission(input.NewMemberId, input.EntityId, true, true, true, true, true, true, true);
var okrPerm = new OKRPermission(input.NewMemberId, input.EntityId, true, true, true, true, true, true, true, true, true, true);
var orgPerm = new OrganizationPermission(input.NewMemberId, input.EntityId, true, true, true);
var notifPerm = new NotificationPermission(input.NewMemberId, input.EntityId, true);
await _wallRepository.Add(wallPerm);
await _okrRepository.Add(okrPerm);
await _organizationRepository.Add(orgPerm);
await _notificationRepository.Add(notifPerm);
await _userEntityRepository.Add(userEntity);
Console.WriteLine("Creating Manager:" + New.UserId);
}
}
}
else
{
System.Diagnostics.Debug.WriteLine("the new user is a (member , manager or observer ) in this entity ");
Newuser.Role = 0;
System.Diagnostics.Debug.WriteLine(Newuser.Role);
//await _userEntityRepository.Update(Newuser);
User_Entity NewChange = await _userEntityRepository.Update(Newuser);
var wallPerm1 = _wallRepository.GetByUserEntityId(input.NewMemberId, input.EntityId);
var okrPer1 = _okrRepository.GetByUserEntityId(input.NewMemberId, input.EntityId);
var orgPerm1 = _organizationRepository.GetOrgPermission(input.NewMemberId, input.EntityId);
var notifPerm1 = _notificationRepository.GetByUserEntityId(input.NewMemberId, input.EntityId);
System.Diagnostics.Debug.WriteLine(wallPerm1.Add);
wallPerm1.Add = true; wallPerm1.AddEmployees = true; wallPerm1.Delete = true; wallPerm1.DeleteEmployees = true; wallPerm1.DisplayFivePointQuestionUser = true; wallPerm1.Observe = true; wallPerm1.Update = true;
okrPer1.Add = true; okrPer1.AddEmployees = true; okrPer1.Delete = true; okrPer1.DeleteEmployees = true; okrPer1.Observe = true; okrPer1.Update = true; okrPer1.ObserveKResult = true; okrPer1.updateKResult = true; okrPer1.DeleteKResult = true; okrPer1.AddKResult = true;
orgPerm1.AddEntities = true; orgPerm1.ChangeOrganizationProfile = true; orgPerm1.ChangeSettings = true;
notifPerm1.GetNotification = true;
await _wallRepository.Update(wallPerm1);
await _okrRepository.Update(okrPer1);
await _organizationRepository.Update(orgPerm1);
await _notificationRepository.Update(notifPerm1);
foreach (int i in childs) // we make the journey on all the chids of the entity to make the newuser as a manager also at thoses entities
{
Entity ii = await _entityRepository.Get(i);
var entityuserchild = _userEntityRepository.GetByUserId(input.NewMemberId, i);
entityuserchild.Role = input.NewRole;
await _userEntityRepository.Update(entityuserchild);
var wallPerm = _wallRepository.GetByUserEntityId(Newuser.Id, i);
var okrPer = _okrRepository.GetByUserEntityId(Newuser.Id, i);
var orgPerm = _organizationRepository.GetOrgPermission(Newuser.Id, i);
var notifPerm = _notificationRepository.GetByUserEntityId(Newuser.Id, i);
wallPerm.Add = true; wallPerm.AddEmployees = true; wallPerm.Delete = true; wallPerm.DeleteEmployees = true; wallPerm.DisplayFivePointQuestionUser = true; wallPerm.Observe = true; wallPerm.Update = true;
okrPer.Add = true; okrPer.AddEmployees = true; okrPer.Delete = true; okrPer.DeleteEmployees = true; okrPer.Observe = true; okrPer.Update = true; okrPer.ObserveKResult = true; okrPer.updateKResult = true; okrPer.DeleteKResult = true; okrPer.AddKResult = true;
orgPerm.AddEntities = true; orgPerm.ChangeOrganizationProfile = true; orgPerm.ChangeSettings = true;
notifPerm.GetNotification = true;
await _wallRepository.Update(wallPerm);
await _okrRepository.Update(okrPer);
await _organizationRepository.Update(orgPerm);
await _notificationRepository.Update(notifPerm);
await context.SaveChangesAsync();
}
Console.WriteLine("Creating Manager:" + New.UserId);
return(CreatedAtAction("Get", NewChange));
}
return(CreatedAtAction("Get", userEntity));
}
public async Task <ActionResult <User_Entity> > PostObserver([FromBody] InviteViewModel input)
{
var user = _userEntityRepository.GetByUserId(input.InviterId, input.EntityId);
var Newuser = _userEntityRepository.GetByUserId(input.NewMemberId, input.EntityId);
User New = await _userRepository.Get(input.NewMemberId);
Entity ent = await _entityRepository.Get(input.EntityId);
var userEntity = new User_Entity(New, ent, Role.Observer);
Boolean admin = false;
if (!(user is null))
{
if (user.Role == Role.Manager)
{
admin = true;
}
}
if (admin)
{
if (Newuser is null)
{
if (input.NewRole == Role.Observer)
{
var wallPerm = new WallPermission(input.NewMemberId, input.EntityId, false, false, false, true, false, false, false);
var okrPerm = new OKRPermission(input.NewMemberId, input.EntityId, false, false, false, true, false, false, false, false, false, false);
//var orgPerm = new OrganizationPermission(input.NewMemberId, input.EntityId, true, true, true);
var notifPerm = new NotificationPermission(input.NewMemberId, input.EntityId, true);
await _wallRepository.Add(wallPerm);
await _okrRepository.Add(okrPerm);
//await _organizationRepository.Add(orgPerm);
await _notificationRepository.Add(notifPerm);
await _userEntityRepository.Add(userEntity);
Console.WriteLine("Creating Observer:" + New.UserId);
}
return(CreatedAtAction("Get", userEntity));
}
else if (Newuser.Role == Role.Manager)
{
return(Ok("this user is Manager "));
}
else
{
Newuser.Role = input.NewRole;
User_Entity NewChange = await _userEntityRepository.Update(Newuser);
Console.WriteLine("Creating Observer:" + New.UserId);
return(CreatedAtAction("Get", NewChange));
}
}
else
{
return(Ok("the inviter is not a manager for the entity "));
}
}
