public Result SaveMeetingRoom(DAL.db.MeetingRoom meetingRoom)
{
_mrFactory = new MeetingRoomFactory();
try
{
if (meetingRoom.MeetingRoomID > 0)
{
_mrFactory.Edit(meetingRoom);
_result = _mrFactory.Save();
if (_result.isSucess)
{
_result.message = _result.UpdateSuccessfull(tableName);
}
}
else
{
_mrFactory.Add(meetingRoom);
_result = _mrFactory.Save();
if (_result.isSucess)
{
_result.message = _result.SaveSuccessfull(tableName);
}
}
}
catch (Exception e)
{
_result.isSucess = false;
_result.message = e.Message;
}
return(_result);
}
public Result SaveAppointment(DAL.db.Appointment appointment)
{
_unScheduleAppointment = new UnScheduleAppointmentFactory();
try
{
if (appointment.AppointmentID > 0)
{
_unScheduleAppointment.Edit(appointment);
_result = _unScheduleAppointment.Save();
if (_result.isSucess)
{
_result.message = _result.UpdateSuccessfull(tableName);
}
}
else
{
_unScheduleAppointment.Add(appointment);
_result = _unScheduleAppointment.Save();
if (_result.isSucess)
{
_result.message = _result.SaveSuccessfull(tableName);
}
}
}
catch (Exception e)
{
_result.isSucess = false;
_result.message = e.Message;
}
return(_result);
}
public Result SaveEmployee(Employee emp)
{
Result _result = new Result();
try
{
_employeeFactory = new EmployeeFactory();
if (emp.EmployeeID < 1)
{
_employeeFactory.Add(emp);
_result = _employeeFactory.Save();
if (_result.isSucess)
{
_result.message = _result.SaveSuccessfull(tableName);
}
}
else
{
_employeeFactory.Edit(emp);
_result = _employeeFactory.Save();
if (_result.isSucess)
{
_result.message = _result.UpdateSuccessfull(tableName);
}
}
}
catch (Exception ex)
{
_result.isSucess = false;
_result.message = ex.Message;
}
return(_result);
}
public Result SaveCompanyBranch(SET_CompanyBranch companyBranch)
{
_result = new Result();
_companyBranchFactory = new CompanyBranchFactory();
try
{
Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues();
int userGroupId = Convert.ToInt32(dictionary[6].Id == "" ? 0 : Convert.ToInt32(dictionary[6].Id));
if (userGroupId != 0)
{
if (companyBranch.BranchID > 0)
{
_companyBranchFactory.Edit(companyBranch);
_result = _companyBranchFactory.Save();
}
else
{
int branchID = 1;
var prvBranchID = _companyBranchFactory.GetLastRecord().OrderByDescending(x => x.BranchID).FirstOrDefault();
if (prvBranchID != null)
{
branchID = prvBranchID.BranchID + 1;
}
companyBranch.BranchID = branchID;
_companyBranchFactory.Add(companyBranch);
_result = _companyBranchFactory.Save();
}
}
else
{
_result.isSucess = false;
_result.message = "Logout";
}
}
catch (Exception e)
{
_result.isSucess = false;
_result.message = e.Message;
}
return(_result);
}
public Result SaveDepartment(Department dept)
{
Result _result = new Result();
try
{
_departmentFactory = new DepartmentFactory();
if (dept.DepartmentID < 1)
{
_departmentFactory.Add(dept);
_result = _departmentFactory.Save();
if (_result.isSucess)
{
_result.isSucess = true;
_result.message = _result.SaveSuccessfull(tableName);
}
}
else
{
_departmentFactory.Edit(dept);
_result = _departmentFactory.Save();
if (_result.isSucess)
{
_result.isSucess = true;
_result.message = _result.UpdateSuccessfull(tableName);
}
}
}
catch (Exception ex)
{
_result.isSucess = false;
_result.message = ex.Message;
}
return(_result);
}
public Result SaveDesignation(Designation designation)
{
Result _result = new Result();
try
{
_esignationFactory = new DesignationFactory();
if (designation.DesignationID < 1)
{
_esignationFactory.Add(designation);
_result = _esignationFactory.Save();
if (_result.isSucess)
{
_result.isSucess = true;
_result.message = _result.SaveSuccessfull(tableName);
}
}
else
{
_esignationFactory.Edit(designation);
_result = _esignationFactory.Save();
if (_result.isSucess)
{
_result.isSucess = true;
_result.message = _result.UpdateSuccessfull(tableName);
}
}
}
catch (Exception ex)
{
_result.isSucess = false;
_result.message = ex.Message;
}
return(_result);
}
public ActionResult Login(LogOnModel model)
{
try
{
if (ModelState.IsValid)
{
bool getLan = false;
string visitorIpAddress = System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (String.IsNullOrEmpty(visitorIpAddress))
{
visitorIpAddress = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
}
if (string.IsNullOrEmpty(visitorIpAddress))
{
visitorIpAddress = System.Web.HttpContext.Current.Request.UserHostAddress;
}
if (string.IsNullOrEmpty(visitorIpAddress) || visitorIpAddress.Trim() == "::1")
{
getLan = true;
visitorIpAddress = string.Empty;
}
if (getLan && string.IsNullOrEmpty(visitorIpAddress))
{
//This is for Local(LAN) Connected ID Address
string stringHostName = Dns.GetHostName();
//Get Ip Host Entry
IPHostEntry ipHostEntries = Dns.GetHostEntry(stringHostName);
ipHostEntries = System.Net.Dns.GetHostEntry(Request.ServerVariables["REMOTE_HOST"]);
//Get Ip Address From The Ip Host Entry Address List
IPAddress[] arrIpAddress = ipHostEntries.AddressList;
try
{
visitorIpAddress = arrIpAddress[arrIpAddress.Length - 2].ToString();
}
catch
{
try
{
visitorIpAddress = arrIpAddress[0].ToString();
}
catch
{
try
{
arrIpAddress = Dns.GetHostAddresses(stringHostName);
visitorIpAddress = arrIpAddress[0].ToString();
}
catch
{
visitorIpAddress = "127.0.0.1";
}
}
}
}
////////////////////////////////////
_securityFactory = new SecurityFactorys();
_userInformationFactory = new UserFactory();
_employeeFactory = new EmployeeFactory();
model.UserName = model.UserName.ToLower().Trim();
var logInStatus = _securityFactory.CheckLogIn(new LogOnModel {
CompanyID = model.CompanyID, BranchID = model.BranchID, UserName = model.UserName, Password = model.Password
});
if (logInStatus.IsAllowed)
{
var aSecurityUser = _userInformationFactory.FindBy(x => x.UserName.Contains(model.UserName)).FirstOrDefault();
var aCompanyUser = _employeeFactory.FindBy(x => x.EmployeeID == aSecurityUser.EmployeeID).FirstOrDefault();
if (aSecurityUser != null)
{
System.Web.HttpContext.Current.Session["LoginEmployee"] = aSecurityUser.EmployeeID;
System.Web.HttpContext.Current.Session["LoginCompanyID"] = aCompanyUser.CompanyID;
System.Web.HttpContext.Current.Session["LoginBranchID"] = aCompanyUser.BranchID;
System.Web.HttpContext.Current.Session["LoginUserID"] = aSecurityUser.ID;
System.Web.HttpContext.Current.Session["LoginUserName"] = aSecurityUser.UserName;
System.Web.HttpContext.Current.Session["LoginUserFullName"] = aSecurityUser.Employee.EmpName;
System.Web.HttpContext.Current.Session["UserGroupID"] = aSecurityUser.UserGroupID;
System.Web.HttpContext.Current.Session["IPAddress"] = visitorIpAddress;
System.Web.HttpContext.Current.Session["LoginPhoto"] = GetLoginPhoto(aSecurityUser.EmployeeID);
string[] computerName = null;
//try
//{
// computerName = Dns.GetHostEntry(Request.ServerVariables["REMOTE_ADDR"]).HostName.Split(new Char[] { '.' });
//}
//catch (Exception)
//{
//}
if (computerName != null)
{
System.Web.HttpContext.Current.Session["PCName"] = computerName[0];
}
else
{
System.Web.HttpContext.Current.Session["PCName"] = "N/A";
}
if (!String.IsNullOrEmpty(model.UserName))
{
if (!aSecurityUser.UserName.Equals(model.UserName, StringComparison.Ordinal))
{
return(Json(new { success = false, message = "Incorrect User Name or Password." }, JsonRequestBehavior.AllowGet));
}
}
else
{
System.Web.HttpContext.Current.Session["LoginUserID"] = 0;
}
if (!logInStatus.IsAllowed)
{
return(Json(new { success = false, message = logInStatus.Message }, JsonRequestBehavior.AllowGet));
}
//if (String.IsNullOrEmpty(model.UserName)) throw new ArgumentException("Value cannot be null or empty.", "userName");
//FormsAuthentication.SetAuthCookie(model.UserName, model.RememberMe);
SEC_LoginStatus tblLogInStatus = new SEC_LoginStatus();
_loginStatusFactory = new LoginStatusFactory();
tblLogInStatus.UserID = aSecurityUser.ID;
tblLogInStatus.PresentLogInStatus = true;
tblLogInStatus.LogInTime = DateTime.Now;
tblLogInStatus.LogOutTime = DateTime.Now;
tblLogInStatus.ForcedLogOutStatus = false;
_loginStatusFactory.Add(tblLogInStatus);
_loginStatusFactory.Save();
Session["logInSession"] = "true";
return(Json(new { success = true, message = "Success" }, JsonRequestBehavior.AllowGet));
//
}
return(Json(new { success = false, message = "The user name or password provided is incorrect." }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = false, message = logInStatus.Message }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = false, message = "The user name or password provided is incorrect." }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
//Route();
return(Json(new { success = false, message = e.Message }, JsonRequestBehavior.AllowGet));
}
//return Json(new { success = false, message = "The user name or password provided is incorrect. 4" }, JsonRequestBehavior.AllowGet);
}
public Result UiPageSave(SEC_UIPage page)
{
Result _result = new Result();
_uiPageFactory = new UiPageFactory();
_userActionMappingFactory = new UserActionMappingFactory();
Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues();
int userId = Convert.ToInt32(dictionary[6].Id == "" ? 0 : Convert.ToInt32(dictionary[6].Id));
int empId = Convert.ToInt32(dictionary[1].Id == "" ? 0 : Convert.ToInt32(dictionary[1].Id));
try
{
if (page.ID > 0)
{
_uiPageFactory.Edit(page);
_result = _uiPageFactory.Save();
if (_result.isSucess)
{
SEC_UserActionMapping userActionMapping = new SEC_UserActionMapping();
_userGroupFactory = new UserGroupFactory();
var groupID = _userGroupFactory.GetAll().ToList();
foreach (var details in groupID)
{
var uiMapping = _userActionMappingFactory.FindBy(x => x.UserGroupID == details.ID && x.UIPageID == page.ID).Count();
if (uiMapping == 0)
{
userActionMapping.UserGroupID = details.ID;
userActionMapping.UIPageID = page.ID;
userActionMapping.UIModuleID = Convert.ToInt32(page.ModuleID);
userActionMapping.IsCreate = false;
userActionMapping.IsDelete = false;
userActionMapping.IsEdit = false;
userActionMapping.IsSelect = false;
userActionMapping.CreatedBy = empId;
userActionMapping.CreatedDate = DateTime.Now;
_userActionMappingFactory.Add(userActionMapping);
_result = _userActionMappingFactory.Save();
}
}
if (_result.isSucess)
{
_result.message = _result.UpdateSuccessfull(tablePageName);
return(_result);
}
_result.message = _result.UpdateSuccessfull(tablePageName);
}
}
else
{
int pageID = 1;
var prvPage = _uiPageFactory.GetLastRecord().OrderByDescending(x => x.ID).FirstOrDefault();
if (prvPage != null)
{
pageID = prvPage.ID + 1;
}
page.UrlID = 1;
page.ID = pageID;
_uiPageFactory.Add(page);
_result = _uiPageFactory.Save();
if (_result.isSucess)
{
var uiMapping = _userActionMappingFactory.FindBy(x => x.UserGroupID == userId && x.UIPageID == page.ID).Count();
if (uiMapping == 0)
{
SEC_UserActionMapping userActionMapping = new SEC_UserActionMapping();
_userGroupFactory = new UserGroupFactory();
var groupID = _userGroupFactory.GetAll().ToList();
foreach (var details in groupID)
{
userActionMapping.UserGroupID = details.ID;
userActionMapping.UIPageID = page.ID;
userActionMapping.UIModuleID = Convert.ToInt32(page.ModuleID);
userActionMapping.IsCreate = false;
userActionMapping.IsDelete = false;
userActionMapping.IsEdit = false;
userActionMapping.IsSelect = false;
userActionMapping.CreatedBy = empId;
userActionMapping.CreatedDate = DateTime.Now;
_userActionMappingFactory.Add(userActionMapping);
_result = _userActionMappingFactory.Save();
}
if (_result.isSucess)
{
_result.message = _result.SaveSuccessfull(tablePageName);
_result.lastInsertedID = userActionMapping.ID;
return(_result);
}
}
_result.message = _result.SaveSuccessfull(tablePageName);
}
}
}
catch (Exception e)
{
_result.isSucess = false;
_result.message = e.Message;
}
return(_result);
}
public Result SaveUserGroupWithPageMapping(SEC_UserGroup userGroup)
{
Result result = new Result();
using (var dbContextTransaction = context.Database.BeginTransaction())
{
try
{
_userGroupFactory = new UserGroupFactory();
_userGroupFactory.Add(userGroup);
bool isDuplicate = _userGroupFactory.FindBy(x => x.Name.ToLower().Trim() == userGroup.Name.ToLower().Trim()).Any(x => x.Name.ToLower() == userGroup.Name.ToLower());
if (!isDuplicate)
{
result = _userGroupFactory.Save();
_uiPageFactory = new UiPageFactory();
_userActionMappingFactory = new UserActionMappingFactory();
if (result.isSucess)
{
List <SEC_UIPage> uiPageList = _uiPageFactory.GetAll().ToList();
foreach (var item in uiPageList)
{
SEC_UserActionMapping userMappings = new SEC_UserActionMapping();
userMappings.UserGroupID = Convert.ToInt32(userGroup.ID);
userMappings.UIModuleID = Convert.ToInt32(item.ModuleID);
userMappings.UIPageID = item.ID;
userMappings.IsSelect = false;
userMappings.IsCreate = false;
userMappings.IsEdit = false;
userMappings.IsDelete = false;
userMappings.CreatedDate = DateTime.Now;
userMappings.CreatedBy = Convert.ToInt32(userGroup.CreatedBy);
_userActionMappingFactory.Add(userMappings);
}
result = _userActionMappingFactory.Save();
}
if (result.isSucess)
{
result.message = result.SaveSuccessfull(tableName);
dbContextTransaction.Commit();
return(result);
}
else
{
result.isSucess = false;
dbContextTransaction.Rollback();
return(result);
}
}
result.message = "Your entared code is duplicate";
result.isSucess = false;
dbContextTransaction.Commit();
return(result);
}
catch (Exception ex)
{
result.message = "Error occured";
result.isSucess = false;
dbContextTransaction.Rollback();
}
}
return(result);
}
public Result SaveUserGroupWithPagePermission(SEC_UserGroup userGroup, List <MenuItemVM> menuVm)
{
Result result = new Result();
using (var dbContextTransaction = context.Database.BeginTransaction())
{
try
{
_userGroupFactory = new UserGroupFactory();
_userGroupFactory.Add(userGroup);
bool isDuplicate = _userGroupFactory.FindBy(x => x.Name.ToLower().Trim() == userGroup.Name.ToLower().Trim()).Any(x => x.Name.ToLower() == userGroup.Name.ToLower());
if (!isDuplicate)
{
_userGroupFactory.Save();
_uiPageFactory = new UiPageFactory();
_userActionMappingFactory = new UserActionMappingFactory();
List <SEC_UIPage> uiPageList = _uiPageFactory.GetAll().ToList();
foreach (var item in uiPageList)
{
SEC_UserActionMapping userMappings = new SEC_UserActionMapping();
userMappings.UserGroupID = Convert.ToInt32(userGroup.ID);
userMappings.UIModuleID = Convert.ToInt32(item.ModuleID);
userMappings.UIPageID = item.ID;
userMappings.IsSelect = false;
userMappings.IsCreate = false;
userMappings.IsEdit = false;
userMappings.IsDelete = false;
userMappings.CreatedDate = DateTime.Now;
userMappings.CreatedBy = Convert.ToInt32(userGroup.CreatedBy);
_userActionMappingFactory.Add(userMappings);
}
_userActionMappingFactory.Save();
if (menuVm != null)
{
int userGroupId = Convert.ToInt32(userGroup.ID);
List <SEC_UserActionMapping> userMappingList = _userActionMappingFactory.FindBy(x => x.UserGroupID == userGroupId).ToList();
List <MenuItemVM> userMappingVmList = menuVm.Distinct().ToList();
foreach (var item in userMappingVmList)
{
SEC_UserActionMapping userMapping = new SEC_UserActionMapping();
userMapping = userMappingList.FirstOrDefault(x => x.UIPageID == item.PageId);
if (userMapping != null)
{
userMapping.IsSelect = item.Select != null ? (bool)item.Select : userMapping.IsSelect;
userMapping.IsCreate = item.Create != null ? (bool)item.Create : userMapping.IsCreate;
userMapping.IsEdit = item.Edit != null ? (bool)item.Edit : userMapping.IsEdit;
userMapping.IsDelete = item.Delete != null ? (bool)item.Delete : userMapping.IsDelete;
_userActionMappingFactory.Edit(userMapping);
}
}
_userActionMappingFactory.Save();
}
result.message = "Saved Successfuly";
result.isSucess = true;
dbContextTransaction.Commit();
return(result);
}
result.message = "Your entared code is duplicate";
result.isSucess = false;
dbContextTransaction.Commit();
return(result);
}
catch (Exception ex)
{
result.message = "Error occured";
result.isSucess = false;
dbContextTransaction.Rollback();
}
}
return(result);
}
private JsonResult CreateUser(UserModel user, int userId)
{
result = new Result();
_questionFactory = new QuestionFactory();
_passwordFactory = new UserPasswordFactory();
var question = new SEC_SecurityQuestion();
question.ID = Guid.NewGuid();
question.SecurityQuestion = user.SecurityQuestion;
question.SecutiryAnswer = user.SecurityQueAns;
question.CreatedBy = userId;
question.CreatedDate = DateTime.Now;
_questionFactory.Add(question);
result = _questionFactory.Save();
var password = new SEC_Password();
if (result.isSucess)
{
var encription = new Encription();
password.ID = Guid.NewGuid();
password.NewPassword = encription.Encrypt(user.Password);
password.OldPassword = "";
password.IsSelfChanged = false;
password.CreatedBy = userId;
password.CreatedDate = DateTime.Now;
_passwordFactory.Add(password);
result = _passwordFactory.Save();
}
var userInformation = new SEC_UserInformation();
//userInformation.ID = Guid.NewGuid();
if (result.isSucess)
{
userInformation.EmployeeID = user.EmployeeID;
userInformation.CompanyID = user.CompanyID;
userInformation.BranchID = user.BranchID;
userInformation.UserFullName = user.UserFullName;
userInformation.UserName = user.UserName.ToLower().Trim();
userInformation.Address = user.Address;
userInformation.Email = user.EMail;
userInformation.PhoneNo = user.PhoneNo;
userInformation.SecurityQuestionID = question.ID;
userInformation.PasswordID = password.ID;
userInformation.IsEMailVerified = false;
userInformation.IsPhoneNoVerified = false;
userInformation.IsActive = true;
userInformation.CreatedBy = userId;
userInformation.CreatedDate = DateTime.Now;
userInformation.UserGroupID = user.UserGroupID;
_userFactory.Add(userInformation);
result = _userFactory.Save();
}
if (result.isSucess)
{
result.message = result.SaveSuccessfull(tableName);
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public Result SaveMeetingReq(MeetingRoomRequisition meetingRoomReq, List <DAL.db.MeetingParticipant> participantList, List <int> deleteStoreReqDtlsID)
{
_mrReqFactory = new MeetingRoomReqFactory();
_mrPrFactory = new ParticipantFactory();
try
{
if (meetingRoomReq.RequisitionID > 0)
{
_mrReqFactory.Edit(meetingRoomReq);
_result = _mrReqFactory.Save();
if (_result.isSucess)
{
if (deleteStoreReqDtlsID != null)
{
foreach (var detailsID in deleteStoreReqDtlsID)
{
_mrPrFactory.Delete(x => x.ParticipantID == detailsID);
_result = _mrPrFactory.Save();
}
}
if (participantList != null)
{
foreach (var list in participantList)
{
if (list.ParticipantID < 1)
{
list.RequisitionID = meetingRoomReq.RequisitionID;
_mrPrFactory.Add(list);
_result = _mrPrFactory.Save();
if (_result.isSucess)
{
_result.message = _result.UpdateSuccessfull(tableName);
}
}
else
{
_mrPrFactory.Edit(list);
_result = _mrPrFactory.Save();
if (_result.isSucess)
{
_result.message = _result.UpdateSuccessfull(tableName);
}
}
}
}
}
}
else
{
_mrReqFactory.Add(meetingRoomReq);
_result = _mrReqFactory.Save();
if (_result.isSucess)
{
if (participantList != null && participantList.Count > 0)
{
foreach (var list in participantList)
{
if (list.ParticipantID < 1)
{
list.RequisitionID = meetingRoomReq.RequisitionID;
_mrPrFactory.Add(list);
_result = _mrPrFactory.Save();
if (_result.isSucess)
{
_result.message = _result.UpdateSuccessfull(tableName);
}
}
}
}
}
}
}
catch (Exception e)
{
_mrReqFactory.Delete(meetingRoomReq);
_result = _mrReqFactory.Save();
_result.isSucess = false;
_result.message = e.Message;
}
return(_result);
}
