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));
}
