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