public bool StoreAuthToken(UserInfluencerAuth userInfluencer)
{
var parameters = new ParmsCollection();
parameters.AddParm("@userId", SqlDbType.Int, userInfluencer.UserId);
parameters.AddParm("@influencerId", SqlDbType.Int, userInfluencer.InfluencerId);
parameters.AddParm("@userName", SqlDbType.NVarChar, userInfluencer.UserName);
parameters.AddParm("@secret", SqlDbType.NVarChar, userInfluencer.Secret);
parameters.AddParm("@secret1", SqlDbType.NVarChar, userInfluencer.Secret1);
parameters.AddParm("@secret2", SqlDbType.NVarChar, userInfluencer.Secret2);
parameters.AddParm("@secret3", SqlDbType.NVarChar, userInfluencer.Secret3);
parameters.AddParm("@other1", SqlDbType.NVarChar, userInfluencer.Other1);
parameters.AddParm("@other2", SqlDbType.NVarChar, userInfluencer.Other2);
int numOfRec = unitOfWork.GetIdentityDbContext().ExecuteNonQuery("Scores.UpdateAuthToken", parameters);
if (numOfRec > 0)
{
return(true);
}
else
{
return(false);
}
}
public List <Claim> ValidateUser(UserLoginLog userLoginLog, out User user)
{
var result = default(List <Claim>);
user = default(User);
#if DEBUG
if (userLoginLog.HostName == "localhost")
{
userLoginLog.HostName = DevConstants.Dev_Host_Name;
}
#endif
var primaryDbContext = this.unitOfWork.GetIdentityDbContext();
var parmsCollection = new ParmsCollection();
result = primaryDbContext.ExecuteStoredProcedure <Claim>("[Core].[validateUserCredentials]",
parmsCollection
.AddParm("@userId", SqlDbType.Int, userLoginLog.UserId)
.AddParm("@userName", SqlDbType.VarChar, userLoginLog.UserName)
.AddParm("@password", SqlDbType.VarChar, userLoginLog.Password)
.AddParm("@remoteIpAddress", SqlDbType.VarChar, userLoginLog.RemoteIPAddress)
.AddParm("@localIpAddress", SqlDbType.VarChar, userLoginLog.LocalIPAddress)
.AddParm("@appKey", SqlDbType.VarChar, userLoginLog.AppKey)
).ToList();
if (result.Any(r => r.ClaimType == "UserId"))
{
var userId = int.Parse(result.First(r => r.ClaimType == "UserId").ClaimValue);
user = primaryDbContext.Users.First(emp => emp.UserId == userId);
}
return(result);
}
public bool UpdateUserTokenResponse(IEnumerable <UserTokenResponse> tokenResponse)
{
var tokenResponseTableType = UserDefinedTableTypes.UserTokenResponseType;
foreach (var item in tokenResponse)
{
tokenResponseTableType.Rows.Add(new object[]
{
item.UserTokenResponseId,
item.UserId,
item.Token,
item.ProcessDate,
item.CreatedBy,
item.CreatedDate,
item.ModifiedBy,
item.ModifiedDate
});
}
var parmsCollection = new ParmsCollection();
this.unitOfWork.GetIdentityDbContext(true).ExecuteStoredProcedure <int>("",
parmsCollection
.AddParm("@userTokenResponse", SqlDbType.Structured, tokenResponseTableType, "[Scores].[userTokenResponseType]"));
return(true);
}
public bool UpdateUserTokenResponseDetail(UserTokenResponse response, List <GoogleData> responseDetail)
{
var responseType = UserDefinedTableTypes.UserTokenResponseType;
var responseDetailType = UserDefinedTableTypes.UserTokenResponseDetail;
responseType.Rows.Add(new object[]
{
response.UserTokenResponseId,
response.UserId,
response.Token,
response.ProcessDate,
response.CreatedBy,
response.CreatedDate,
response.ModifiedBy,
response.ModifiedDate
});
foreach (var item in responseDetail)
{
responseDetailType.Rows.Add(new object[]
{
0,
0,
DateTime.Now,
item.Link,
item.Count,
item.Description,
item.AnalyzeEntities,
item.AnalyzeEntitiesTokens,
item.AnalyzeEntitiesScore,
item.AnalyzeEntitiesMagnitude,
item.AnalyzeEntitySentiment,
item.AnalyzeEntitySentimentTokens,
item.AnalyzeEntitySentimentScore,
item.AnalyzeEntitySentimentMagnitude,
item.AnalyzeSyntax,
item.AnalyzeSyntaxTokens,
item.ClassifyText,
item.ClassifyTextTokens
});
}
var parmsCollection = new ParmsCollection();
this.unitOfWork.GetIdentityDbContext(true).ExecuteStoredProcedure <int>("[Scores].updateUserTokenResponseDetail",
parmsCollection
.AddParm("@userTokenResponse", SqlDbType.Structured, responseType, "[Scores].[UserTokenResponseType]")
.AddParm("@userTokenResponseDetail", SqlDbType.Structured, responseDetailType, "[Scores].UserTokenResponseDetailType"));
return(true);
}
public void UpdateDefectItemStatus(DefectItem item)
{
var parmsCollection = new ParmsCollection();
this.clientDbContext.ExecuteStoredProcedure_ToList <PS_DefectHeader>("[MobileApp].[dts_UpdateDefectItemStatus]",
parmsCollection
.AddParm("@DefectItemID", SqlDbType.Int, item.DefectItemID)
.AddParm("@Status,", SqlDbType.VarChar, item.Status)
.AddParm("@CreatedBy", SqlDbType.Int, item.CreatedBy)
).FirstOrDefault();
}
public List <Claim> ValidateUser(string userName, string password, string ipAddress)
{
var parmsCollection = new ParmsCollection();
return(this.unitOfWork.DbContext.ExecuteStoredProcedure <Claim>("[Auth].[validateUserCredentials]",
parmsCollection
.AddParm("@userName", SqlDbType.VarChar, userName)
.AddParm("@password", SqlDbType.VarChar, password)
.AddParm("@ipAddress", SqlDbType.VarChar, ipAddress)
).ToList());
}
public void ReOpenDefectItem(DefectItem item)
{
var parmsCollection = new ParmsCollection();
this.clientDbContext.ExecuteStoredProcedure_ToList <PS_DefectHeader>("[MobileApp].[dts_ReOpenDefectItem]",
parmsCollection
.AddParm("@DefectItemID", SqlDbType.Int, item.DefectItemID)
.AddParm("@Remark", SqlDbType.NVarChar, item.Remark)
.AddParm("@CreatedBy", SqlDbType.Int, item.CreatedBy)
).FirstOrDefault();
}
public void AddNewUserLogin(string userName, int roleId, string firstName, string lastName)
{
var parmsCollection = new ParmsCollection();
this.unitOfWork.DbContext.ExecuteStoredProcedure <Claim>("[Auth].[AddNewUserLogin]",
parmsCollection
.AddParm("@userEmail", SqlDbType.VarChar, userName)
.AddParm("@roleId", SqlDbType.Int, roleId)
.AddParm("@firstName", SqlDbType.VarChar, firstName)
.AddParm("@lastName", SqlDbType.VarChar, lastName)
).ToList();
}
public void AssignDefectItem(DefectItem item)
{
var parmsCollection = new ParmsCollection();
this.clientDbContext.ExecuteStoredProcedure_ToList <PS_DefectHeader>("[MobileApp].[dts_AssignDefectItem]",
parmsCollection
.AddParm("@DefectItemID", SqlDbType.Int, item.DefectItemID)
.AddParm("@Contractor1ID", SqlDbType.Int, item.Contractor1ID)
.AddParm("@Contractor2ID", SqlDbType.Int, item.Contractor2ID)
.AddParm("@Remark", SqlDbType.NVarChar, item.Remark)
.AddParm("@InternalUserID", SqlDbType.Int, item.InternalUserID)
.AddParm("@AssignDate", SqlDbType.DateTime, (item.AssignDate ?? DateTime.Now).Date)
.AddParm("@CreatedBy", SqlDbType.Int, item.CreatedBy)
).FirstOrDefault();
}
public Users ValidateUser(string userName, string password)
{
var clientDbContext = new ClientDbContext();
Users result;
{
var parmsCollection = new ParmsCollection();
result = this.clientDbContext.ExecuteStoredProcedure_ToList <Users>("[dbo].[validateUserCredentials]",
parmsCollection
.AddParm("@userName", SqlDbType.VarChar, userName)
.AddParm("@password", SqlDbType.VarChar, password)
).FirstOrDefault();
}
return(result);
}
public List <Navigation> GetNavigationItems(int?userId = null)
{
if (userId.HasValue)
{
var parmsCollection = new ParmsCollection();
var result = this.unitOfWork.GetIdentityDbContext().ExecuteStoredProcedure <Navigation>
("[Core].[getNavigationItemsByUserId]",
parmsCollection
.AddParm("@userId", SqlDbType.Int, userId)).ToList();
//TODO: check this
return(result.ToList());
}
else
{
return(this.unitOfWork.GetIdentityDbContext().Navigations.ToList());
}
}
public void AddDocument(DefectItem item)
{
item.DocumentName = $"{Guid.NewGuid()}.jpeg";
if (!string.IsNullOrWhiteSpace(item.ImageData))
{
var filePath = Path.Combine(ConfigSettings.Instance.FileSettings.DocumentsFolder, item.DocumentName);
byte[] imageBytes = Convert.FromBase64String(item.ImageData);
File.WriteAllBytes(filePath, imageBytes);
var parmsCollection = new ParmsCollection();
this.clientDbContext.ExecuteStoredProcedure_ToList <PS_DefectHeader>("[MobileApp].[dts_AddDocument]",
parmsCollection
.AddParm("@RefRecordID", SqlDbType.Int, item.DefectItemID)
.AddParm("@DocumentName", SqlDbType.VarChar, item.DocumentName)
.AddParm("@Keyword", SqlDbType.VarChar, item.Keyword)
.AddParm("@Remark", SqlDbType.NVarChar, item.Remark)
.AddParm("@CreatedBy", SqlDbType.Int, this.userContext.LoggedInUserId)
).FirstOrDefault();
}
}
public void UpdateUserScore(List <UserScore> userScores)
{
var groupId = Guid.NewGuid();
var sql = @"INSERT INTO [Core].[trUserScore]
([UserId]
,[ICMapId]
,[ScoreType]
,[Score]
,[PositiveScore]
,[NeutralScore]
,[NegativeScore]
,[ChangeScore]
,[CreatedOn]
,[GroupId])
VALUES
(@userId
,@icMapId
,NULL
,@score
,@positiveScore
,@neutralScore
,@negativeScore
,0
,GETDATE()
,@groupId)";
foreach (var userScore in userScores)
{
var parameters = new ParmsCollection();
parameters.AddParm("@userId", SqlDbType.Int, userScore.UserId);
parameters.AddParm("@icMapId", SqlDbType.Int, userScore.ICMapId);
parameters.AddParm("@score", SqlDbType.Decimal, userScore.Score);
parameters.AddParm("@positiveScore", SqlDbType.Decimal, userScore.PositiveScore);
parameters.AddParm("@neutralScore", SqlDbType.Decimal, userScore.NeutralScore);
parameters.AddParm("@negativeScore", SqlDbType.Decimal, userScore.NegativeScore);
parameters.AddParm("@groupId", SqlDbType.UniqueIdentifier, groupId);
this.unitOfWork.GetIdentityDbContext(true)
.ExecuteNonQuery(sql, parameters, CommandType.Text);
}
}
public bool ConvertToSale(App_Sale saleRequest)
{
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[convertToSale]",
parmsCollection
.AddParm("@SaleID", SqlDbType.Int, saleRequest.SaleID)
.AddParm("@UnitID", SqlDbType.Int, saleRequest.UnitID)
.AddParm("@SaleDate", SqlDbType.DateTime, saleRequest.SaleDate)
.AddParm("@Remark", SqlDbType.NVarChar, saleRequest.Remark)
.AddParm("@CreatedBy", SqlDbType.Int, saleRequest.CreateUserID)
);
return(true);
}
public bool ConvertToBook(App_Sale saleRequest)
{
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[convertTobook]",
parmsCollection
.AddParm("@ReserveID", SqlDbType.Int, saleRequest.ReserveID)
.AddParm("@SaleID", SqlDbType.Int, saleRequest.SaleID)
.AddParm("@UnitID", SqlDbType.Int, saleRequest.UnitID)
.AddParm("@BookStartDate", SqlDbType.DateTime, saleRequest.ReserveDate)
.AddParm("@BookEndDate", SqlDbType.DateTime, saleRequest.ExpiryDate)
.AddParm("@Remark", SqlDbType.NVarChar, saleRequest.Remark)
.AddParm("@BookAmt", SqlDbType.Int, saleRequest.BookAmt)
.AddParm("@ReferenceNo", SqlDbType.NVarChar, saleRequest.ReferenceNo)
.AddParm("@PayMethod", SqlDbType.Int, saleRequest.PayMethod)
.AddParm("@CurrencyID", SqlDbType.Int, saleRequest.CurrencyID)
.AddParm("@BankAccountID", SqlDbType.Int, saleRequest.BankAccountID)
.AddParm("@CreatedBy", SqlDbType.Int, saleRequest.CreateUserID)
);
return(true);
}
public bool AddAppSale(App_Sale sale)
{
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[addApp_Sale]",
parmsCollection
.AddParm("@RowID", SqlDbType.Int, sale.RowID)
.AddParm("@AppProspectID", SqlDbType.VarChar, sale.AppProspectID)
.AddParm("@AccountNo", SqlDbType.VarChar, sale.AccountNo)
.AddParm("@ProspectID", SqlDbType.Int, sale.ProspectID)
.AddParm("@AccountID", SqlDbType.Int, sale.AccountID)
.AddParm("@CompanyID", SqlDbType.Int, sale.CompanyID)
.AddParm("@ProjectID", SqlDbType.Int, sale.ProjectID)
.AddParm("@PhaseID", SqlDbType.Int, sale.PhaseID)
.AddParm("@BlockID", SqlDbType.Int, sale.BlockID)
.AddParm("@UnitID", SqlDbType.Int, sale.UnitID)
.AddParm("@UnitNo", SqlDbType.VarChar, sale.UnitNo)
.AddParm("@CustomerName", SqlDbType.NVarChar, sale.CustomerName)
.AddParm("@MobilePhone", SqlDbType.NVarChar, sale.MobilePhone)
.AddParm("@Email", SqlDbType.VarChar, sale.Email)
.AddParm("@ReserveDate", SqlDbType.DateTime, (sale.ReserveDate == default(DateTime) ? DateTime.Now.Date : sale.ReserveDate.Date))
.AddParm("@ExpiryDate", SqlDbType.DateTime, ((sale.ExpiryDate == default(DateTime) || !sale.ExpiryDate.HasValue)
? ((sale.ReserveDate == default(DateTime) ? DateTime.Now.Date : sale.ReserveDate.Date)).AddDays(5)
: sale.ExpiryDate.Value.Date))
.AddParm("@Remark", SqlDbType.VarChar, sale.Remark)
.AddParm("@SaleAgentID", SqlDbType.Int, userContext.SaleAgentId)
.AddParm("@ApproveByID", SqlDbType.Int, userContext.SaleAgentId)
.AddParm("@ApproveDate", SqlDbType.DateTime, DateTime.Now.Date)
.AddParm("@CreateUserID", SqlDbType.Int, userContext.LoggedInUserId)
.AddParm("@CreateDate", SqlDbType.DateTime, DateTime.Now)
.AddParm("@ModifyUserID", SqlDbType.Int, userContext.LoggedInUserId)
.AddParm("@ModifyDate", SqlDbType.DateTime, DateTime.Now)
.AddParm("@SaleType", SqlDbType.NVarChar, sale.SaleType)
.AddParm("@BookAmt", SqlDbType.Int, sale.BookAmt)
.AddParm("@ReferenceNo", SqlDbType.NVarChar, sale.ReferenceNo)
.AddParm("@PayMethod", SqlDbType.Int, sale.PayMethod)
.AddParm("@CurrencyID", SqlDbType.Int, sale.CurrencyID)
.AddParm("@BankAccountID", SqlDbType.Int, sale.BankAccountID)
);
return(true);
}
public bool CancelBooking(App_Sale saleRequest)
{
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[cancelBooking]",
parmsCollection
.AddParm("@ReserveID", SqlDbType.Int, saleRequest.ReserveID)
.AddParm("@SaleID", SqlDbType.Int, saleRequest.SaleID)
.AddParm("@Remark", SqlDbType.NVarChar, saleRequest.Remark)
.AddParm("@cancelReasonId", SqlDbType.Int, saleRequest.CancelReasonId)
.AddParm("@createdBy", SqlDbType.Int, saleRequest.CreateUserID)
);
return(true);
}
public bool AddAppProspectFollowUp(App_ProspectFollowUp prospect)
{
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[addApp_ProspectFollowUp]",
parmsCollection
.AddParm("@RowID", SqlDbType.Int, prospect.RowID)
.AddParm("@AppProspectID", SqlDbType.VarChar, prospect.AppProspectID)
.AddParm("@ProspectID", SqlDbType.Int, prospect.ProspectID)
.AddParm("@ActivityDate", SqlDbType.VarChar, prospect.ActivityDate)
.AddParm("@Activity", SqlDbType.NVarChar, prospect.Activity)
.AddParm("@CreateUserID", SqlDbType.Int, userContext.LoggedInUserId)
.AddParm("@CreateDate", SqlDbType.DateTime, DateTime.Now)
.AddParm("@ModifyUserID", SqlDbType.Int, userContext.LoggedInUserId)
.AddParm("@ModifyDate", SqlDbType.DateTime, DateTime.Now)
);
return(true);
}
public bool TransferProspect(App_ProspectTransfer prospectTransfer)
{
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[addApp_ProspectTransfer]",
parmsCollection
.AddParm("@ProspectID", SqlDbType.Int, prospectTransfer.ProspectID)
.AddParm("@AgentId", SqlDbType.VarChar, prospectTransfer.AgentId)
.AddParm("@Remarks", SqlDbType.NVarChar, prospectTransfer.Remarks)
.AddParm("@CreateUserID", SqlDbType.Int, userContext.LoggedInUserId)
.AddParm("@CreateDate", SqlDbType.DateTime, DateTime.Now)
.AddParm("@ModifyUserID", SqlDbType.Int, userContext.LoggedInUserId)
.AddParm("@ModifyDate", SqlDbType.DateTime, DateTime.Now)
);
return(true);
}
public void UpdateEngineResponse(List <EngineLogResponse> response)
{
var engineResponseTable = UserDefinedTableTypes.EngineResponseType;
foreach (var item in response)
{
engineResponseTable.Rows.Add(new object[]
{
item.UserId,
item.InfluencerId,
item.PullStatus,
item.Response,
item.Remarks,
item.TransactionDate,
});
}
var parmsCollection = new ParmsCollection();
var result = this.unitOfWork.GetIdentityDbContext(true).ExecuteStoredProcedure <User>("[Scores].[updateEngineLogs]",
parmsCollection
.AddParm("@logs", SqlDbType.Structured, engineResponseTable, "[Scores].[EngineResponseType]")
).FirstOrDefault();
}
public List <ProspectData> GetProspectData()
{
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[getProspectsData]",
parmsCollection
.AddParm("@userId", SqlDbType.Int, this.userContext.LoggedInUserId)
);
return(dataSet.Tables[0].ToList <ProspectData>());
}
public List <DashboardData> GetDashboardData(string teamOrAgent = "", int teamId = 0, int agentId = 0, int selectedProjectId = 0, bool showAll = false)
{
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[dashboardData]",
parmsCollection
.AddParm("@userId", SqlDbType.Int, this.userContext.LoggedInUserId)
.AddParm("@teamOrAgent", SqlDbType.VarChar, teamOrAgent)
.AddParm("@teamId", SqlDbType.Int, teamId)
.AddParm("@agentId", SqlDbType.Int, agentId)
.AddParm("@selectedProjectId", SqlDbType.Int, selectedProjectId)
.AddParm("@showAll", SqlDbType.Bit, showAll)
);
return(dataSet.Tables[0].ToList <DashboardData>());
}
public bool UpdateUserProfile(User user)
{
var userTypeTable = UserDefinedTableTypes.UserType;
var userPersonnelInfoTypeTable = UserDefinedTableTypes.UserPersonnelInfoType;
var userEducationTypeTable = UserDefinedTableTypes.UserEducationType;
var userExperienceTypeTable = UserDefinedTableTypes.UserExperienceType;
var userBusinessProfileTypeTable = UserDefinedTableTypes.BusinessProfileType;
userTypeTable.Rows.Add(new object[]
{
user.UserId,
user.UserName,
user.FirstName,
user.LastName,
user.Email,
user.MobileNumber,
user.UniqueId,
user.JsonFeed
});
userPersonnelInfoTypeTable.Rows.Add(new object[]
{
user.PersonnelInfo.UserPersonnelInfoId,
user.PersonnelInfo.UserId,
user.PersonnelInfo.DoB,
user.PersonnelInfo.Gender,
user.PersonnelInfo.PlaceOfBirth,
user.PersonnelInfo.CityOfLiving,
user.PersonnelInfo.CityOfWork,
user.PersonnelInfo.MaritalStatus,
user.PersonnelInfo.BirthOfOrigin,
user.PersonnelInfo.Nationality,
user.PersonnelInfo.Citizenship,
user.PersonnelInfo.PRStatus,
user.PersonnelInfo.PrimaryIndustryOfWork,
user.PersonnelInfo.SecondaryIndustryOfWork,
user.PersonnelInfo.PrimaryIndustryOfBusiness,
user.PersonnelInfo.SecondaryIndustryOfBusiness,
user.PersonnelInfo.FutureRole,
user.PersonnelInfo.FutureIndustryOfWork,
user.PersonnelInfo.FutureIndustryOfBusiness,
});
foreach (var item in user.Experience)
{
userExperienceTypeTable.Rows.Add(new object[]
{
item.UserExperienceId,
item.UserId,
item.OrganizationName,
item.Designation,
item.Roles,
item.StartDate,
item.EndDate,
item.IsCurrent,
item.ReasonForChange
});
}
foreach (var item in user.Education)
{
userEducationTypeTable.Rows.Add(new object[]
{
item.UserEducationId,
item.UserId,
item.DegreeType,
item.Title,
item.UniversityOrBoard,
item.InstitutionOrBoard,
item.YearOfPass,
item.Specialization
});
}
foreach (var item in user.BusinessData)
{
userBusinessProfileTypeTable.Rows.Add(new object[]
{
item.BusinessProfileId,
item.UserId,
item.YearOfEstablishment,
item.ComponySize,
item.Role
});
}
var parmsCollection = new ParmsCollection();
var result = this.unitOfWork.GetIdentityDbContext(true).ExecuteStoredProcedure <User>("[Core].[updateUser]",
parmsCollection
.AddParm("@user", SqlDbType.Structured, userTypeTable, "[Core].[UserType]")
.AddParm("@userPersonnelInfo", SqlDbType.Structured, userPersonnelInfoTypeTable, "[Core].[UserPersonnelInfoType]")
.AddParm("@userExperience", SqlDbType.Structured, userExperienceTypeTable, "[Core].[UserExperienceType]")
.AddParm("@userEducation", SqlDbType.Structured, userEducationTypeTable, "[Core].[UserEducationType]")
.AddParm("@userBusiness", SqlDbType.Structured, userBusinessProfileTypeTable, "[Core].[BusinessProfileType]")
).FirstOrDefault();
return(true);
}
public Defect SaveDefect(App_Defect defect)
{
var result = new Defect();
var parmsCollection = new ParmsCollection();
result.Header = this.clientDbContext.ExecuteStoredProcedure_ToList <PS_DefectHeader>("[MobileApp].[addApp_Dts]",
parmsCollection
.AddParm("@UnitId", SqlDbType.Int, defect.UnitId)
.AddParm("@ReportDate", SqlDbType.DateTime, (defect.ReportDate == default(DateTime)) ? DateTime.Now : defect.ReportDate)
.AddParm("@TargetDate", SqlDbType.DateTime, ((defect.ReportDate == default(DateTime)) ? DateTime.Now : defect.ReportDate).AddDays(5))
.AddParm("@ReportedBy", SqlDbType.Int, defect.ReportedBy)
.AddParm("@Summary", SqlDbType.NVarChar, defect.Summary)
.AddParm("@Description", SqlDbType.NVarChar, string.IsNullOrWhiteSpace(defect.Description) ? defect.Summary : defect.Description)
.AddParm("@DefectTypeID", SqlDbType.Int, defect.DefectTypeID)
.AddParm("@Type", SqlDbType.NVarChar, string.IsNullOrWhiteSpace(defect.Type) ? "Common Defects" : defect.Type)
.AddParm("@LocationID", SqlDbType.Int, defect.LocationID)
.AddParm("@Contractor1ID", SqlDbType.Int, defect.Contractor1ID)
).FirstOrDefault();
return(result);
}
public List <TeamData> GetTeamData(string teamOrAgent = "")
{
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[getSalesPersonsData]",
parmsCollection
.AddParm("@userId", SqlDbType.Int, this.userContext.LoggedInUserId)
.AddParm("@teamOrAgent", SqlDbType.VarChar, teamOrAgent)
);
return(dataSet.Tables[0].ToList <TeamData>());
}
public PropertyMetaData GetPropertyMetaDataById(int propertyId)
{
var result = new PropertyMetaData();
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[getPropertyDetails]",
parmsCollection
.AddParm("@projectId", SqlDbType.Int, propertyId)
);
result.Property = dataSet.Tables[0].ToList <vw_Property>().FirstOrDefault();
result.Phases = dataSet.Tables[1].ToList <vw_Phase>();
result.Blocks = dataSet.Tables[2].ToList <vw_Block>();
result.Units = dataSet.Tables[3].ToList <vw_Unit>();
return(result);
}
public bool AddAppProspect(App_Prospect prospect)
{
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[addApp_Prospect]",
parmsCollection
.AddParm("@RowID", SqlDbType.Int, prospect.RowID)
.AddParm("@AppProspectID", SqlDbType.VarChar, prospect.AppProspectID)
.AddParm("@AccountID", SqlDbType.Int, prospect.AccountID)
.AddParm("@Address", SqlDbType.NVarChar, prospect.Address)
.AddParm("@Name", SqlDbType.NVarChar, prospect.Name)
.AddParm("@SexID", SqlDbType.Int, prospect.SexID)
.AddParm("@Birthday", SqlDbType.DateTime,
(prospect.Birthday <= new DateTime(1947, 1, 1) || !prospect.Birthday.HasValue) ? DateTime.Now.Date : prospect.Birthday.Value.Date)
.AddParm("@NationalityID", SqlDbType.Int, prospect.NationalityID)
.AddParm("@MobilePhone", SqlDbType.VarChar, prospect.MobilePhone)
.AddParm("@Email", SqlDbType.VarChar, prospect.Email)
.AddParm("@IdentityTypeID", SqlDbType.Int, (prospect.IdentityTypeID == default(int)) ? 179 : prospect.IdentityTypeID)
.AddParm("@IdentityNo", SqlDbType.VarChar, prospect.IdentityNo)
.AddParm("@SaleAgentID", SqlDbType.Int, prospect.SaleAgentID)
.AddParm("@ProjectID", SqlDbType.Int, prospect.ProjectID)
.AddParm("@PhaseID", SqlDbType.Int, prospect.PhaseID)
.AddParm("@ProbabilityID", SqlDbType.Int, prospect.ProbabilityID)
.AddParm("@Remark", SqlDbType.NVarChar, prospect.Remark)
.AddParm("@CreateUserID", SqlDbType.Int, userContext.LoggedInUserId)
.AddParm("@CreateDate", SqlDbType.DateTime, DateTime.Now)
.AddParm("@ModifyUserID", SqlDbType.Int, userContext.LoggedInUserId)
.AddParm("@ModifyDate", SqlDbType.DateTime, DateTime.Now)
);
return(true);
}
public User Register(User user, string password)
{
var userTypeTable = UserDefinedTableTypes.UserType;
var userPersonnelInfoTypeTable = UserDefinedTableTypes.UserPersonnelInfoType;
var userEducationTypeTable = UserDefinedTableTypes.UserEducationType;
var userExperienceTypeTable = UserDefinedTableTypes.UserExperienceType;
var userBusinessTypeTable = UserDefinedTableTypes.BusinessProfileType;
userTypeTable.Rows.Add(new object[]
{
user.UserId,
user.UserName,
user.FirstName,
user.LastName,
user.Email,
user.MobileNumber,
user.UniqueId,
user.JsonFeed
});
var parmsCollection = new ParmsCollection();
var result = this.unitOfWork.GetIdentityDbContext(true).ExecuteStoredProcedure <User>("[Core].[createUser]",
parmsCollection
.AddParm("@user", SqlDbType.Structured, userTypeTable, "[Core].[UserType]")
.AddParm("@password", SqlDbType.VarChar, password)).FirstOrDefault();
return(result);
}
public bool SaveActivity(CF_Activity activity)
{
if (activity.ActivityID == default(int))
{
activity.RecordStatus = "Active";
}
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[saveActivity]",
parmsCollection
.AddParm("@ActivityID", SqlDbType.Int, activity.ActivityID)
.AddParm("@ActivityTypeID", SqlDbType.Int, activity.ActivityTypeID)
.AddParm("@Title", SqlDbType.NVarChar, activity.Title)
.AddParm("@Description", SqlDbType.NVarChar, activity.Description)
.AddParm("@AssignedToID", SqlDbType.Int, activity.AssignedToID)
.AddParm("@RefTable", SqlDbType.NVarChar, activity.RefTable)
.AddParm("@RefRecordID", SqlDbType.Int, activity.RefRecordID)
.AddParm("@PlannedDate", SqlDbType.DateTime, activity.PlannedDate)
.AddParm("@ActualDate", SqlDbType.DateTime, activity.ActualDate)
.AddParm("@CompletedDate", SqlDbType.DateTime, activity.CompletedDate)
.AddParm("@DueDate", SqlDbType.DateTime, activity.DueDate)
.AddParm("@PriorityID", SqlDbType.Int, activity.PriorityID)
.AddParm("@NextScheduleDate", SqlDbType.DateTime, activity.NextScheduleDate)
.AddParm("@Remark", SqlDbType.NVarChar, activity.Remark)
.AddParm("@RecordStatus", SqlDbType.NVarChar, activity.RecordStatus)
.AddParm("@CreateUserID", SqlDbType.Int, userContext.LoggedInUserId)
.AddParm("@ModifyUserID", SqlDbType.Int, userContext.LoggedInUserId)
);
return(true);
}
public bool UpdateAppTaskItem(App_TaskList taskList)
{
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[updateApp_TaskItem]",
parmsCollection
.AddParm("@RowID", SqlDbType.Int, taskList.RowID)
.AddParm("@SaleId", SqlDbType.Int, taskList.SaleId)
.AddParm("@DueDate", SqlDbType.DateTime, taskList.DueDate)
.AddParm("@CompletedDate", SqlDbType.DateTime, taskList.CompletedDate)
.AddParm("@DaysDelayed", SqlDbType.Int, (!taskList.CompletedDate.HasValue || taskList.CompletedDate <= taskList.DueDate) ? 0 : (taskList.CompletedDate.Value - taskList.DueDate).Days)
.AddParm("@TaskName", SqlDbType.NVarChar, taskList.TaskName)
.AddParm("@Remarks", SqlDbType.NVarChar, taskList.Remarks)
.AddParm("@CreateUserID", SqlDbType.Int, userContext.LoggedInUserId)
.AddParm("@CreateDate", SqlDbType.DateTime, DateTime.Now)
.AddParm("@ModifyUserID", SqlDbType.Int, userContext.LoggedInUserId)
.AddParm("@ModifyDate", SqlDbType.DateTime, DateTime.Now)
);
return(true);
}
