public List <StrataOwnerModel> GetAllStrataOwners() { if (ClientSessionData.UserClientId != 0) { var strataOwnerModelList = new List <StrataOwnerModel>(); try { var StrataOwners = _context.tblUserClients.Where(x => x.Status == 1 && x.RoleName == "O" && x.StratasBoardId == ClientSessionData.ClientStrataBoardId).ToList(); foreach (var item in StrataOwners) { StrataOwnerModel strataOwnerModel = new StrataOwnerModel(); strataOwnerModel.UserClientId = item.UserClientId; strataOwnerModel.Name = item.FirstName + " " + item.LastName; strataOwnerModelList.Add(strataOwnerModel); } } catch { } return(strataOwnerModelList); } else { return(null); } }
public ActionResult AddStrataOwner(StrataOwnerModel model) { int result = 0; string strMsg = ""; if (ModelState.IsValid) { result = strataOwnerHelper.AddUpdate(model); if (result == -1) { strMsg = "Email already exits. Please use another Email."; } else if (result == 0) { strMsg = "Strata Owner has been created successfully."; } else if (result == -3) { strMsg = "No. of Subscription of User of this StrataBoard Exceeds"; } else { TempData["CommonMessage"] = AppLogic.setFrontendMessage(2, "Strata Owner creation failed."); strMsg = "Strata Owner creation failed."; } } else { strMsg = "Please enter all mandatory fields with*"; } return(Json(new { result = result, Msg = strMsg })); }
//Poll Question List For Admin public List <StrataOwnerModel> GetOwnerList(StrataOwnerModel modelData) { try { using (StratasFairDBEntities context = new StratasFairDBEntities()) { if (string.IsNullOrEmpty(modelData.FirstName) || string.IsNullOrWhiteSpace(modelData.FirstName)) { modelData.FirstName = null; } if (string.IsNullOrEmpty(modelData.LastName) || string.IsNullOrWhiteSpace(modelData.LastName)) { modelData.LastName = null; } if (string.IsNullOrEmpty(modelData.Email) || string.IsNullOrWhiteSpace(modelData.Email)) { modelData.Email = null; } IQueryable <StrataOwnerModel> model = context.tblUserClients.Where(x => x.RoleName.ToUpper() == "O" && x.StratasBoardId == ClientSessionData.ClientStrataBoardId && x.Status == 1 && !x.IsDeleted && x.IsProfileComplete && x.FirstName.Contains(modelData.FirstName == null ? x.FirstName : modelData.FirstName) && x.LastName.Contains(modelData.LastName == null ? x.LastName : modelData.LastName) && x.EmailId.Contains(modelData.Email == null ? x.EmailId : modelData.Email) ).Select(c => new StrataOwnerModel() { UserClientId = c.UserClientId, FirstName = c.FirstName, LastName = c.LastName, UnitNumber = c.UnitNumber, Email = c.EmailId, CreatedOn = c.CreatedOn.ToString() }); var total = model.Count(); if (total != 0) { var pageSize = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["DefaultPageSize"]); var skip = pageSize * (modelData.PageNo - 1); return(model.OrderByDescending(m => m.CreatedOn).Skip(skip).Take(pageSize).ToList()); } return(null); } } catch (Exception) { return(null); } }
public ActionResult GetOwnerList(StrataOwnerModel model) { StrataOwnerHelper objHelper = new StrataOwnerHelper(); var Owners = objHelper.GetOwnerList(model); if (Owners == null) { return(Content("0")); } if (Owners.Count <= 0) { return(Content("0")); } else { return(PartialView("_OwnerList", Owners)); } }
public int AddUpdate(StrataOwnerModel objectModel) { if (objectModel.UserClientId > 0) { return(AddUpdateStrataOwner(objectModel)); } else { if (_context.tblUserClients.Any(x => x.EmailId == objectModel.Email && !x.IsDeleted)) { // registered emailid already exists return(-1); } else { return(AddUpdateStrataOwner(objectModel)); } } }
public StrataOwnerModel GetStrataOwnerDetails(int UserClientId) { try { int result = -1; _conString = SqlHelper.GetConnectionString(); SqlParameter prmStrataBoardID = SqlHelper.CreateParameter("@StrataBoardID", ClientSessionData.ClientStrataBoardId); SqlParameter prmUserClientId = SqlHelper.CreateParameter("@UserClientId", UserClientId); SqlParameter prmType = SqlHelper.CreateParameter("@Type", 6); SqlParameter prmErr = SqlHelper.CreateParameter("@Err", -1, ParameterDirection.Output); SqlParameter[] allParams = { prmStrataBoardID, prmType, prmErr, prmUserClientId }; DataSet ds = SqlHelper.ExecuteDataset(_conString, CommandType.StoredProcedure, "Usp_GetClientUser", allParams); if (prmErr.Value != null) { result = (int)prmErr.Value; } if (ds != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0].Copy(); ds.Dispose(); var StrataOwner = new StrataOwnerModel(); StrataOwner.UserClientId = Convert.ToInt32(dt.Rows[0]["UserClientId"]); StrataOwner.FirstName = dt.Rows[0]["FirstName"].ToString(); StrataOwner.LastName = dt.Rows[0]["LastName"].ToString(); StrataOwner.Email = dt.Rows[0]["EmailId"].ToString(); StrataOwner.UnitNumber = dt.Rows[0]["UnitNumber"].ToString(); StrataOwner.CreatedOn = dt.Rows[0]["CreatedOn"].ToString(); StrataOwner.Status = Convert.ToInt32(dt.Rows[0]["Status"]); return(StrataOwner); } else { return(null); } } catch { throw; } }
public ActionResult EditStrataOwner(StrataOwnerModel model) { int result = 0; string strMsg = ""; if (ModelState.IsValid) { result = strataOwnerHelper.AddUpdate(model); if (result == 0) { strMsg = "Strata Owner has been updated successfully."; } else { strMsg = "Strata Owner updation failed."; } } else { strMsg = "Please enter all mandatory fields with*"; } return(Json(new { result = result, Msg = strMsg })); }
public ActionResult AddStrataOwner() { StrataOwnerModel strataOwnerModel = new StrataOwnerModel(); return(PartialView("AddStrataOwner", strataOwnerModel)); }
public PartialViewResult EditStrataOwner(int StrataOwnerId) { StrataOwnerModel strataOwnerModel = strataOwnerHelper.GetStrataOwnerDetails(StrataOwnerId); return(PartialView("EditStrataOwner", strataOwnerModel)); }
public JsonResult BulkUploadStrataOwner(HttpPostedFileBase FileUpload) { int result = 0; string strMsg = ""; try { if (FileUpload != null) { StrataOwnerModel strataboardModel = new StrataOwnerModel(); DataTable dt = new DataTable(); if (FileUpload.ContentLength > 0) { string fileName = Path.GetFileName(FileUpload.FileName); string PhysicalPath = "~/Content/Resources/BulkUpload/"; if (!Directory.Exists(Server.MapPath(PhysicalPath))) { Directory.CreateDirectory(Server.MapPath(PhysicalPath)); } string path = Path.Combine(Server.MapPath("~/Content/Resources/BulkUpload/"), fileName); string extension = Path.GetExtension(FileUpload.FileName); string savedFileName = "~/Content/Resources/BulkUpload/" + fileName; FileUpload.SaveAs(path); if (extension == ".xls" || extension == ".xlsx" || extension == ".csv") { if (extension == ".xls" || extension == ".xlsx") { //The below code reads the excel file. var connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=Excel 12.0;", Server.MapPath(savedFileName)); var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString); var ds = new DataSet(); adapter.Fill(ds, "results"); dt = ds.Tables["results"]; } else if (extension == ".csv") { dt = ProcessCSV(path); } foreach (DataRow row in dt.Rows) { strataboardModel.FirstName = row["First Name"].ToString(); strataboardModel.LastName = row["Last Name"].ToString(); strataboardModel.Email = row["Email Address"].ToString(); strataboardModel.UnitNumber = row["Unit Number"].ToString(); //Data saved to database. if (!string.IsNullOrEmpty(strataboardModel.FirstName) && !string.IsNullOrEmpty(strataboardModel.LastName) && !string.IsNullOrEmpty(strataboardModel.Email) && !string.IsNullOrEmpty(strataboardModel.UnitNumber)) { strataOwnerHelper.AddUpdate(strataboardModel); result++; } } if (result > 0) { int fileMapped = AwsS3Bucket.CreateFile("resources/strataboard/" + ClientSessionData.ClientStrataBoardId + "/ImportUsers/" + FileUpload.FileName, path); System.IO.File.Delete(path); strMsg = "Bulk upload of strata owners are successfully saved."; } else { System.IO.File.Delete(path); strMsg = "Uploaded file is empty. please fill data before upload."; } } else { strMsg = "Please upload only Excel (.xls, .xlsx) OR Csv(.csv) File"; } } else { strMsg = "Uploaded file is empty. please fill data before upload."; } } else { strMsg = "Please upload a file before submit."; } } catch (Exception ex) { strMsg = "Bulk upload failed due to " + ex.Message; } return(Json(new { counter = result, msg = strMsg }, JsonRequestBehavior.AllowGet)); }
public int AddUpdateStrataOwner(StrataOwnerModel strataOwnerModel) { int result = 0; int userClientId = 0; //using (var transaction = _context.Database.BeginTransaction()) //{ try { tblUserClient tblUserClientDb = new tblUserClient(); tblUserClientDb.FirstName = strataOwnerModel.FirstName; tblUserClientDb.LastName = strataOwnerModel.LastName; tblUserClientDb.EmailId = strataOwnerModel.Email; tblUserClientDb.StratasBoardId = ClientSessionData.ClientStrataBoardId; tblUserClientDb.RoleName = "O"; tblUserClientDb.UnitNumber = strataOwnerModel.UnitNumber; tblUserClientDb.CreatedBy = ClientSessionData.UserClientId; tblUserClientDb.CreatedOn = DateTime.UtcNow; tblUserClientDb.LastLogin = DateTime.UtcNow; tblUserClientDb.CurrentLogin = DateTime.UtcNow; if (strataOwnerModel.UserClientId == 0) { tblUserClientDb.Password = AppLogic.EncryptPassword();; tblUserClientDb.IsEmailNotification = false; tblUserClientDb.IsSMSNotification = false; tblUserClientDb.IsProfileComplete = false; tblUserClientDb.Status = 1; // It will be active in both the cases var AllowedUser = _context.tblStratasBoardSubscriptions.Where(x => x.StratasBoardId == ClientSessionData.ClientStrataBoardId).FirstOrDefault().AllowedUser; var AddedUserClients = _context.tblUserClients.Where(x => x.StratasBoardId == ClientSessionData.ClientStrataBoardId && x.Status == 1); if (AddedUserClients.Count() <= AllowedUser) { _context.tblUserClients.Add(tblUserClientDb); result = _context.SaveChanges(); } else { result = -3; } userClientId = Convert.ToInt32(tblUserClientDb.UserClientId); if (result == 1) { EmailSender.FncSend_StratasBoard_RegistrationMail_ToStrataOwnerClient(userClientId); result = 0; } } else { tblUserClientDb.UserClientId = strataOwnerModel.UserClientId; _context.tblUserClients.Attach(tblUserClientDb); _context.Entry(tblUserClientDb).Property(x => x.FirstName).IsModified = true; _context.Entry(tblUserClientDb).Property(x => x.LastName).IsModified = true; _context.Entry(tblUserClientDb).Property(x => x.EmailId).IsModified = true; _context.Entry(tblUserClientDb).Property(x => x.UnitNumber).IsModified = true; result = _context.SaveChanges(); if (result == 1) { result = 0; } } } catch (Exception ex) { new AppError().LogMe(ex); result = -2; // any error is there } return(result); }
public List <StrataOwnerModel> GetAllStrataOwnerDetails(int BlockNumber, int BlockSize, string ByFirstName, string ByLastName, string ByEmail) { try { int startIndex = (BlockNumber - 1) * BlockSize; int result = -1; _conString = SqlHelper.GetConnectionString(); SqlParameter prmStrataBoardID = SqlHelper.CreateParameter("@StrataBoardID", ClientSessionData.ClientStrataBoardId); SqlParameter prmType = SqlHelper.CreateParameter("@Type", 5); SqlParameter prmErr = SqlHelper.CreateParameter("@Err", -1, ParameterDirection.Output); SqlParameter[] allParams = { prmStrataBoardID, prmType, prmErr }; DataSet ds = SqlHelper.ExecuteDataset(_conString, CommandType.StoredProcedure, "Usp_GetClientUser", allParams); if (prmErr.Value != null) { result = (int)prmErr.Value; } var AllowedUser = _context.tblStratasBoardSubscriptions.Where(x => x.StratasBoardId == ClientSessionData.ClientStrataBoardId).FirstOrDefault().AllowedUser; var AddedUserClients = _context.tblUserClients.Where(x => x.StratasBoardId == ClientSessionData.ClientStrataBoardId); List <StrataOwnerModel> StrataOwnerModelList = new List <StrataOwnerModel>(); if (ds != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0].Copy(); ds.Dispose(); if (dt.Rows.Count > 0) { if (!string.IsNullOrEmpty(ByFirstName) || !string.IsNullOrEmpty(ByLastName) || !string.IsNullOrEmpty(ByEmail)) { ByFirstName = string.IsNullOrEmpty(ByFirstName) ? " " : ByFirstName; ByLastName = string.IsNullOrEmpty(ByLastName) ? " " : ByLastName; ByEmail = string.IsNullOrEmpty(ByEmail) ? " " : ByEmail; DataRow[] rows = dt.Select("[FirstName] LIKE '" + ByFirstName + "%' OR [LastName] LIKE '" + ByLastName + "%' OR [EmailId] LIKE '" + ByEmail + "%'"); dt = rows.CopyToDataTable(); } for (int i = 0; i < dt.Rows.Count; i++) { var strataOwner = new StrataOwnerModel(); strataOwner.UserClientId = Convert.ToInt32(dt.Rows[i]["UserClientId"]); strataOwner.FirstName = dt.Rows[i]["FirstName"].ToString(); strataOwner.LastName = dt.Rows[i]["LastName"].ToString(); strataOwner.Email = dt.Rows[i]["EmailId"].ToString(); strataOwner.UnitNumber = dt.Rows[i]["UnitNumber"].ToString(); strataOwner.CreatedOn = dt.Rows[i]["CreatedOn"].ToString(); strataOwner.Status = Convert.ToInt32(dt.Rows[i]["Status"]); if (i == 0) { strataOwner.TotalNoofAccounts = Convert.ToInt32(AllowedUser); strataOwner.TotalAddedAccounts = AddedUserClients.Count(); strataOwner.TotalAvailableAccounts = strataOwner.TotalNoofAccounts - strataOwner.TotalAddedAccounts; } StrataOwnerModelList.Add(strataOwner); } } else { var strataOwner = new StrataOwnerModel(); strataOwner.TotalNoofAccounts = Convert.ToInt32(AllowedUser); strataOwner.TotalAddedAccounts = AddedUserClients.Count(); strataOwner.TotalAvailableAccounts = strataOwner.TotalNoofAccounts - strataOwner.TotalAddedAccounts; StrataOwnerModelList.Add(strataOwner); } StrataOwnerModelList = StrataOwnerModelList.Skip(startIndex).Take(BlockSize).ToList(); return(StrataOwnerModelList); } else { var strataOwner = new StrataOwnerModel(); strataOwner.TotalNoofAccounts = Convert.ToInt32(AllowedUser); strataOwner.TotalAddedAccounts = AddedUserClients.Count(); strataOwner.TotalAvailableAccounts = strataOwner.TotalNoofAccounts - strataOwner.TotalAddedAccounts; StrataOwnerModelList.Add(strataOwner); return(StrataOwnerModelList); } } catch { return(null); throw; } }
public ActionResult OwnerList(StrataOwnerModel model) { return(View(model)); }