public vCaseChildren UpdateChildren(CaseBook caseBook)
{
var parmsCollection = new ParmsCollection();
var caseChildrenTable = UserDefinedTableTypes.CaseChildren;
caseChildrenTable.Rows.Add(new object[] {
caseBook.SelectedChildren.CaseChildrenId,
caseBook.SelectedChildren.CaseId,
caseBook.SelectedChildren.Name,
caseBook.SelectedChildren.Age,
caseBook.SelectedChildren.GenderLookupId,
caseBook.SelectedChildren.RelationshipWithAbuserLookupId,
caseBook.SelectedChildren.CreatedBy,
caseBook.SelectedChildren.CreatedDateTime,
caseBook.SelectedChildren.ModifiedBy,
caseBook.SelectedChildren.ModifiedDatetime,
});
caseChildrenTable.AcceptChanges();
var updatedChildren = this.unitOfWork.DbContext.ExecuteStoredProcedure <vCaseChildren>("[Ops].[saveChildren]",
parmsCollection
.AddParm("@caseChildrenType", SqlDbType.Structured, caseChildrenTable, "[Ops].[CaseChildrenType]")
).Last();
return(updatedChildren);
}
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 vCaseAddress UpdateAddress(CaseBook caseBook)
{
var parmsCollection = new ParmsCollection();
var caseAddressTable = UserDefinedTableTypes.CaseAddress;
caseAddressTable.Rows.Add(new object[] {
caseBook.SelectedAddress.CaseAddressId,
caseBook.SelectedAddress.CaseId,
caseBook.SelectedAddress.Address,
caseBook.SelectedAddress.Area,
caseBook.SelectedAddress.CityId,
caseBook.SelectedAddress.StateId,
caseBook.SelectedAddress.PIN,
caseBook.SelectedAddress.CreatedBy,
caseBook.SelectedAddress.CreatedDateTime,
caseBook.SelectedAddress.ModifiedBy,
caseBook.SelectedAddress.ModifiedDatetime,
});
caseAddressTable.AcceptChanges();
var updatedAddress = this.unitOfWork.DbContext.ExecuteStoredProcedure <vCaseAddress>("[Ops].[saveAddress]",
parmsCollection
.AddParm("@caseAddressType", SqlDbType.Structured, caseAddressTable, "[Ops].[CaseAddressType]")
).Last();
return(updatedAddress);
}
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 void AddPeaceMaker(PeaceMaker peaceMaker)
{
var parmsCollection = new ParmsCollection();
this.unitOfWork.DbContext.PeaceMakers.Add(peaceMaker);
this.unitOfWork.DbContext.SaveChanges();
}
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 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 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 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 void AddCounselor(Counselor counselor)
{
var parmsCollection = new ParmsCollection();
this.unitOfWork.DbContext.Counselors.Add(counselor);
this.unitOfWork.DbContext.SaveChanges();
}
public CaseHeader UpdateLegal(CaseBook caseBook)
{
var parmsCollection = new ParmsCollection();
var caseChildrenTable = UserDefinedTableTypes.Legal;
caseChildrenTable.Rows.Add(new object[] {
caseBook.Legal.CaseLegalId,
caseBook.Legal.CaseId,
caseBook.Legal.CaseNumber,
caseBook.Legal.Court,
caseBook.Legal.Prayer,
caseBook.Legal.LegalRepresentative,
caseBook.Legal.LegalConsentFormLookupId,
caseBook.Legal.LegalActionLookupId,
caseBook.Legal.OutcomeLookupId,
caseBook.Legal.DocumentsLookupId
});
caseChildrenTable.AcceptChanges();
var updatedCase = this.unitOfWork.DbContext.ExecuteStoredProcedure <CaseHeader>("[Ops].[saveLegal]",
parmsCollection
.AddParm("@caseLegalType", SqlDbType.Structured, caseChildrenTable, "[Ops].[CaseLegalType]")
).First();
return(updatedCase);
}
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 List <PropertyData> GetPropertyData()
{
var parmsCollection = new ParmsCollection();
var dataSet = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[getProjectData]",
parmsCollection
.AddParm("@userId", SqlDbType.Int, this.userContext.LoggedInUserId));
return(dataSet.Tables[0].ToList <PropertyData>());
}
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 List <ProfileScore> GetProfileScore(int userId)
{
var parmsCollection = new ParmsCollection();
var result = this.unitOfWork.GetIdentityDbContext(true).ExecuteStoredProcedure <ProfileScore>("[Scores].[getProfileScore]",
parmsCollection
.AddParm("@userId", SqlDbType.Int, userId)).ToList();
return(result);
}
public CaseHeader SavePrimaryCase(CaseBook caseBook)
{
var parmsCollection = new ParmsCollection();
var caseTable = UserDefinedTableTypes.Case;
caseTable.Rows.Add(new object[] {
caseBook.Case.CaseId,
caseBook.Case.CaseNumber,
caseBook.Case.CenterId,
caseBook.Case.CaseStausId,
caseBook.Case.CounselorId,
caseBook.Case.PeaceMakerId,
caseBook.Case.ClientFirstName,
caseBook.Case.ClientLastName,
caseBook.Case.Mi,
caseBook.Case.FatherName,
caseBook.Case.GenderLookupId,
caseBook.Case.RequireAssistanceLookupId,
caseBook.Case.MaritalStatusLookupId,
caseBook.Case.Remarks,
caseBook.Case.RegisterDate,
caseBook.Case.MobileNumber,
caseBook.Case.CreatedBy,
caseBook.Case.CreatedDateTime,
caseBook.Case.ModifiedBy,
caseBook.Case.ModifiedDatetime,
});
caseTable.AcceptChanges();
var caseAddressTable = UserDefinedTableTypes.CaseAddress;
caseAddressTable.Rows.Add(new object[] {
caseBook.SelectedAddress.CaseAddressId,
caseBook.SelectedAddress.CaseId,
caseBook.SelectedAddress.Address,
caseBook.SelectedAddress.Area,
caseBook.SelectedAddress.CityId,
caseBook.SelectedAddress.StateId,
caseBook.SelectedAddress.PIN,
caseBook.SelectedAddress.CreatedBy,
caseBook.SelectedAddress.CreatedDateTime,
caseBook.SelectedAddress.ModifiedBy,
caseBook.SelectedAddress.ModifiedDatetime,
});
caseAddressTable.AcceptChanges();
var updatedCase = this.unitOfWork.DbContext.ExecuteStoredProcedure <CaseHeader>("[Ops].[savePrimaryCase]",
parmsCollection
.AddParm("@caseType", SqlDbType.Structured, caseTable, "[Ops].[CaseType]")
.AddParm("@caseAddressType", SqlDbType.Structured, caseAddressTable, "[Ops].[CaseAddressType]")
).First();
return(updatedCase);
}
public CaseHeader UpdateAbuse(CaseBook caseBook)
{
var parmsCollection = new ParmsCollection();
var caseChildrenTable = UserDefinedTableTypes.Abuse;
caseChildrenTable.Rows.Add(new object[] {
caseBook.Abuse.CaseAbuseId,
caseBook.Abuse.CaseId,
caseBook.Abuse.SufferingFromAbuseLookupId,
caseBook.Abuse.SufferingFromAbuseDesc,
caseBook.Abuse.FeelAboutAbuseLookupId,
caseBook.Abuse.ParentsFeelAboutAbuseLookupId,
caseBook.Abuse.LawFeelAboutAbuseLookupId,
caseBook.Abuse.SignsOfPhysicalAbuseLookupId,
caseBook.Abuse.SignsOfPhysicalAbuseDesc,
caseBook.Abuse.WeaponsUsedLookupId,
caseBook.Abuse.WeaponsUsedDesc,
caseBook.Abuse.TypesOfPhyscialAbuseLookupId,
caseBook.Abuse.FrequencyOfPhyscialAbuseLookupId,
caseBook.Abuse.NumberOfYearsOfPhyscialAbuse,
caseBook.Abuse.TypesOfEmotionalAbuseLookupId,
caseBook.Abuse.FrequencyOfEmotionalAbuseLookupId,
caseBook.Abuse.NumberOfYearsOfEmotionalAbuse,
caseBook.Abuse.TypesOfSexualAbuseLookupId,
caseBook.Abuse.FrequencyOfSexualAbuseLookupId,
caseBook.Abuse.NumberOfYearsOfSexualAbuse,
caseBook.Abuse.TypesOfEconomicAbuseLookupId,
caseBook.Abuse.FrequencyOfEconomicAbuseLookupId,
caseBook.Abuse.NumberOfYearsOfEconomicAbuse,
caseBook.Abuse.ReasonsForAbuseLookupId,
caseBook.Abuse.ReasonForAbuseDesc,
caseBook.Abuse.PhysicalAbuseDesc,
caseBook.Abuse.EmotionalAbuseDesc,
caseBook.Abuse.SexualAbuseDesc,
caseBook.Abuse.EconomicAbuseDesc,
});
caseChildrenTable.AcceptChanges();
var updatedCase = this.unitOfWork.DbContext.ExecuteStoredProcedure <CaseHeader>("[Ops].[saveAbuse]",
parmsCollection
.AddParm("@caseAbuseType", SqlDbType.Structured, caseChildrenTable, "[Ops].[CaseAbuseType]")
).First();
return(updatedCase);
}
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 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 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 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 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 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 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 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 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 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 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 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);
}
