protected void gvSubFolder_RowUpdate(object sender, GridViewUpdateEventArgs e)
{
try
{
int index = e.RowIndex;
GridViewRow row = gvFilters.Rows[index];
Int64 Id = Int64.Parse(gvFilters.DataKeys[index].Value.ToString());
TextBox txtSubFilterName = (TextBox)row.Cells[0].FindControl("txtSubFilterName");
if (txtSubFilterName.Text.Trim() == "")
{
Master.MessageCenter.DisplayWarningMessage(GlobalStrings.GetText(@"ErrorSubFilterName"));
return;
}
Query q = new Query(SubFilter.TableSchema).Where(SubFilter.Columns.SubFilterName, txtSubFilterName.Text.Trim())
.AddWhere(SubFilter.Columns.FilterId, WhereComparision.EqualsTo, FilterId)
.AddWhere(SubFilter.Columns.SubFilterId, WhereComparision.NotEqualsTo, Id);
if (q.GetCount() > 0)
{
Master.MessageCenter.DisplayErrorMessage(FiltersStrings.GetText(@"MessageSubFiltersAlreadyExists"));
return;
}
SubFilter subFilter = SubFilter.FetchByID(Id);
subFilter.SubFilterName = txtSubFilterName.Text.Trim();
subFilter.Save();
gvFilters.EditIndex = -1;
LoadItems();
}
catch (Exception) { }
}
private void FillDdlFilter(DropDownList ddlFilter)
{
FilterCollection filterList = FilterCollection.FetchAll();
ddlFilter.Items.Add(new ListItem(GlobalStrings.GetText(@"NoneForDropDowns"), "0"));
foreach (var item in filterList)
{
ddlFilter.Items.Add(new ListItem(item.FilterName, item.FilterId.ToString()));
}
}
public override void Post(HttpRequest Request, HttpResponse Response, params string[] PathParams)
{
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetMaxAge(TimeSpan.Zero);
JObject inputData = null;
try
{
using (StreamReader reader = new StreamReader(Request.InputStream))
{
using (JsonTextReader jsonReader = new JsonTextReader(reader))
{
inputData = JObject.Load(jsonReader);
}
}
}
catch
{
RespondBadRequest(Response);
}
string name = inputData.Value <string>(@"name") ?? "";
string email = inputData.Value <string>(@"email") ?? "";
string phone = inputData.Value <string>(@"phone") ?? "";
string content = inputData.Value <string>(@"content") ?? "";
Response.ContentType = @"application/json";
using (StreamWriter streamWriter = new StreamWriter(Response.OutputStream))
{
using (JsonTextWriter jsonWriter = new JsonTextWriter(streamWriter))
{
try
{
string subject = GlobalStrings.GetText("ContactUsSubject", new CultureInfo("he-IL"));
string body = GlobalStrings.GetText("Email", new CultureInfo("he-IL")) + " : " + email + "<br>" +
GlobalStrings.GetText("Phone", new CultureInfo("he-IL")) + " : " + phone + "<br>" +
GlobalStrings.GetText("Content", new CultureInfo("he-IL")) + " : " + content + "<br>";
string AdminEmail = Settings.GetSetting(Settings.Keys.ADMIN_EMAIL);
string fromEmail = Settings.GetSetting(Settings.Keys.DEFAULT_EMAIL_FROM);
string replyToEmail = Settings.GetSetting(Settings.Keys.DEFAULT_EMAIL_REPLYTO);
string fromName = Settings.GetSetting(Settings.Keys.DEFAULT_EMAIL_FROM_NAME);
string replyToName = Settings.GetSetting(Settings.Keys.DEFAULT_EMAIL_REPLYTO_NAME);
System.Net.Mail.MailMessage message = EmailTemplateController.BuildMailMessage(
fromEmail, fromName, replyToEmail, replyToName,
AdminEmail, null, null, subject, body, null, null);
EmailTemplateController.Send(message, EmailLogController.EmailLogType.OnError, true);
}
catch (Exception) { }
jsonWriter.WriteStartObject();
jsonWriter.WriteEndObject();
}
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
if (RecoveryKey.Length == 0 || Email.Length == 0)
{
Page.Title = LoginPageStrings.GetText(@"ForgotPasswordPageTitle");
}
else
{
Page.Title = LoginPageStrings.GetText(@"ResetPasswordPageTitle");
}
Body.Attributes[@"class"] += @" " + GlobalStrings.GetText(@"direction");
}
protected void Page_PreRender(object sender, EventArgs e)
{
Page.Title = LoginPageStrings.GetText(@"PageTitle", new CultureInfo("he-IL"));
Body.Attributes[@"class"] += @" " + GlobalStrings.GetText(@"direction", new CultureInfo("he-IL"));
chkRememberMe.Text = string.Format(LoginPageStrings.GetText(@"RememberMe", new CultureInfo("he-IL")), AppConfig.GetInt32(@"Authentication.AuthCookieLifeInHours", 72) / 24).ToHtml();
btnLogin.Text = LoginPageStrings.GetHtml(@"Submit", new CultureInfo("he-IL"));
rfvEml.ErrorMessage = LoginPageStrings.GetHtml(@"EmailRequired", new CultureInfo("he-IL"));
revEml.ErrorMessage = LoginPageStrings.GetHtml(@"EmailRequired", new CultureInfo("he-IL"));
rfvPwd.ErrorMessage = LoginPageStrings.GetHtml(@"PasswordRequired", new CultureInfo("he-IL"));
}
protected void lbDelete_Click(object sender, CommandEventArgs e)
{
if (e.CommandName.Equals("doDelete"))
{
if (Permissions.UserHasAnyPermissionIn(SessionHelper.UserId(), "sys_edit_emails"))
{
Int64 EmailLogId = Convert.ToInt64(e.CommandArgument);
EmailLogController.DeleteLog(EmailLogId);
Master.MessageCenter.DisplaySuccessMessage(EmailTemplatesStrings.GetText("MessageLogDeleted"));
}
else
{
Master.MessageCenter.DisplayWarningMessage(GlobalStrings.GetText(@"NoPermissionsForAction"));
}
}
}
protected void ExportToExcel(int limit, int offset)
{
EmailLogCollection coll = EmailLogController.GetLogItems(EmailLog.Columns.DeliveryDate, dg.Sql.SortDirection.DESC, limit, offset);
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(new System.Data.DataColumn(EmailTemplatesStrings.GetText("LogNumber"), typeof(Int64)));
dt.Columns.Add(new System.Data.DataColumn(GlobalStrings.GetText("Date"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(GlobalStrings.GetText("Status"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(EmailTemplatesStrings.GetText("Subject"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(EmailTemplatesStrings.GetText("From"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(EmailTemplatesStrings.GetText("Recipient"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(EmailTemplatesStrings.GetText("CC"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(EmailTemplatesStrings.GetText("BCC"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(EmailTemplatesStrings.GetText("Priority"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(EmailTemplatesStrings.GetText("Content"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(EmailTemplatesStrings.GetText("Exception"), typeof(string)));
foreach (EmailLog item in coll)
{
System.Data.DataRow row = dt.NewRow();
row[0] = item.EmailLogId;
row[1] = item.DeliveryDate.ToString(@"dd/MM/yyyy HH:mm:ss");
row[2] = GetStatus(item.Status);
row[3] = item.Subject;
row[4] = item.FromEmail + (string.IsNullOrEmpty(item.FromName) ? string.Empty : @" - " + item.FromName);
row[5] = item.ToList;
row[6] = item.CcList;
row[7] = item.BccList;
row[8] = GetMailPriority(item.MailPriority);
row[9] = item.Body.Replace(@"<br />", "\r\n").StripHtml();
row[10] = item.Exception;
dt.Rows.Add(row);
}
SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, true, true);
Response.Clear();
Response.AddHeader(@"content-disposition", @"attachment;filename=EmailLogsExport_" + DateTime.UtcNow.ToString(@"yyyy_MM_dd_HH_mm_ss") + "." + ex.FileExtension);
Response.Charset = @"UTF-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = ex.FileContentType;
Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble());
Response.Write(ex.ToString());
Response.End();
}
protected void lbDelete_Click(object sender, CommandEventArgs e)
{
if (e.CommandName.Equals("doDelete"))
{
if (Permissions.UserHasAnyPermissionIn(SessionHelper.UserId(), "sys_edit_emails"))
{
Int64 EmailTemplateId = Convert.ToInt64(e.CommandArgument);
string Name = EmailTemplateController.GetItemName(EmailTemplateId) ?? @"";
EmailTemplateController.Delete(EmailTemplateId);
Master.MessageCenter.DisplaySuccessMessage(string.Format(EmailTemplatesStrings.GetText("MessageTemplateDeleted"), Name.ToHtml()), true);
LoadItems();
}
else
{
Master.MessageCenter.DisplayWarningMessage(GlobalStrings.GetText(@"NoPermissionsForAction"));
}
}
}
protected void Page_Init(object sender, EventArgs e)
{
Pair[] items = HttpContext.Current.Items[HTTPCONTEXT_ITEMS_KEY] as Pair[];
if (items == null)
{
Query qry = new Query(EmailTemplate.TableSchema)
.Select(EmailTemplate.Columns.EmailTemplateId)
.AddSelect(EmailTemplate.Columns.Name);
using (DataReaderBase reader = qry.ExecuteReader())
{
List <Pair> list = new List <Pair>();
while (reader.Read())
{
list.Add(new Pair(reader.GetInt32(0), reader.GetStringOrEmpty(1)));
}
HttpContext.Current.Items[HTTPCONTEXT_ITEMS_KEY] = items = list.ToArray();
}
}
string[] AvailableLanguages = AppConfig.GetString(@"AvailableLanguages", @"").Split(','), langParts;
foreach (string lang in AvailableLanguages)
{
langParts = lang.Split(':');
HtmlTableRow row = new HtmlTableRow();
HtmlTableCell cell1 = new HtmlTableCell();
HtmlTableCell cell2 = new HtmlTableCell();
DropDownList ddl = new DropDownList();
cell1.InnerText = langParts[1] + @" (" + langParts[0] + @")";
ddl.Items.Add(new ListItem(GlobalStrings.GetText(@"NoneForDropDowns"), "0"));
foreach (Pair p in items)
{
ddl.Items.Add(new ListItem(p.Second.ToString(), p.First.ToString()));
}
cell2.Controls.Add(ddl);
row.Cells.Add(cell1);
row.Cells.Add(cell2);
tblOptions.Rows.Add(row);
mapDdls[langParts[0]] = ddl;
}
}
protected void btnImport_Click(object sender, EventArgs e)
{
if (CsvDataTable != null)
{
int count = 0;
try
{
foreach (DataRow row in CsvDataTable.Rows)
{
if (row["Comments"].ToString() == "")
{
Area area = Area.FetchByName(row["AreaName"].ToString());
if (area == null)
{
area = new Area();
area.AreaName = row["AreaName"].ToString();
area.Save();
}
City city = new City();
city.CityName = row["CityName"].ToString();
city.AreaId = area.AreaId;
city.Save();
count++;
}
}
lblImportResult.Text = GlobalStrings.GetText(@"MessageImportSuccess");
}
catch
{
lblImportResult.Text = GlobalStrings.GetText(@"MessageImportFailedUnknown");
}
phImportResult.Visible = true;
lblTotalImported.Text = count.ToString();
btnImport.Enabled = false;
phErrors.Visible = false;
phProductsList.Visible = false;
}
}
protected void gvSubFolder_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (!e.CommandName.Equals("AddNew"))
{
return;
}
GridViewRow row = gvFilters.FooterRow;
int index = gvFilters.EditIndex;
TextBox txtSubFilterNameNew = (TextBox)row.Cells[0].FindControl("txtSubFilterNameNew");
if (txtSubFilterNameNew.Text.Trim() == "")
{
Master.MessageCenter.DisplayErrorMessage(GlobalStrings.GetText(@"ErrorSubFilterName"));
return;
}
Query q = new Query(SubFilter.TableSchema).Where(SubFilter.Columns.SubFilterName, txtSubFilterNameNew.Text.Trim())
.AddWhere(SubFilter.Columns.FilterId, WhereComparision.EqualsTo, FilterId);
if (q.GetCount() > 0)
{
Master.MessageCenter.DisplayErrorMessage(FiltersStrings.GetText(@"MessageSubFiltersAlreadyExists"));
return;
}
SubFilter subFilter = new SubFilter();
subFilter.FilterId = FilterId;
subFilter.SubFilterName = txtSubFilterNameNew.Text.Trim();
subFilter.Save();
gvFilters.EditIndex = -1;
// refresh the grid view data
LoadItems();
}
catch (Exception) { }
}
private void HandleAll(HttpRequest Request, HttpResponse Response, params string[] PathParams)
{
if (!Request.IsLocal)
{
Http.Respond404(true);
}
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetMaxAge(TimeSpan.Zero);
if (PathParams[0] == @"rematch")
{
using (StreamWriter streamWriter = new StreamWriter(Response.OutputStream))
{
using (JsonTextWriter jsonWriter = new JsonTextWriter(streamWriter))
{
jsonWriter.WriteStartObject();
try
{
jsonWriter.WritePropertyName(@"success");
jsonWriter.WriteValue(true);
}
catch (System.Exception ex)
{
jsonWriter.WritePropertyName(@"error");
jsonWriter.WriteValue(@"unknown");
jsonWriter.WritePropertyName(@"description");
jsonWriter.WriteValue(ex.ToString());
}
jsonWriter.WriteEndObject();
}
}
}
else if (PathParams[0] == @"clean_tokens")
{
using (StreamWriter streamWriter = new StreamWriter(Response.OutputStream))
{
using (JsonTextWriter jsonWriter = new JsonTextWriter(streamWriter))
{
jsonWriter.WriteStartObject();
try
{
AuthTokens.DeleteAllExpired();
jsonWriter.WritePropertyName(@"success");
jsonWriter.WriteValue(true);
}
catch (System.Exception ex)
{
jsonWriter.WritePropertyName(@"error");
jsonWriter.WriteValue(@"unknown");
jsonWriter.WritePropertyName(@"description");
jsonWriter.WriteValue(ex.ToString());
}
jsonWriter.WriteEndObject();
}
}
}
else if (PathParams[0] == @"offer")
{
//using (StreamWriter streamWriter = new StreamWriter(Response.OutputStream))
//{
// using (JsonTextWriter jsonWriter = new JsonTextWriter(streamWriter))
// {
// jsonWriter.WriteStartObject();
// try
// {
// Query qry = new Query(Bid.TableSchema);
// qry.Where(Bid.Columns.IsSendOffer, WhereComparision.EqualsTo, false);
// qry.AddWhere(Bid.Columns.EndDate, WhereComparision.LessThan, DateTime.UtcNow);
// BidCollection bidCollection = BidCollection.FetchByQuery(qry);
// Query.New<Bid>().Where(Bid.Columns.IsSendOffer, WhereComparision.EqualsTo, false)
// .AddWhere(Bid.Columns.EndDate, WhereComparision.LessThan, DateTime.UtcNow)
// .Update(Bid.Columns.IsSendOffer, true)
// .Execute();
// foreach (Bid item in bidCollection)
// {
// Query q = new Query(Offer.TableSchema);
// q.Where(Offer.Columns.BidId, WhereComparision.EqualsTo, item.BidId);
// OfferCollection offerCollection = OfferCollection.FetchByQuery(q);
// if (offerCollection != null && offerCollection.Count > 0)
// {
// if (item.AppUserId != null && item.AppUserId != 0)
// {
// Notification.SendNotificationAppUserOffers(string.Format(Snoopi.web.Localization.PushStrings.GetText("PushOfferText"), offerCollection.Count), (Int64)item.AppUserId, item.BidId);
// }
// else if (item.TempAppUserId != null && item.TempAppUserId != 0)
// {
// Notification.SendNotificationTempUserOffers(string.Format(Snoopi.web.Localization.PushStrings.GetText("PushOfferText"), offerCollection.Count), (Int64)item.TempAppUserId, item.BidId);
// }
// }
// else
// {
// if (item.AppUserId != null && item.AppUserId != 0)
// {
// Notification.SendNotificationAppUserOffers(Snoopi.web.Localization.PushStrings.GetText("NoPushOfferText"), (Int64)item.AppUserId, item.BidId);
// AppUserUI user = AppUserUI.GetAppUserUI((Int64)item.AppUserId);
// List<BidProductUI> products = BidController.GetProductsByBid(item.BidId);
// Bid b = Bid.FetchByID(item.BidId);
// string subject = GlobalStrings.GetText("MailToAdmin", new CultureInfo("he-IL"));
// string body = GlobalStrings.GetText("SubjectMailToAdminOffers",new CultureInfo("he-IL"));
// EmailMessagingService.SendMailNoOffersToAdmin(user, b.StartDate, products, subject, body);
// }
// else if (item.TempAppUserId != null && item.TempAppUserId != 0)
// {
// Notification.SendNotificationTempUserOffers(Snoopi.web.Localization.PushStrings.GetText("NoPushOfferText"), (Int64)item.TempAppUserId, item.BidId);
// }
// }
// item.IsSendOffer = true;
// item.Save();
// }
// jsonWriter.WritePropertyName(@"success");
// jsonWriter.WriteValue(true);
// }
// catch (System.Exception ex)
// {
// //RespondError(Response, HttpStatusCode.BadRequest, ex.ToString());
// jsonWriter.WritePropertyName(@"error");
// jsonWriter.WriteValue(@"unknown");
// jsonWriter.WritePropertyName(@"description");
// jsonWriter.WriteValue(ex.ToString());
// }
// jsonWriter.WriteEndObject();
// }
//}
}
else if (PathParams[0] == @"service_offer")
{
using (StreamWriter streamWriter = new StreamWriter(Response.OutputStream))
{
using (JsonTextWriter jsonWriter = new JsonTextWriter(streamWriter))
{
jsonWriter.WriteStartObject();
try
{
Query qry = new Query(BidService.TableSchema);
qry.Where(BidService.Columns.IsSendOffer, WhereComparision.EqualsTo, false);
qry.AddWhere(BidService.Columns.EndDate, WhereComparision.LessThan, DateTime.UtcNow);
BidServiceCollection bidCollection = BidServiceCollection.FetchByQuery(qry);
jsonWriter.WritePropertyName(@"qry");
jsonWriter.WriteValue(qry.ToString());
Query.New <BidService>().Where(BidService.Columns.IsSendOffer, WhereComparision.EqualsTo, false)
.AddWhere(BidService.Columns.EndDate, WhereComparision.LessThan, DateTime.UtcNow)
.Update(BidService.Columns.IsSendOffer, true)
.Execute();
foreach (BidService item in bidCollection)
{
Query q = new Query(OfferService.TableSchema);
q.Where(OfferService.Columns.BidId, WhereComparision.EqualsTo, item.BidId);
OfferServiceCollection offerCollection = OfferServiceCollection.FetchByQuery(q);
if (offerCollection != null && offerCollection.Count > 0)
{
if (item.AppUserId != null && item.AppUserId != 0)
{
Notification.SendNotificationAppUserOffers(string.Format(Snoopi.web.Localization.PushStrings.GetText("PushOfferText"), offerCollection.Count), (Int64)item.AppUserId, item.BidId, true);
}
else if (item.TempAppUserId != null && item.TempAppUserId != 0)
{
Notification.SendNotificationTempUserOffers(string.Format(Snoopi.web.Localization.PushStrings.GetText("PushOfferText"), offerCollection.Count), (Int64)item.TempAppUserId, item.BidId, true);
}
}
else
{
if (item.AppUserId != null && item.AppUserId != 0)
{
Notification.SendNotificationAppUserOffers(Snoopi.web.Localization.PushStrings.GetText("NoPushOfferText"), (Int64)item.AppUserId, item.BidId, true);
AppUserUI user = AppUserUI.GetAppUserUI((Int64)item.AppUserId);
List <BidProductUI> products = BidController.GetProductsByBid(item.BidId);
Bid b = Bid.FetchByID(item.BidId);
string subject = GlobalStrings.GetText("MailToAdmin");
string body = GlobalStrings.GetText("SubjectMailToAdminOffers");
EmailMessagingService.SendMailNoOffersToAdmin(user, b.StartDate, products, subject, body);
}
else if (item.TempAppUserId != null && item.TempAppUserId != 0)
{
Notification.SendNotificationTempUserOffers(Snoopi.web.Localization.PushStrings.GetText("NoPushOfferText"), (Int64)item.TempAppUserId, item.BidId, true);
}
}
item.IsSendOffer = true;
item.Save();
}
jsonWriter.WritePropertyName(@"success");
jsonWriter.WriteValue(true);
}
catch (System.Exception ex)
{
//RespondError(Response, HttpStatusCode.BadRequest, ex.ToString());
jsonWriter.WritePropertyName(@"error");
jsonWriter.WriteValue(@"unknown");
jsonWriter.WritePropertyName(@"description");
jsonWriter.WriteValue(ex.ToString());
}
jsonWriter.WriteEndObject();
}
}
}
else if (PathParams[0] == @"order_received")
{
using (StreamWriter streamWriter = new StreamWriter(Response.OutputStream))
{
using (JsonTextWriter jsonWriter = new JsonTextWriter(streamWriter))
{
jsonWriter.WriteStartObject();
try
{
Query qry = new Query(Order.TableSchema);
qry.Where(Order.Columns.IsSendRecived, WhereComparision.EqualsTo, false);
qry.AddWhere(Order.Columns.ReceivedDate, WhereComparision.EqualsTo, null);
qry.AddWhere(Order.Columns.UserPaySupplierStatus, WhereComparision.EqualsTo, UserPaymentStatus.Payed);
qry.AddWhere(Order.Columns.SuppliedDate, WhereComparision.LessThanOrEqual, DateTime.UtcNow.AddHours(-24));
OrderCollection orderCollection = OrderCollection.FetchByQuery(qry);
//Query.New<Order>().Where(Order.Columns.IsSendRecived, WhereComparision.EqualsTo, false)
// .AddWhere(Order.Columns.ReceivedDate, WhereComparision.EqualsTo, null)
// .AddWhere(Order.Columns.CreateDate, WhereComparision.LessThanOrEqual, DateTime.UtcNow.AddHours(-24))
// .Update(Order.Columns.IsSendRecived, true)
// .Execute();
foreach (Order item in orderCollection)
{
Notification.SendNotificationAppUserReceviedOrder(Snoopi.web.Localization.PushStrings.GetText("ReceivedOrder"), (Int64)item.AppUserId, item.OrderId);
item.IsSendRecived = true;
item.Save();
}
jsonWriter.WritePropertyName(@"success");
jsonWriter.WriteValue(true);
}
catch (System.Exception ex)
{
//RespondError(Response, HttpStatusCode.BadRequest, ex.ToString());
jsonWriter.WritePropertyName(@"error");
jsonWriter.WriteValue(@"unknown");
jsonWriter.WritePropertyName(@"description");
jsonWriter.WriteValue(ex.ToString());
}
jsonWriter.WriteEndObject();
}
}
}
else if (PathParams[0] == @"auto_push")
{
using (StreamWriter streamWriter = new StreamWriter(Response.OutputStream))
{
using (JsonTextWriter jsonWriter = new JsonTextWriter(streamWriter))
{
jsonWriter.WriteStartObject();
try
{
var filters = NotificationGroups.GetAutoFilters();
foreach (var item in filters)
{
if (item.LastRun == null || item.LastRun.Value.AddDays(1) < DateTime.Now)
{
var users = NotificationGroups.GetUsersOfAutoFilter(item);
try
{
Task.Run(() => Snoopi.core.FcmService.SendTemplateToMany(item.Name, item.MessageTemplate, users)).Wait();
}
catch (Exception ex)
{
using (System.IO.StreamWriter sw = System.IO.File.AppendText(AppDomain.CurrentDomain.BaseDirectory + @"\Output\push-log.txt"))
{
sw.WriteLine(@" ------------" + DateTime.Now + "--------------------" + '\n' + "Exception " + ex.Message + " CallStack : " + ex.StackTrace);
}
}
item.LastRun = DateTime.Now;
item.Save();
}
}
jsonWriter.WritePropertyName(@"success");
jsonWriter.WriteValue(true);
}
catch (System.Exception ex)
{
//RespondError(Response, HttpStatusCode.BadRequest, ex.ToString());
jsonWriter.WritePropertyName(@"error");
jsonWriter.WriteValue(@"unknown");
jsonWriter.WritePropertyName(@"description");
jsonWriter.WriteValue(ex.ToString());
}
jsonWriter.WriteEndObject();
}
}
}
else if (PathParams[0] == @"rate_supplier")
{
using (StreamWriter streamWriter = new StreamWriter(Response.OutputStream))
{
using (JsonTextWriter jsonWriter = new JsonTextWriter(streamWriter))
{
jsonWriter.WriteStartObject();
try
{
Query qry = new Query(Order.TableSchema);
qry.Where(Order.Columns.IsSendRateSupplier, WhereComparision.EqualsTo, false);
qry.AddWhere(Order.Columns.SuppliedDate, WhereComparision.LessThanOrEqual, DateTime.UtcNow.AddHours(-Settings.GetSettingInt32(Settings.Keys.RATE_SUPPLIER_AFTER_ORDER_HOUR, 24)));
OrderCollection orderCollection = OrderCollection.FetchByQuery(qry);
Query.New <Order>().Where(Order.Columns.IsSendRateSupplier, WhereComparision.EqualsTo, false)
.AddWhere(Order.Columns.SuppliedDate, WhereComparision.LessThanOrEqual, DateTime.UtcNow.AddHours(-Settings.GetSettingInt32(Settings.Keys.RATE_SUPPLIER_AFTER_ORDER_HOUR, 24)))
.Update(Order.Columns.IsSendRateSupplier, true)
.Execute();
foreach (Order item in orderCollection)
{
var bid = Bid.FetchByID(item.BidId);
AppSupplier supplier = AppSupplier.FetchByID(item.SupplierId);
Notification.SendNotificationAppUserRateSupplier(Snoopi.web.Localization.PushStrings.GetText("RateSupplier"), item.AppUserId, item.SupplierId.Value, supplier.BusinessName, item.BidId);
item.IsSendRateSupplier = true;
item.Save();
}
jsonWriter.WritePropertyName(@"success");
jsonWriter.WriteValue(true);
}
catch (System.Exception ex)
{
//RespondError(Response, HttpStatusCode.BadRequest, ex.ToString());
jsonWriter.WritePropertyName(@"error");
jsonWriter.WriteValue(@"unknown");
jsonWriter.WritePropertyName(@"description");
jsonWriter.WriteValue(ex.ToString());
}
jsonWriter.WriteEndObject();
}
}
}
else if (PathParams[0] == @"test_rate_supplier")
{
Notification.SendNotificationAppUserRateSupplier(Snoopi.web.Localization.PushStrings.GetText("RateSupplier"), 18283, 387, "PetBool", 2345);
}
else
{
using (StreamWriter streamWriter = new StreamWriter(Response.OutputStream))
{
using (JsonTextWriter jsonWriter = new JsonTextWriter(streamWriter))
{
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName(@"error");
jsonWriter.WriteValue(@"unknown");
jsonWriter.WriteEndObject();
}
}
}
}
private void ReadCSVFile(string filePath)
{
using (FileStream fs = new FileStream(filePath, FileMode.Open))
{
using (CsvReader csv = new CsvReader(fs))
{
string[] _values = null;
CsvDataTable = new DataTable();
CsvDataTable.Columns.Add(new DataColumn("Line", typeof(int)));
CsvDataTable.Columns.Add(new DataColumn("AreaName", typeof(string)));
CsvDataTable.Columns.Add(new DataColumn("CityName", typeof(string)));
CsvDataTable.Columns.Add(new DataColumn("Comments", typeof(string)));
bool bErrors = false;
int line = -1;
int numToImport = 0;
_values = csv.ReadRow();
while (_values != null)
{
if (++line == 0)
{
_values = csv.ReadRow();
continue;
}
DataRow DR = CsvDataTable.NewRow();
string comments = "";
try
{
DR["Line"] = line;
DR["AreaName"] = _values[2] == "" ? "" : _values[2].Trim();
DR["CityName"] = _values[1] == "" ? "" : _values[1].Trim();
if (DR["AreaName"] == null || DR["AreaName"].ToString() == "" || DR["CityName"] == null || DR["CityName"].ToString() == "")
{
if (comments != "")
{
comments += "<br />";
}
comments += FiltersStrings.GetText(@"ReqCityAndAreaName");
}
else
{
Area f = Area.FetchByName(DR["AreaName"].ToString());
if (f != null)
{
Query q = new Query(City.TableSchema);
q.Where(City.Columns.CityName, DR["CityName"].ToString()).AddWhere(City.Columns.AreaId, f.AreaId);
if (q.GetCount() > 0)
{
if (comments != "")
{
comments += "<br />";
}
comments += GlobalStrings.GetText(@"AlreadyExistsCity");
}
}
}
}
catch (Exception e) { }
if (comments != "")
{
bErrors = true;
comments += "<br />" + GlobalStrings.GetText(@"MessageWillNotImported");
}
else
{
numToImport++;
}
DR["Comments"] = comments;
CsvDataTable.Rows.Add(DR);
_values = csv.ReadRow();
}
if (bErrors)
{
lblErrors.Text = GlobalStrings.GetText(@"ImportErrorsLabel");
}
else
{
lblErrors.Text = GlobalStrings.GetText(@"ImportNoErrorsLabel");;
}
dgCity.DataSource = CsvDataTable;
dgCity.DataBind();
lblTotal.Text = CsvDataTable.Rows.Count.ToString();
lblTotalToImport.Text = numToImport.ToString();
btnImport.Enabled = numToImport == 0 ? false : true;
}
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
Master.PageTitleHtml = GlobalStrings.GetText(@"ImportCityArea");
Master.ActiveMenu = "ImportCity";
}
protected void Page_Load(object sender, EventArgs e)
{
Master.PageTitle = GlobalStrings.GetText("Error404Line1");
Master.MessageCenter.DisplayInformationMessage(GlobalStrings.GetText("Error404Line2"));
}
protected void Page_Load(object sender, EventArgs e)
{
Master.PageTitle = GlobalStrings.GetText(@"DefaultPageTitle");
ltDescription.Text = GlobalStrings.GetText(@"DefaultPageBody");
}
