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