public static MsCrmResult CreateInterestHouse(InterestProduct interestedHouse, IOrganizationService service) { MsCrmResult returnValue = new MsCrmResult(); try { Entity ent = new Entity("new_interestedproducts"); ent["new_name"] = DateTime.Now.ToShortDateString(); ent["new_productid"] = new EntityReference("product", interestedHouse.InterestedProduct.ProductId); if (interestedHouse.PhoneCall != null) { ent["new_phonecallid"] = interestedHouse.PhoneCall; } else { ent["new_appointmentid"] = interestedHouse.Appointment; } returnValue.CrmId = service.Create(ent); returnValue.Success = true; returnValue.Result = "Konut başarıyla eklendi."; } catch (Exception ex) { returnValue.Success = false; returnValue.Result = ex.Message; } return(returnValue); }
public static MsCrmResultObject GetAppointmentInterestedProjects(Guid activityId, SqlDataAccess sda) { MsCrmResultObject returnValue = new MsCrmResultObject(); try { #region | SQL QUERY | string query = @"SELECT IP.new_interestedproductsId Id ,P.ProductId ,P.Name ,P.new_projectid ProjectId ,P.new_projectidName ProjectIdName ,P.new_blockid BlockId ,P.new_blockidName BlockIdName ,P.new_generaltypeofhomeid GeneralHomeTypeId ,P.new_generaltypeofhomeidName GeneralHomeTypeIdName ,P.new_typeofhomeid HomeTypeId ,P.new_typeofhomeidName HomeTypeIdName ,P.new_floornumber FloorNumber ,P.new_homenumber HomeNumber FROM new_interestedproducts IP WITH (NOLOCK) INNER JOIN Product P WITH (NOLOCK) ON IP.new_appointmentid = '{0}' AND P.ProductId = IP.new_productid WHERE IP.StateCode = 0" ; #endregion DataTable dt = sda.getDataTable(string.Format(query, activityId)); if (dt != null && dt.Rows.Count > 0) { #region | GET APPOINTMENT INTEREST PRODUCTS | List <InterestProduct> returnList = new List <InterestProduct>(); for (int i = 0; i < dt.Rows.Count; i++) { InterestProduct _interest = new InterestProduct(); _interest.InterestProductId = (Guid)dt.Rows[i]["Id"]; if (dt.Rows[i]["ProductId"] != DBNull.Value) { Product _product = ProductHelper.GetProductDetail((Guid)dt.Rows[i]["ProductId"], sda); _interest.InterestedProduct = _product; } returnList.Add(_interest); } #endregion returnValue.Success = true; returnValue.ReturnObject = returnList; } else { returnValue.Success = false; returnValue.Result = "Aktiviye ait ilgilendiği bir konut bulunmamaktadır!"; } } catch (Exception ex) { returnValue.Success = false; returnValue.Result = ex.Message; } return(returnValue); }
public static MsCrmResultObject GetInterestedHouseDetail(Guid interestedHouseId, SqlDataAccess sda) { MsCrmResultObject returnValue = new MsCrmResultObject(); try { #region | SQL QUERY | string query = @"SELECT IP.new_interestedproductsId Id ,IP.new_productid ProductId ,IP.new_productidName ProductIdName ,IP.new_phonecallid PhoneCallId ,IP.new_phonecallidName PhoneCallIdName ,IP.new_appointmentid AppointmentId ,IP.new_appointmentidName AppointmentIdName FROM new_interestedproducts IP WITH (NOLOCK) WHERE IP.StateCode = 0 AND IP.new_interestedproductsId = '{0}'" ; #endregion DataTable dt = sda.getDataTable(string.Format(query, interestedHouseId)); if (dt != null && dt.Rows.Count > 0) { #region | GET INTEREST PRODUCT DETAIL | InterestProduct _interest = new InterestProduct(); _interest.InterestProductId = (Guid)dt.Rows[0]["Id"]; if (dt.Rows[0]["ProductId"] != DBNull.Value) { Product _product = new Product(); _product.ProductId = (Guid)dt.Rows[0]["ProductId"]; _product.Name = dt.Rows[0]["ProductIdName"] != DBNull.Value ? dt.Rows[0]["ProductIdName"].ToString() : string.Empty; _interest.InterestedProduct = _product; } if (dt.Rows[0]["PhoneCallId"] != DBNull.Value) { EntityReference er = new EntityReference(); er.Id = (Guid)dt.Rows[0]["PhoneCallId"]; if (dt.Rows[0]["PhoneCallIdName"] != DBNull.Value) { er.Name = dt.Rows[0]["PhoneCallIdName"].ToString(); } er.LogicalName = "phonecall"; _interest.PhoneCall = er; } if (dt.Rows[0]["AppointmentId"] != DBNull.Value) { EntityReference er = new EntityReference(); er.Id = (Guid)dt.Rows[0]["AppointmentId"]; if (dt.Rows[0]["AppointmentIdName"] != DBNull.Value) { er.Name = dt.Rows[0]["AppointmentIdName"].ToString(); } er.LogicalName = "appointment"; _interest.Appointment = er; } #endregion returnValue.Success = true; returnValue.ReturnObject = _interest; } else { returnValue.Success = false; returnValue.Result = "Beklenmedik bir hata ile karşılaşıldı!"; } } catch (Exception ex) { returnValue.Success = false; returnValue.Result = ex.Message; } return(returnValue); }