public SendSms()
{
InitializeComponent();
try
{
LOG_PATH = Globals.FileLogPath;
ERROR_LOG_PATH = Globals.FileLogPath;
_tokenSource = new CancellationTokenSource();
_token = _tokenSource.Token;
_timer = new System.Timers.Timer();
_timer.Interval = Convert.ToDouble(ConfigurationManager.AppSettings["serviceInterval"]);
_timer.AutoReset = true;
_timer.Enabled = true;
_timer.Elapsed += timer_Elapsed;
_sda = new SqlDataAccess();
_sda.openConnection(Globals.ConnectionString);
_service = MSCRM.GetOrgService(true);
_serviceProcess = new ServiceProcess(_sda, _service);
}
catch (Exception ex)
{
FileLogHelper.LogFunction(this.GetType().Name, "SendSms_SendSms_EXCEPTION:" + ex.Message, ERROR_LOG_PATH);
}
}
public static MsCrmResult CheckOldPasswordCorrect(Guid portalUserId, string oldPassword, SqlDataAccess sda)
{
MsCrmResult returnValue = new MsCrmResult();
try
{
#region | SQL QUERY |
string sqlQuery = @"SELECT
COUNT(0) AS RecCount
FROM
new_user AS u (NOLOCK)
WHERE
u.new_userId='{0}'
AND
u.new_password='******'";
#endregion
int recCount = (int)sda.ExecuteScalar(string.Format(sqlQuery, portalUserId, oldPassword.Trim()));
if (recCount > 0)
{
returnValue.Success = true;
returnValue.Result = "Eski şifre ile bilgiler eşleşti.";
}
else
{
returnValue.Result = "Eski şifre bilginiz yanlıştır.<br />Lütfen kontrol ediniz.";
}
}
catch (Exception ex)
{
returnValue.Result = ex.Message;
}
return returnValue;
}
public static Annotation GetAnnotationDetail(Guid annotationId, SqlDataAccess sda)
{
Annotation returnValue = new Annotation();
try
{
#region | SQL QUERY |
string query = @"SELECT
A.AnnotationId
,A.MimeType
,A.FileName
,A.DocumentBody
FROM
Annotation A
WHERE
A.AnnotationId = '{0}'";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, annotationId));
if (dt != null && dt.Rows.Count > 0)
{
returnValue.AnnotationId = (Guid)dt.Rows[0]["AnnotationId"];
returnValue.MimeType = dt.Rows[0]["MimeType"] != DBNull.Value ? dt.Rows[0]["MimeType"].ToString() : string.Empty;
returnValue.FileName = dt.Rows[0]["FileName"] != DBNull.Value ? dt.Rows[0]["FileName"].ToString() : string.Empty;
returnValue.File = dt.Rows[0]["DocumentBody"] != DBNull.Value ? dt.Rows[0]["DocumentBody"].ToString() : string.Empty;
}
}
catch (Exception)
{
}
return returnValue;
}
public static MsCrmResult CheckPhoneNumberMatch(string userName, string phoneNumber, string portalId, SqlDataAccess sda)
{
MsCrmResult returnValue = new MsCrmResult();
try
{
#region | SQL QUERY |
string sqlQuery = @"SELECT
u.new_userId AS PortalUserId
,c.ContactId
,c.MobilePhone
FROM
new_user AS u (NOLOCK)
JOIN
new_new_user_new_role AS ur (NOLOCK)
ON
u.new_userId=ur.new_userid
JOIN
new_role AS r (NOLOCK)
ON
r.new_roleId=ur.new_roleid
AND
r.new_portalId='{2}'
JOIN
Contact AS c (NOLOCK)
ON
c.ContactId=u.new_contactId
WHERE
u.new_name='{0}'
AND
u.statecode=0
AND
u.statuscode=1 --Active
AND
c.MobilePhone='{1}'";
#endregion
DataTable dt = sda.getDataTable(string.Format(sqlQuery, userName, phoneNumber, portalId));
if (dt.Rows.Count > 0)
{
returnValue.Success = true;
returnValue.Result = dt.Rows[0]["ContactId"].ToString();
returnValue.CrmId = (Guid)dt.Rows[0]["PortalUserId"];
}
}
catch (Exception ex)
{
returnValue.Result = ex.Message;
}
return returnValue;
}
public MsCrmResult GetToken(string portalId, string userName, string password)
{
MsCrmResult returnValue = new MsCrmResult();
try
{
if (!string.IsNullOrEmpty(userName) && !string.IsNullOrEmpty(password) && !string.IsNullOrEmpty(portalId))
{
_sda = new SqlDataAccess();
_sda.openConnection(Globals.ConnectionString);
returnValue = LoginHelper.LoginControl(new Guid(portalId), userName, password, _sda);
//returnValue.Success = true;
if (returnValue.Success)
{
Guid systemUserId = returnValue.CrmId;
IOrganizationService service = MSCRM.GetOrgService(true);
string ipAddress = HttpContext.Current.Request.UserHostAddress;
MsCrmResult logResult = LoginHelper.LogLogIn(returnValue.CrmId, new Guid(portalId), DateTime.Now, ipAddress, service);
returnValue.Result = Guid.NewGuid().ToString().Replace("-", "");
MsCrmResult sessionResult = SetUserSession(returnValue.Result, new Guid(portalId), systemUserId);
if (!sessionResult.Success)
{
return sessionResult;
}
}
}
else
{
returnValue.Result = "Eksik Parametre.";
}
}
catch (Exception ex)
{
returnValue.Result = ex.Message;
}
finally
{
if (_sda != null)
{
_sda.closeConnection();
}
}
return returnValue;
}
public ServiceProcess(SqlDataAccess sda, IOrganizationService service)
{
_sda = sda;
_service = service;
LOG_PATH = Globals.FileLogPath;
ERROR_LOG_PATH = Globals.FileLogPath;
SMTP_USERNAME = ConfigurationManager.AppSettings["username"].ToString();
SMTP_PASSWORD = ConfigurationManager.AppSettings["password"].ToString();
FROM_MAILADDRESS = ConfigurationManager.AppSettings["mailaddress"].ToString();
MAIL_HOST = ConfigurationManager.AppSettings["hostaddress"].ToString();
PORT = ConfigurationManager.AppSettings["port"].ToString();
}
public MsCrmResult ConfirmForm(string token, int formCode)
{
MsCrmResult returnValue = new MsCrmResult();
LoginSession ls = new LoginSession();
try
{
_sda = new SqlDataAccess();
_sda.openConnection(Globals.ConnectionString);
#region | CHECK SESSION |
MsCrmResultObject sessionResult = GetUserSession(token);
if (!sessionResult.Success)
{
returnValue.Result = sessionResult.Result;
return returnValue;
}
else
{
ls = (LoginSession)sessionResult.ReturnObject;
}
#endregion
MsCrmResultObject resultFormInfo = DiscoveryFormHelper.GetDiscoveryFormInfo(formCode, _sda);
if (resultFormInfo.Success)
{
DiscoveryForm formInfo = (DiscoveryForm)resultFormInfo.ReturnObject;
formInfo.Status = new OptionSetValueWrapper() { AttributeValue = (int)DiscoveryFormStatus.LotusConfirmed };
}
else
{
returnValue.Result = resultFormInfo.Result;
}
}
catch (Exception ex)
{
returnValue.Result = ex.Message;
}
return returnValue;
}
public static MsCrmResultObj<List<Town>> GetAllTowns(SqlDataAccess sda)
{
MsCrmResultObj<List<Town>> returnValue = new MsCrmResultObj<List<Town>>();
try
{
#region | SQL QUERY |
string sqlQuery = @"SELECT
t.new_townId AS Id
,t.new_name AS Name
,t.new_towncode AS Code
,t.new_cityId AS CityId
,t.new_cityIdName AS CityIdName
,'new_city' AS CityIdTypeName
FROM
new_town AS t (NOLOCK)
JOIN
new_city AS c (NOLOCK)
ON
t.new_cityId=c.new_cityId";
#endregion
DataTable dt = sda.getDataTable(string.Format(sqlQuery));
if (dt.Rows.Count > 0)
{
List<Town> townList = dt.ToList<Town>();
returnValue.Success = true;
returnValue.ReturnObject = townList;
}
else
{
returnValue.Result = "Kayıt bulunamadı.";
}
}
catch (Exception ex)
{
returnValue.Result = ex.Message;
returnValue.HasException = true;
}
return returnValue;
}
public static MsCrmResultObject GetArticleCategoryInfo(Guid categoryId, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"SELECT DISTINCT
E.new_articlecategoryId AS Id
,E.new_name Name
,E.new_portalId PortalId
,E.new_portalIdName PortalIdName
,E.new_imageurl AS ImageUrl
FROM
new_articlecategory AS E (NOLOCK)
WHERE
E.new_articlecategoryId = '{0}'
AND
E.statuscode=1 --Active";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, categoryId));
if (dt != null && dt.Rows.Count > 0)
{
EntityReference er = new EntityReference()
{
Id = (Guid)dt.Rows[0]["Id"],
Name = dt.Rows[0]["Name"].ToString(),
LogicalName = dt.Rows[0]["ImageUrl"] != DBNull.Value ? dt.Rows[0]["ImageUrl"].ToString() : "no_image_available.png"
};
returnValue.Success = true;
returnValue.ReturnObject = er;
}
else
{
returnValue.Success = false;
returnValue.Result = "M024";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public static MsCrmResultObject GetPointCodeInfo(string code, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string sqlQuery = @"SELECT
pc.new_pointcodeId AS Id
,pc.new_name AS Name
,pc.new_portalid AS PortalId
,pc.new_portalidName AS PortalIdName
,'new_portal' AS PortalIdTypeName
,pc.new_group AS GroupCode
,pc.new_code AS Code
,pc.new_point AS Point
,pc.statuscode AS Status
FROM
new_pointcode AS pc (NOLOCK)
WHERE
pc.new_code='{0}'";
#endregion
DataTable dt = sda.getDataTable(string.Format(sqlQuery, code));
if (dt.Rows.Count > 0)
{
List<PointCode> pCode = dt.ToList<PointCode>();
returnValue.Success = true;
returnValue.ReturnObject = pCode[0];
}
else
{
returnValue.Result = "Kod bulunamadı.";
}
}
catch (Exception ex)
{
returnValue.Result = ex.Message;
}
return returnValue;
}
public ServiceProcess(SqlDataAccess sda, IOrganizationService service)
{
_sda = sda;
_service = service;
LOG_PATH = Globals.FileLogPath;
ERROR_LOG_PATH = Globals.FileLogPath;
MsCrmResultObject resultSmsConf = SMSHelper.GetSmsConfigurationInfo(new Guid(Globals.SmsConfigurationDoluHayatId), sda);
if (!resultSmsConf.Success)
{
FileLogHelper.LogFunction(this.GetType().Name,"SendSms_ServiceProcess_NOCONFIG_DEFINATION", LOG_PATH);
}
SMS_CONFIG = (SmsConfiguration)resultSmsConf.ReturnObject;
_smsApi = new smsService.smsservice();
}
public static MsCrmResult CheckIsUserYourFriend(Guid portalId, Guid portalUserId, Guid selectedUserId, SqlDataAccess sda)
{
MsCrmResult returnValue = new MsCrmResult();
try
{
#region | SQL QUERY |
string query = @"SELECT
f.new_friendshipId AS Id
FROM
new_friendship AS f (NOLOCK)
WHERE
f.new_portalId='{0}'
AND
f.statecode=0
AND
(
(f.new_partyoneId='{1}' AND f.new_partytwoId='{2}')
OR
(f.new_partyoneId='{2}' AND f.new_partytwoId='{1}')
)";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, portalId, portalUserId, selectedUserId));
if (dt != null && dt.Rows.Count > 0)
{
returnValue.Success = true;
returnValue.CrmId = (Guid)dt.Rows[0]["Id"];
}
else
{
returnValue.Success = false;
returnValue.Result = "M039"; //"Kullanıcı arkadaşınız değildir!";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public static MsCrmResult GetPortalId(string url, SqlDataAccess sda)
{
MsCrmResult returnValue = new MsCrmResult();
try
{
#region | SQL QUERY |
string query = @"SELECT
u.new_portalId AS BrandId
FROM
new_portalurl AS u (NOLOCK)
JOIN
new_portal AS b (NOLOCK)
ON
b.new_portalId=u.new_portalId
AND
b.statecode=0
AND
b.statuscode=1 --Active
WHERE
u.new_name='{0}'
AND
u.statecode=0";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, url));
if (dt != null && dt.Rows.Count > 0)
{
returnValue.CrmId = (Guid)dt.Rows[0]["BrandId"];
returnValue.Success = true;
}
else
{
returnValue.Result = "M004"; //"Girmiş olduğunuz adres herhangi bir portala ait değil.";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public static MsCrmResult LoginControl(Guid portalId, string userName, string password, SqlDataAccess sda)
{
MsCrmResult returnValue = new MsCrmResult();
try
{
#region | SQL QUERY |
string query = @"SELECT
U.new_userId UserId
FROM
new_user U (NoLock)
WHERE
U.new_name = '{0}'
AND
U.new_password = '******'
AND
U.statecode = 0
AND
U.statuscode = {2}";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, userName, password, (int)PortalUserStatus.Active));
if (dt != null && dt.Rows.Count > 0)
{
returnValue.CrmId = (Guid)dt.Rows[0]["UserId"];
MsCrmResultObject roleResult = PortalUserHelper.GetPortalUserRoles(portalId, returnValue.CrmId, sda);
returnValue.Success = roleResult.Success;
returnValue.Result = roleResult.Result;
}
else
{
returnValue.Success = false;
returnValue.Result = "M035"; //"Hatalı kullanıcı adı veya şifre!";
}
}
catch (Exception ex)
{
throw ex;
}
return returnValue;
}
public static MsCrmResult GetPageContent(Guid portalId, PageNames pageName, SqlDataAccess sda)
{
MsCrmResult returnValue = new MsCrmResult();
try
{
#region | SQL QUERY |
string sqlQuery = @"SELECT
pc.new_content AS Content
FROM
new_pagecontent AS pc (NOLOCK)
WHERE
pc.new_portalId='{0}'
AND
pc.new_page={1}
AND
pc.statecode=0";
#endregion
DataTable dt = sda.getDataTable(string.Format(sqlQuery, portalId, ((int)pageName).ToString()));
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["Content"] != DBNull.Value)
{
returnValue.Success = true;
returnValue.Result = dt.Rows[0]["Content"].ToString();
}
}
else
{
returnValue.Result = "M051"; //"Sayfa içeriği hazırlanmamıştır.";
}
}
catch (Exception ex)
{
returnValue.Result = ex.Message;
}
return returnValue;
}
public static int GetUserLoginCount(Guid portalId, Guid portalUserId, DateTime start, DateTime end, SqlDataAccess sda)
{
int returnValue = 0;
try
{
#region | SQL QUERY |
string sqlQuery = @"SELECT
COUNT(0)
FROM
new_loginlog AS ll (NOLOCK)
WHERE
ll.new_portalId=@PortalId
AND
ll.new_userId=@UserId
AND
ll.new_logindate BETWEEN @start AND @end
AND
ll.StateCode=0";
#endregion
SqlParameter[] parameters = {
new SqlParameter("@PortalId",portalId)
,new SqlParameter("@UserId",portalUserId)
,new SqlParameter("@start",start)
,new SqlParameter("@end",end)
};
returnValue = (int)sda.ExecuteScalar(sqlQuery, parameters);
}
catch (Exception ex)
{
}
return returnValue;
}
public static MsCrmResultObj<List<City>> GetCities(SqlDataAccess sda)
{
MsCrmResultObj<List<City>> returnValue = new MsCrmResultObj<List<City>>();
try
{
#region | SQL QUERY |
string sqlQuery = @"SELECT
c.new_cityId AS Id
,c.new_name AS Name
,c.new_citycode AS Code
FROM
new_city AS c (NOLOCK)
WHERE
c.new_countryId='F55A5B6D-B32E-E511-80C4-000D3A216510'";
#endregion
DataTable dt = sda.getDataTable(sqlQuery);
if (dt.Rows.Count > 0)
{
List<City> cityList = dt.ToList<City>();
returnValue.Success = true;
returnValue.ReturnObject = cityList;
}
else
{
returnValue.Result = "Kayıt bulunamadı.";
}
}
catch (Exception ex)
{
returnValue.Result = ex.Message;
}
return returnValue;
}
public void Process(SqlDataAccess sda)
{
FileLogHelper.LogFunction(this.GetType().Name, "SendNpsSurvey_ServiceProcess_Process_TRIGGERED", LOG_PATH);
SqlParameter[] parameters = new SqlParameter[]{
new SqlParameter("@statusCode",(int)NpsSurveyStatus.Created)
};
try
{
DataTable dt = _sda.getDataTable(Constants.QUERY_GET_NPS_SURVEY_RECORDS_BY_STATUSCODE, parameters);
FileLogHelper.LogFunction(this.GetType().Name, "SendNpsSurvey_ServiceProcess_Process_SurveyRecordCount:" + dt.Rows.Count.ToString(), LOG_PATH);
foreach (DataRow row in dt.Rows)
{
SendSurveyMail((Guid)row["Id"], row["EmailAddress"].ToString(), (Guid)row["RequestId"]);
}
}
catch (Exception ex)
{
FileLogHelper.LogFunction(this.GetType().Name, "SendNpsSurvey_ServiceProcess_Process_EXCEPTION:" + ex.Message, ERROR_LOG_PATH);
}
}
public void Process(SqlDataAccess sda)
{
FileLogHelper.LogFunction(this.GetType().Name,"SendSms_ServiceProcess_Process_TRIGGERED", LOG_PATH);
SqlParameter[] parameters = new SqlParameter[]{
new SqlParameter("@statusCode",(int)SmsStatusCode.WaitingSend)
};
try
{
DataTable dt = _sda.getDataTable(Constants.QUERY_GET_SMS_RECORDS_BY_STATUSCODE, parameters);
FileLogHelper.LogFunction(this.GetType().Name,"SendSms_ServiceProcess_Process_SmsRecordCount:" + dt.Rows.Count.ToString(), LOG_PATH);
foreach (DataRow row in dt.Rows)
{
SendSms((Guid)row["Id"], row["PhoneNumber"].ToString(), row["Message"].ToString());
}
}
catch (Exception ex)
{
FileLogHelper.LogFunction(this.GetType().Name,"SendSms_ServiceProcess_Process_EXCEPTION:" + ex.Message, ERROR_LOG_PATH);
}
}
public static MsCrmResultObject GetGraffities(Guid portalId, int commentCount, int startRow, int endRow, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"SELECT
A.*
FROM
(
SELECT
PG.new_graffitiId GraffitiId
,PG.new_content [Description]
,PG.new_userId PortalUserId
,PG.new_userIdName PortalUserIdName
,PG.new_portalId BrandId
,PG.new_portalIdName BrandIdName
,PG.new_imageurl [Image]
,U.new_imageurl UserImage
,CAST({4}.dbo.fn_UTCToTzSpecificLocalTime(PG.CreatedOn, us.TimeZoneBias, us.TimeZoneDaylightBias,us.TimeZoneDaylightYear, us.TimeZoneDaylightMonth, us.TimeZoneDaylightDay, us.TimeZoneDaylightHour,us.TimeZoneDaylightMinute, us.TimeZoneDaylightSecond, 0, us.TimeZoneDaylightDayOfWeek,us.TimeZoneStandardBias, us.TimeZoneStandardYear, us.TimeZoneStandardMonth, us.TimeZoneStandardDay,us.TimeZoneStandardHour, us.TimeZoneStandardMinute, us.TimeZoneStandardSecond, 0,us.TimeZoneStandardDayOfWeek) as DATETIME) CreatedOn
,ROW_NUMBER() OVER(ORDER BY PG.CreatedOn DESC) AS RowNumber
,(
SELECT
COUNT(0)
FROM
new_comment AS c (NOLOCK)
WHERE
c.new_graffitiId=PG.new_graffitiId
) AS CommentCount
,(
SELECT
COUNT(0)
FROM
new_likerecord AS lr (NOLOCK)
WHERE
lr.new_graffitiId=PG.new_graffitiId
) AS LikeCount
FROM
new_graffiti PG (NoLock)
INNER JOIN
new_user U (NoLock)
ON
PG.new_portalId = '{0}'
AND
PG.statecode = 0
AND
U.new_userId = PG.new_userId
INNER JOIN
dbo.UserSettingsBase US (NoLock)
ON
US.SystemUserId ='{1}'
WHERE
PG.statecode=0
AND
PG.statuscode=1 --Active
)A
WHERE
A.RowNumber BETWEEN {2} AND {3}
ORDER BY
A.RowNumber ASC";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, portalId, Globals.AdminId, startRow, endRow, Globals.DatabaseName));
if (dt != null && dt.Rows.Count > 0)
{
List<Graffiti> returnList = new List<Graffiti>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Graffiti _graffiti = new Graffiti();
_graffiti.GraffitiId = (Guid)dt.Rows[i]["GraffitiId"];
_graffiti.Description = dt.Rows[i]["Description"] != DBNull.Value ? dt.Rows[i]["Description"].ToString() : string.Empty;
_graffiti.ImagePath = dt.Rows[i]["Image"] != DBNull.Value ? dt.Rows[i]["Image"].ToString() : string.Empty;
_graffiti.PortalUserImage = dt.Rows[i]["UserImage"] != DBNull.Value ? dt.Rows[i]["UserImage"].ToString() : "nouserprofile.jpg";
_graffiti.CreatedOnString = dt.Rows[i]["CreatedOn"] != DBNull.Value ? ((DateTime)dt.Rows[i]["CreatedOn"]).ToString("dd MMMM yyyy, HH:mm", new CultureInfo("tr-TR", false)) : string.Empty;
_graffiti.HasMedia = dt.Rows[i]["Image"] != DBNull.Value ? true : false;
_graffiti.LikeCount = (int)dt.Rows[i]["LikeCount"];
_graffiti.CommentCount = (int)dt.Rows[i]["CommentCount"];
if (dt.Rows[i]["CreatedOn"] != DBNull.Value)
{
_graffiti.CreatedOn = (DateTime)dt.Rows[i]["CreatedOn"];
}
if (dt.Rows[i]["PortalUserId"] != DBNull.Value)
{
EntityReference er = new EntityReference();
er.LogicalName = "new_user";
er.Id = (Guid)dt.Rows[i]["PortalUserId"];
if (dt.Rows[i]["PortalUserIdName"] != DBNull.Value) { er.Name = dt.Rows[i]["PortalUserIdName"].ToString(); }
_graffiti.PortalUser = er;
}
if (dt.Rows[i]["BrandId"] != DBNull.Value)
{
EntityReference er = new EntityReference();
er.LogicalName = "new_brand";
er.Id = (Guid)dt.Rows[i]["BrandId"];
if (dt.Rows[i]["BrandIdName"] != DBNull.Value) { er.Name = dt.Rows[i]["BrandIdName"].ToString(); }
_graffiti.Portal = er;
}
#region | GET COMMENTS |
MsCrmResultObject commentResult = CommentHelper.GetGraffitiComments(_graffiti.GraffitiId, 0, commentCount, sda);
//MsCrmResultObject commentResult = CommentHelper.GetGraffitiComments(_graffiti.GraffitiId, sda);
if (commentResult.Success)
{
_graffiti.CommentList = (List<Comment>)commentResult.ReturnObject;
}
#endregion
returnList.Add(_graffiti);
}
returnValue.Success = true;
returnValue.ReturnObject = returnList;
}
else
{
returnValue.Success = true;
returnValue.Result = "M013"; //"Duvar yazısı bulunamadı!";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public static int GetUserGraffitiCount(Guid portalId, Guid portalUserId, DateTime start, DateTime end, bool hasMedia, SqlDataAccess sda)
{
int returnValue = 0;
try
{
#region | SQL QUERY |
string sqlQuery = @"SELECT
COUNT(0)
FROM
new_graffiti AS gr (NOLOCK)
WHERE
gr.new_portalId=@PortalId
AND
gr.new_userId=@UserId
AND
gr.CreatedOn BETWEEN @start AND @end
AND
gr.StateCode=0
AND
gr.statuscode=1 --Etkin
AND
gr.new_imageurl " + (hasMedia ? " IS NOT NULL" : " IS NULL");
#endregion
SqlParameter[] parameters = {
new SqlParameter("@PortalId",portalId)
,new SqlParameter("@UserId",portalUserId)
,new SqlParameter("@start",start)
,new SqlParameter("@end",end)
};
returnValue = (int)sda.ExecuteScalar(sqlQuery, parameters);
}
catch (Exception ex)
{
}
return returnValue;
}
public void Execute(IServiceProvider serviceProvider)
{
SqlDataAccess sda = null;
try
{
sda = new SqlDataAccess();
sda.openConnection(Globals.ConnectionString);
#region | SERVICE |
IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));
#region | Validate Request |
//Target yoksa veya Entity tipinde değilse, devam etme.
if (!context.InputParameters.Contains("Target") || !(context.InputParameters["Target"] is Entity))
{
return;
}
#endregion
IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));
IOrganizationService service = serviceFactory.CreateOrganizationService(context.UserId);
#endregion
Entity entity = (Entity)context.InputParameters["Target"];
#region | VARIABLES |
bool hasMedia = false;
List<ScoreLimit> lstLimits = new List<ScoreLimit>();
EntityReference portal = null;
EntityReference user = null;
if (entity.Contains("new_hasmedia") && entity["new_hasmedia"] != null)
{
hasMedia = (bool)entity["new_hasmedia"];
}
if (entity.Contains("new_portalid") && entity["new_portalid"] != null)
{
portal = (EntityReference)entity["new_portalid"];
}
if (entity.Contains("new_userid") && entity["new_userid"] != null)
{
user = (EntityReference)entity["new_userid"];
}
#endregion
MsCrmResultObject limitRes = new MsCrmResultObject();
if (hasMedia)
limitRes = ScoreHelper.GetScoreLimitsByType(ScoreType.GraffitiMedia, sda);
else
limitRes = ScoreHelper.GetScoreLimitsByType(ScoreType.GraffitiText, sda);
if (limitRes.Success)
{
lstLimits = (List<ScoreLimit>)limitRes.ReturnObject;
for (int i = 0; i < lstLimits.Count; i++)
{
int recCount = 0;
DateTime start = GeneralHelper.GetStartDateByScorePeriod(lstLimits[i].Period);
DateTime end = GeneralHelper.GetEndDateByScorePeriod(lstLimits[i].Period);
recCount = GraffitiHelper.GetUserGraffitiCount(portal.Id, user.Id, start, end, hasMedia, sda);
if (lstLimits[i].Frequency >= recCount)
{
Score sc = new Score()
{
Point = lstLimits[i].Point,
Portal = portal,
User = user,
ScoreType = (hasMedia ? ScoreType.GraffitiMedia : ScoreType.GraffitiText)
};
MsCrmResult scoreRes = ScoreHelper.CreateScore(sc, service);
break;
}
}
}
}
catch (Exception ex)
{
//LOG
throw new InvalidPluginExecutionException(ex.Message);
}
finally
{
if (sda != null)
sda.closeConnection();
}
}
public static MsCrmResultObject SearchContact(Guid portalId, Guid userId, string key, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"SELECT DISTINCT
u.new_userId AS UserId
,u.new_name AS UserName
,u.new_imageurl AS ImageUrl
,c.FullName
,c.JobTitle
,CASE WHEN fr.new_friendshipId IS NOT NULL THEN 1 ELSE 0 END AS IsFriend
FROM
new_user AS u (NOLOCK)
JOIN
new_new_user_new_role AS ur (NOLOCK)
ON
ur.new_userid=u.new_userId
JOIN
new_role AS r (NOLOCK)
ON
ur.new_roleid=r.new_roleId
AND
r.statecode=0
AND
r.statuscode=1 --Active
AND
r.new_portalId='{0}'
JOIN
Contact AS c (NOLOCK)
ON
u.new_contactId=c.ContactId
LEFT JOIN
new_friendship AS fr (NOLOCK)
ON
'{2}' IN (fr.new_partyOneId,fr.new_partyTwoId)
AND
u.new_userId IN (fr.new_partyOneId,fr.new_partyTwoId)
AND
fr.statecode=0
WHERE
u.statecode=0
AND
u.new_userId!='{2}'
AND
u.statuscode=1 --Active
AND
c.FullName LIKE '%{1}%'";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, portalId, key, userId));
if (dt != null && dt.Rows.Count > 0)
{
List<UserFriends> lstUser = new List<UserFriends>();
for (int i = 0; i < dt.Rows.Count; i++)
{
UserFriends uf = new UserFriends()
{
UserId = (Guid)dt.Rows[i]["UserId"],
UserName = dt.Rows[i]["UserName"].ToString(),
FullName = dt.Rows[i]["FullName"].ToString(),
ImageUrl = dt.Rows[i]["ImageUrl"] != DBNull.Value ? dt.Rows[i]["ImageUrl"].ToString() : "nouserprofile.jpg",
JobTitle = dt.Rows[i]["JobTitle"] != DBNull.Value ? dt.Rows[i]["JobTitle"].ToString() : "---",
UserType = (int)dt.Rows[i]["IsFriend"]
};
lstUser.Add(uf);
}
returnValue.Success = true;
returnValue.ReturnObject = lstUser;
}
else
{
returnValue.Success = false;
returnValue.Result = "M057"; //"Herhangi bir kayıt bulunamadı!";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public static MsCrmResultObject GetContactInfo(Guid contactId, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"SELECT
C.ContactId
,C.FirstName
,C.LastName
,C.JobTitle
,C.new_functionname FunctionName
,C.AccountId
,C.AccountIdName
,C.EMailAddress1 EmailAddress
,C.MobilePhone
,C.Telephone1
,C.new_identitynumber AS IdentityNo
,C.GenderCode
,DATEADD(HH,3,C.BirthDate) AS BirthDate
,C.Description
,C.new_cityId AS CityId
,C.new_cityIdName AS CityIdName
,C.new_townId AS TownId
,C.new_townIdName AS TownIdName
,C.new_addressdetail AS AddressDetail
,C.new_markcontact AS MarkContact
FROM
Contact C (NoLock)
WHERE
C.ContactId = '{0}'
AND
C.StateCode = 0";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, contactId));
if (dt != null && dt.Rows.Count > 0)
{
Contact _contact = new Contact();
_contact.ContactId = (Guid)dt.Rows[0]["ContactId"];
_contact.FirstName = dt.Rows[0]["FirstName"] != DBNull.Value ? dt.Rows[0]["FirstName"].ToString() : string.Empty;
_contact.LastName = dt.Rows[0]["LastName"] != DBNull.Value ? dt.Rows[0]["LastName"].ToString() : string.Empty;
_contact.Title = dt.Rows[0]["JobTitle"] != DBNull.Value ? dt.Rows[0]["JobTitle"].ToString() : string.Empty;
_contact.FunctionName = dt.Rows[0]["FunctionName"] != DBNull.Value ? dt.Rows[0]["FunctionName"].ToString() : string.Empty;
_contact.EmailAddress = dt.Rows[0]["EmailAddress"] != DBNull.Value ? dt.Rows[0]["EmailAddress"].ToString() : string.Empty;
_contact.MobilePhone = dt.Rows[0]["MobilePhone"] != DBNull.Value ? dt.Rows[0]["MobilePhone"].ToString() : string.Empty;
_contact.WorkPhone = dt.Rows[0]["Telephone1"] != DBNull.Value ? dt.Rows[0]["Telephone1"].ToString() : string.Empty;
_contact.IdentityNumber = dt.Rows[0]["IdentityNo"] != DBNull.Value ? dt.Rows[0]["IdentityNo"].ToString() : string.Empty;
if (dt.Rows[0]["GenderCode"] != DBNull.Value) { _contact.Gender = (int)dt.Rows[0]["GenderCode"]; }
if (dt.Rows[0]["BirthDate"] != DBNull.Value) { _contact.BirthDate = (DateTime)dt.Rows[0]["BirthDate"]; }
_contact.Description = dt.Rows[0]["Description"] != DBNull.Value ? dt.Rows[0]["Description"].ToString() : string.Empty;
_contact.MarkContact = dt.Rows[0]["MarkContact"] != DBNull.Value ? (bool)dt.Rows[0]["MarkContact"] : false;
if (dt.Rows[0]["AccountId"] != DBNull.Value)
{
EntityReference er = new EntityReference();
er.LogicalName = "account";
er.Id = (Guid)dt.Rows[0]["AccountId"];
if (dt.Rows[0]["AccountIdName"] != DBNull.Value) { er.Name = dt.Rows[0]["AccountIdName"].ToString(); }
_contact.ParentAccount = er;
}
if (dt.Rows[0]["CityId"] != DBNull.Value)
{
EntityReference er = new EntityReference();
er.LogicalName = "new_city";
er.Id = (Guid)dt.Rows[0]["CityId"];
if (dt.Rows[0]["CityIdName"] != DBNull.Value) { er.Name = dt.Rows[0]["CityIdName"].ToString(); }
_contact.CityId = er;
}
if (dt.Rows[0]["TownId"] != DBNull.Value)
{
EntityReference er = new EntityReference();
er.LogicalName = "new_town";
er.Id = (Guid)dt.Rows[0]["TownId"];
if (dt.Rows[0]["TownIdName"] != DBNull.Value) { er.Name = dt.Rows[0]["TownIdName"].ToString(); }
_contact.TownId = er;
}
if (dt.Rows[0]["AccountId"] != DBNull.Value)
{
EntityReference er = new EntityReference();
er.LogicalName = "account";
er.Id = (Guid)dt.Rows[0]["AccountId"];
if (dt.Rows[0]["AccountIdName"] != DBNull.Value) { er.Name = dt.Rows[0]["AccountIdName"].ToString(); }
_contact.ParentAccount = er;
}
_contact.AddressDetail = dt.Rows[0]["AddressDetail"] != DBNull.Value ? dt.Rows[0]["AddressDetail"].ToString() : string.Empty;
returnValue.ReturnObject = _contact;
returnValue.Success = true;
}
else
{
returnValue.Success = false;
returnValue.Result = "M007"; //"No contact info found!";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public static string GetCityCode(Guid cityId, SqlDataAccess sda)
{
string returnValue = string.Empty;
#region | SQL QUERY |
string sqlQuery = @"SELECT c.new_citycode AS Code FROM new_city AS c (NOLOCK) WHERE c.new_cityId='{0}'";
#endregion
DataTable dt = sda.getDataTable(string.Format(sqlQuery, cityId));
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["Code"] != DBNull.Value)
{
returnValue = dt.Rows[0]["Code"].ToString();
}
}
return returnValue;
}
public static MsCrmResultObject SelectQuestion(Guid portalUserId, Guid portalId, Guid questionLevelId, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"SELECT TOP 1
q.new_questionId AS QUestionId
FROM
new_question AS q (NOLOCK)
WHERE
q.new_portalId='{0}'
AND
q.new_questionlevelId='{1}'
AND
q.statecode=0
AND
q.statuscode=1 --Active
AND
q.new_questionId NOT IN
(
SELECT
q.new_questionId
FROM
new_questionanswers AS a (NOLOCK)
WHERE
a.new_questionId=q.new_questionId
AND
a.new_userId='{2}'
AND
a.new_point IS NOT NULL AND a.new_point != 0
AND
a.statecode=0
)
ORDER BY NEWID()";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, portalId, questionLevelId, portalUserId));
if (dt != null && dt.Rows.Count > 0)
{
returnValue = GetQuestionInfo((Guid)dt.Rows[0]["QuestionId"], sda);
}
else
{
returnValue.Success = false;
returnValue.Result = "M029"; //"Soru seviyesine ait uygun soru bulunamadı.";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public static MsCrmResult HasUserQuestionLimit(Guid portalUserId, Guid portalId, SqlDataAccess sda)
{
MsCrmResult returnValue = new MsCrmResult();
try
{
#region | SQL QUERY |
string query = @"
DECLARE @now DATETIME
DECLARE @startDate DATETIME
DECLARE @endDate DATETIME
DECLARE @current INT
DECLARE @limit INT
DECLARE @hasLimit BIT
SET @now=GETUTCDATE()
SELECT
@limit=sl.new_frequency
,@startDate= CASE
WHEN
sl.new_scoreperiod=100000000 --DAILY
THEN
{2}.dbo.fn_BeginOfToday(@now)
ELSE
CASE
WHEN
sl.new_scoreperiod=100000001 --WEEKLY
THEN
{2}.dbo.fn_BeginOfThisWeek(@now)
ELSE
CASE
WHEN
sl.new_scoreperiod=100000002 --MONTHLY
THEN
{2}.dbo.fn_BeginOfThisMonth(@now)
ELSE
{2}.dbo.fn_BeginOfThisYear(@now)
END
END
END
,@endDate= CASE
WHEN
sl.new_scoreperiod=100000000 --DAILY
THEN
{2}.dbo.fn_EndOfToday(@now)
ELSE
CASE
WHEN
sl.new_scoreperiod=100000001 --WEEKLY
THEN
{2}.dbo.fn_EndOfThisWeek(@now)
ELSE
CASE
WHEN
sl.new_scoreperiod=100000003 --MONTHLY
THEN
{2}.dbo.fn_EndOfThisMonth(@now)
ELSE
{2}.dbo.fn_EndOfThisYear(@now)
END
END
END
FROM
new_scorelimit AS sl (NOLOCK)
WHERE
sl.new_scoretype=100000000 --InfoCube
SELECT
@current = COUNT(0)
FROM
new_questionanswers AS ans (NOLOCK)
WHERE
ans.new_portalId='{1}'
AND
ans.new_userId='{0}'
AND
ans.statecode=0
AND
ans.statuscode=1 --Active
AND
ans.CreatedOn BETWEEN @startDate AND @endDate
SELECT
@hasLimit= CASE
WHEN
@current < @limit OR @limit IS NULL
THEN
1
ELSE
0
END
SELECT @hasLimit";
#endregion
returnValue.Success = (bool)sda.ExecuteScalar(string.Format(query, portalUserId, portalId, Globals.DatabaseName));
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public static MsCrmResultObject GetUserCubeStatus(Guid portalUserId, Guid portalId, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"SELECT
*
FROM
(
SELECT
*
,DENSE_RANK() OVER (ORDER BY B.TotalPoint DESC) AS Ranking
FROM
(
SELECT
A.UserId
,ISNULL(SUM(A.Point),0) AS TotalPoint
FROM
(
SELECT DISTINCT
u.new_userId AS UserId
,a.new_point AS Point
,a.new_questionanswersId AS AnswerId
FROM
new_user AS u (NOLOCK)
LEFT JOIN
new_questionanswers AS a (NOLOCK)
ON
u.new_userId=a.new_userId
AND
a.statecode=0
JOIN
new_new_user_new_role AS urd (NOLOCK)
ON
u.new_userId=urd.new_userid
JOIN
new_role AS rd (NOLOCK)
ON
urd.new_roleid=rd.new_roleId
AND
rd.statecode=0
AND
rd.statuscode=1 --Active
AND
rd.new_portalId='{1}'
WHERE
u.statecode=0
AND
u.statuscode=1 --Active
) AS A
GROUP BY
A.UserId
) AS B
) AS C
WHERE
C.UserId='{0}'";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, portalUserId, portalId));
if (dt != null && dt.Rows.Count > 0)
{
UserCubeStatus _cubeStatus = new UserCubeStatus();
if (dt.Rows[0]["UserId"] != DBNull.Value)
{
EntityReference er = new EntityReference()
{
Id = (Guid)dt.Rows[0]["UserId"]
};
_cubeStatus.UserId = er;
}
_cubeStatus.Point = dt.Rows[0]["TotalPoint"] != DBNull.Value ? Convert.ToInt32(dt.Rows[0]["TotalPoint"]) : 0;
_cubeStatus.Rank = dt.Rows[0]["Ranking"] != DBNull.Value ? Convert.ToInt32(dt.Rows[0]["Ranking"]) : 0;
returnValue.Success = true;
returnValue.ReturnObject = _cubeStatus;
}
else
{
returnValue.Success = false;
returnValue.Result = "M032"; //"Kullanıcı soru cevaplarına ait bilgiler bulunamadı.";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public static MsCrmResultObject GetAnnouncementInfo(Guid announcementId, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"SELECT
A.new_announcementId Id
,A.new_name Name
,A.new_content Content
,A.new_imageurl ImageUrl
,CAST({2}.dbo.fn_UTCToTzSpecificLocalTime(A.CreatedOn, us.TimeZoneBias, us.TimeZoneDaylightBias,us.TimeZoneDaylightYear, us.TimeZoneDaylightMonth, us.TimeZoneDaylightDay, us.TimeZoneDaylightHour,us.TimeZoneDaylightMinute, us.TimeZoneDaylightSecond, 0, us.TimeZoneDaylightDayOfWeek,us.TimeZoneStandardBias, us.TimeZoneStandardYear, us.TimeZoneStandardMonth, us.TimeZoneStandardDay,us.TimeZoneStandardHour, us.TimeZoneStandardMinute, us.TimeZoneStandardSecond, 0,us.TimeZoneStandardDayOfWeek) as DATETIME) CreatedOn
FROM
new_announcement A (NoLock)
INNER JOIN
SystemUser SU (NoLock)
ON
SU.SystemUserId = '{1}'
INNER JOIN
dbo.UserSettingsBase US (NoLock)
ON
US.SystemUserId =SU.SystemUserId
WHERE
A.new_announcementId = '{0}'
ORDER BY
A.CreatedOn DESC";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, announcementId, Globals.AdminId, Globals.DatabaseName));
if (dt != null && dt.Rows.Count > 0)
{
Announcement _announcement = new Announcement();
_announcement.AnnouncementId = (Guid)dt.Rows[0]["Id"];
_announcement.Caption = dt.Rows[0]["Name"] != DBNull.Value ? dt.Rows[0]["Name"].ToString() : string.Empty;
_announcement.Description = dt.Rows[0]["Content"] != DBNull.Value ? dt.Rows[0]["Content"].ToString() : string.Empty;
_announcement.ImagePath = dt.Rows[0]["ImageUrl"] != DBNull.Value ? dt.Rows[0]["ImageUrl"].ToString() : "no_image_available.png";
if (dt.Rows[0]["CreatedOn"] != DBNull.Value)
{
_announcement.CreatedOnString = dt.Rows[0]["CreatedOn"] != DBNull.Value ? ((DateTime)dt.Rows[0]["CreatedOn"]).ToString("dd MMMM yyyy ddddd HH:mm", new CultureInfo("tr-TR", false)) : string.Empty;
_announcement.CreatedOn = (DateTime)dt.Rows[0]["CreatedOn"];
}
#region | GET ATTACHMENTS |
MsCrmResultObject attachmentResult = AttachmentFileHelper.GetAnnouncementAttachmentFiles(announcementId, sda);
if (attachmentResult.Success)
{
_announcement.AttachmentFileList = (List<AttachmentFile>)attachmentResult.ReturnObject;
}
#endregion
returnValue.Success = true;
returnValue.ReturnObject = _announcement;
}
else
{
returnValue.Result = "M026"; //"İlgili duyuruya ait bilgiye ulaşılamadı.";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public static MsCrmResultObject GetAnnouncementList(Guid portalId, Guid portalUserId, int start, int end, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"DECLARE @Date DATETIME = GETUTCDATE()
SELECT
*
FROM
(
SELECT
D.*
,COUNT(0) OVER() AS TotalRow
FROM
(
SELECT
B.*
,ROW_NUMBER() OVER(ORDER BY B.CreatedOn DESC) AS RowNumber
FROM
(
SELECT DISTINCT
A.new_announcementId Id
,A.new_name Name
,A.new_content Content
,A.new_imageurl ImageUrl
,CAST({1}.dbo.fn_UTCToTzSpecificLocalTime(A.CreatedOn, us.TimeZoneBias, us.TimeZoneDaylightBias,us.TimeZoneDaylightYear, us.TimeZoneDaylightMonth, us.TimeZoneDaylightDay, us.TimeZoneDaylightHour,us.TimeZoneDaylightMinute, us.TimeZoneDaylightSecond, 0, us.TimeZoneDaylightDayOfWeek,us.TimeZoneStandardBias, us.TimeZoneStandardYear, us.TimeZoneStandardMonth, us.TimeZoneStandardDay,us.TimeZoneStandardHour, us.TimeZoneStandardMinute, us.TimeZoneStandardSecond, 0,us.TimeZoneStandardDayOfWeek) as DATETIME) CreatedOn
FROM
new_announcement A (NoLock)
JOIN
new_new_user_new_role AS UR (NOLOCK)
ON
UR.new_userid='{2}'
JOIN
new_role AS RD (NOLOCK)
ON
RD.new_roleId=UR.new_roleid
AND
Rd.statecode=0
AND
RD.statuscode=1 --Active
JOIN
new_new_announcement_new_role AS ERDF (NOLOCK)
ON
ERDF.new_announcementid=A.new_announcementId
AND
ERDF.new_roleid=RD.new_roleId
INNER JOIN
dbo.UserSettingsBase US (NoLock)
ON
US.SystemUserId ='{0}'
WHERE
@Date BETWEEN A.new_startdate AND A.new_enddate
AND
A.new_portalId='{3}'
AND
A.StateCode = 0
AND
A.StatusCode=1 --Active
) AS B
) AS D
) AS C
WHERE
C.RowNumber BETWEEN {4} AND {5}
ORDER BY
C.RowNumber ASC";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, Globals.AdminId, Globals.DatabaseName, portalUserId, portalId.ToString(), start.ToString(), end.ToString()));
if (dt != null && dt.Rows.Count > 0)
{
List<Announcement> returnList = new List<Announcement>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Announcement _announcement = new Announcement();
_announcement.AnnouncementId = (Guid)dt.Rows[i]["Id"];
_announcement.Caption = dt.Rows[i]["Name"] != DBNull.Value ? dt.Rows[i]["Name"].ToString() : string.Empty;
_announcement.Description = dt.Rows[i]["Content"] != DBNull.Value ? dt.Rows[i]["Content"].ToString() : string.Empty;
_announcement.ImagePath = dt.Rows[i]["ImageUrl"] != DBNull.Value ? dt.Rows[i]["ImageUrl"].ToString() : string.Empty;
if (dt.Rows[i]["TotalRow"] != DBNull.Value)
{
returnValue.RecordCount = (int)dt.Rows[i]["TotalRow"];
}
if (dt.Rows[i]["CreatedOn"] != DBNull.Value)
{
_announcement.CreatedOn = (DateTime)dt.Rows[i]["CreatedOn"];
_announcement.CreatedOnString = dt.Rows[i]["CreatedOn"] != DBNull.Value ? ((DateTime)dt.Rows[i]["CreatedOn"]).ToString("dd MMMM yyyy ddddd HH:mm", new CultureInfo("tr-TR", false)) : string.Empty;
}
returnList.Add(_announcement);
}
returnValue.Success = true;
returnValue.ReturnObject = returnList;
}
else
{
returnValue.Success = true;
returnValue.Result = "M025"; //"Duyuru kaydı bulunamadı!";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public static void CreateLogBySql(string applicationName, string functionName, string detail, string createdBy, string businessUnit, EventType eventType)
{
try
{
SqlDataAccess sda = new SqlDataAccess();
sda.openConnection(Globals.ConnectionString);
string sqlQuery = @"DECLARE @EventLogID uniqueidentifier
SET @EventLogID=NEWID()
INSERT
INTO
new_eventlogBase
(new_eventlogId
,CreatedOn
,CreatedBy
,ModifiedOn
,ModifiedBy
,OwnerId
,OwningBusinessUnit
,statecode
,statuscode
)
VALUES
(
@EventLogID
,@CreatedOn
,@CreatedBy
,@CreatedOn
,@CreatedBy
,@CreatedBy
,@BusinessUnit
,0
,1
)
INSERT
INTO
new_eventlogExtensionBase
(
new_eventlogId
,new_name
,new_applicationname
,new_detail
,new_eventtype
,new_function
)
VALUES
(
@EventLogID
,@Title
,@ApplicationName
,@Detail
,@EventType
,@FunctionName
)";
string title = string.Format("{0} - {1} - {2}", applicationName, functionName, DateTime.Now.ToString("dd.MM.yyyy HH:mm"));
List <SqlParameter> li = new List <SqlParameter>();
li.Add(new SqlParameter("@CreatedOn", DateTime.UtcNow));
li.Add(new SqlParameter("@CreatedBy", new Guid(createdBy)));
li.Add(new SqlParameter("@CreatedBy", new Guid(businessUnit)));
li.Add(new SqlParameter("@Title", title));
li.Add(new SqlParameter("@ApplicationName", applicationName));
li.Add(new SqlParameter("@Detail", detail));
li.Add(new SqlParameter("@EventType", (int)eventType));
li.Add(new SqlParameter("@FunctionName", functionName));
sda.ExecuteNonQuery(sqlQuery, li.ToArray());
sda.closeConnection();
}
catch (Exception ex)
{
}
}