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 IActionResult IsDuplicateProspect([FromBody] App_Prospect prospect) { prospect.CreateUserID = this.userContext.LoggedInUserId; prospect.CreateDate = DateTime.Now; prospect.ModifyUserID = this.userContext.LoggedInUserId; prospect.ModifyDate = DateTime.Now; return(Ok(propertyBusinessAccess.IsDuplicateProspect(prospect))); }
public bool IsDuplicateProspect(App_Prospect prospect) { prospect.Name = string.IsNullOrWhiteSpace(prospect.Name) ? "" : prospect.Name.Trim(); prospect.IdentityNo = string.IsNullOrWhiteSpace(prospect.IdentityNo) ? "" : prospect.IdentityNo.Trim(); var prospectDb = default(vw_PS_Prospect); if (prospect.RowID == default(int)) { prospectDb = this.clientDbContext.vw_PS_Prospects($"Name = '{prospect.Name}'").FirstOrDefault(); } else { prospectDb = this.clientDbContext.vw_PS_Prospects($"RowID <> {prospect.RowID} AND Name = '{prospect.Name}'").FirstOrDefault(); } if (prospectDb == null) { return(false); } else { if (prospect.RowID == default(int)) { prospectDb = this.clientDbContext.vw_PS_Prospects($"Name = '{prospect.Name}' AND IdentityTypeID = {prospect.IdentityTypeID} AND IdentityNo = '{prospect.IdentityNo}'").FirstOrDefault(); } else { prospectDb = this.clientDbContext.vw_PS_Prospects($"RowID = {prospect.RowID} AND Name = '{prospect.Name}' AND IdentityTypeID = {prospect.IdentityTypeID} AND IdentityNo = '{prospect.IdentityNo}'").FirstOrDefault(); } if (prospectDb == null) { return(false); } else { return(true); } } }
public bool AddAppProspect(App_Prospect prospect) { return(this.propertyDataAccess.AddAppProspect(prospect)); }
public bool IsDuplicateProspect(App_Prospect prospect) { return(this.propertyDataAccess.IsDuplicateProspect(prospect)); }