public static MsCrmResultObject GetGiftReuqestListByStatus(DiscoveryFormStatus discoveryFormStatus, SqlDataAccess sda) { MsCrmResultObject returnValue = new MsCrmResultObject(); try { #region | SQL QUERY | string sqlQuery = @"DECLARE @objectTypeCode INT SELECT TOP 1 @objectTypeCode=e.ObjectTypeCode FROM Entity AS e (NOLOCK) WHERE e.Name='new_discoveryform' SELECT pc.new_discoveryformId AS Id ,pc.new_name AS Name ,pc.new_firstname AS FirstName ,pc.new_lastname AS LastName ,pc.new_phonenumber AS PhoneNumber ,pc.new_email AS Email ,pc.new_cityid AS CityId ,pc.new_cityidName AS CityIdName ,'new_city' AS CityIdTypeName ,pc.new_townid AS TownId ,pc.new_townidName AS TownIdName ,'new_town' AS TownIdTypeName ,pc.new_userid AS UserId ,pc.new_useridName AS UserIdName ,'new_user' AS UserIdTypeName --,pc.new_hometype AS HomeType --,smHomeType.Value AS HomeTypeValue --,pc.new_informedby AS InformedBy --,smInformedBy.Value AS InformedByValue --,pc.new_visithour AS VisitHour --,smVisitHour.Value AS VisitHourValue ,pc.new_visitdate AS VisitDate ,pc.new_formcode AS FormCode ,pc.statuscode AS Status ,pc.CreatedOn AS CreatedOn FROM new_discoveryform AS pc (NOLOCK) -- JOIN -- StringMap AS smHomeType (NOLOCK) -- ON -- smHomeType.ObjectTypeCode=@objectTypeCode -- AND -- smHomeType.AttributeName='new_hometype' -- AND -- smHomeType.AttributeValue=pc.new_hometype -- JOIN -- StringMap AS smInformedBy (NOLOCK) -- ON -- smInformedBy.ObjectTypeCode=@objectTypeCode -- AND -- smInformedBy.AttributeName='new_informedby' -- AND -- smInformedBy.AttributeValue=pc.new_informedby -- JOIN -- StringMap AS smVisitHour (NOLOCK) -- ON -- smVisitHour.ObjectTypeCode=@objectTypeCode -- AND -- smVisitHour.AttributeName='new_visithour' -- AND -- smVisitHour.AttributeValue=pc.new_visithour WHERE pc.statuscode={0}"; #endregion DataTable dt = sda.getDataTable(string.Format(sqlQuery, ((int)discoveryFormStatus)).ToString()); if (dt.Rows.Count > 0) { List <DiscoveryForm> giftList = dt.ToList <DiscoveryForm>(); returnValue.Success = true; returnValue.ReturnObject = giftList; } else { returnValue.Success = false; returnValue.Result = "Keşif form kaydı bulunamadı!"; } } catch (Exception ex) { returnValue.Success = false; returnValue.Result = ex.Message; } return(returnValue); }
public static MsCrmResultObject GetGiftReuqestListByStatus(DiscoveryFormStatus discoveryFormStatus, SqlDataAccess sda) { MsCrmResultObject returnValue = new MsCrmResultObject(); try { #region | SQL QUERY | string sqlQuery = @"DECLARE @objectTypeCode INT SELECT TOP 1 @objectTypeCode=e.ObjectTypeCode FROM Entity AS e (NOLOCK) WHERE e.Name='new_discoveryform' SELECT pc.new_discoveryformId AS Id ,pc.new_name AS Name ,pc.new_firstname AS FirstName ,pc.new_lastname AS LastName ,pc.new_phonenumber AS PhoneNumber ,pc.new_email AS Email ,pc.new_cityid AS CityId ,pc.new_cityidName AS CityIdName ,'new_city' AS CityIdTypeName ,pc.new_townid AS TownId ,pc.new_townidName AS TownIdName ,'new_town' AS TownIdTypeName ,pc.new_userid AS UserId ,pc.new_useridName AS UserIdName ,'new_user' AS UserIdTypeName --,pc.new_hometype AS HomeType --,smHomeType.Value AS HomeTypeValue --,pc.new_informedby AS InformedBy --,smInformedBy.Value AS InformedByValue --,pc.new_visithour AS VisitHour --,smVisitHour.Value AS VisitHourValue ,pc.new_visitdate AS VisitDate ,pc.new_formcode AS FormCode ,pc.statuscode AS Status ,pc.CreatedOn AS CreatedOn FROM new_discoveryform AS pc (NOLOCK) -- JOIN -- StringMap AS smHomeType (NOLOCK) -- ON -- smHomeType.ObjectTypeCode=@objectTypeCode -- AND -- smHomeType.AttributeName='new_hometype' -- AND -- smHomeType.AttributeValue=pc.new_hometype -- JOIN -- StringMap AS smInformedBy (NOLOCK) -- ON -- smInformedBy.ObjectTypeCode=@objectTypeCode -- AND -- smInformedBy.AttributeName='new_informedby' -- AND -- smInformedBy.AttributeValue=pc.new_informedby -- JOIN -- StringMap AS smVisitHour (NOLOCK) -- ON -- smVisitHour.ObjectTypeCode=@objectTypeCode -- AND -- smVisitHour.AttributeName='new_visithour' -- AND -- smVisitHour.AttributeValue=pc.new_visithour WHERE pc.statuscode={0}"; #endregion DataTable dt = sda.getDataTable(string.Format(sqlQuery, ((int)discoveryFormStatus)).ToString()); if (dt.Rows.Count > 0) { List<DiscoveryForm> giftList = dt.ToList<DiscoveryForm>(); returnValue.Success = true; returnValue.ReturnObject = giftList; } else { returnValue.Success = false; returnValue.Result = "Keşif form kaydı bulunamadı!"; } } catch (Exception ex) { returnValue.Success = false; returnValue.Result = ex.Message; } return returnValue; }