protected void Page_PreRender(object sender, EventArgs e)
{
if (filterSearch != null)
{
filters.Visible = false;
if (filterSearch == "Win")
{
Master.PageTitle = SuppliersStrings.GetText(@"SupliersWithWin");
}
if (filterSearch == "NoWin")
{
Master.PageTitle = SuppliersStrings.GetText(@"SupliersWithNotWin");
}
if (filterSearch == "ActiveBids")
{
Master.PageTitle = SuppliersStrings.GetText(@"SupliersWithActivesBids");
}
}
else
{
filters.Visible = true;
Master.PageTitle = SuppliersStrings.GetText(@"SuppliersReportPageTitle");
}
Master.ActiveMenu = "SuppliersReport";
Master.AddClientScriptInclude(@"dgDateManager.js");
}
protected void LoadItems()
{
if (!HasEditPermission)
{
dgSuppliers.Columns[dgSuppliers.Columns.Count - 1].Visible = false;
}
string searchName = "%" + txtSearchName.Text.Trim() + "%";
string searchPhone = "%" + txtSearchPhone.Text.Trim() + "%";
dgSuppliers.VirtualItemCount = SupplierController.GetAllSuppliersUI(true, searchName, searchPhone).Count;
if (dgSuppliers.VirtualItemCount == 0)
{
phHasItems.Visible = false;
phHasNoItems.Visible = true;
lblNoItems.Text = SuppliersStrings.GetText(@"MessageNoSuppliersFound");
}
else
{
phHasItems.Visible = true;
phHasNoItems.Visible = false;
if (dgSuppliers.PageSize * dgSuppliers.CurrentPageIndex > dgSuppliers.VirtualItemCount)
{
dgSuppliers.CurrentPageIndex = 0;
hfCurrentPageIndex_dgSuppliers.Value = dgSuppliers.CurrentPageIndex.ToString();
}
List <SupplierUI> items = SupplierController.GetAllSuppliersUI(true, searchName, searchPhone, dgSuppliers.PageSize, dgSuppliers.CurrentPageIndex);
BindList(items);
}
}
protected void LoadItems()
{
if (!HasEditPermission)
{
dgSuppliers.Columns[dgSuppliers.Columns.Count - 1].Visible = false;
}
string searchName = txtSearchName.Text.Trim();
string searchPhone = txtSearchPhone.Text.Trim();
string searchId = txtSearchSupplierId.Text.Trim();
string searchCity = txtSearchCity.Text.Trim();
DateTime from, to = new DateTime();
DateTime.TryParse(datepickerFrom.Text.ToString(), out from);
DateTime.TryParse(datepickerTo.Text.ToString(), out to);
dgSuppliers.VirtualItemCount = ServiceController.GetServiceSuppliersAndNumEvents(searchName, searchPhone, searchId, searchCity, from, to, true).Count;
if (dgSuppliers.VirtualItemCount == 0)
{
phHasItems.Visible = false;
phHasNoItems.Visible = true;
lblNoItems.Text = SuppliersStrings.GetText(@"MessageNoSuppliersFound");
}
else
{
phHasItems.Visible = true;
phHasNoItems.Visible = false;
if (dgSuppliers.PageSize * dgSuppliers.CurrentPageIndex > dgSuppliers.VirtualItemCount)
{
dgSuppliers.CurrentPageIndex = 0;
hfCurrentPageIndex_dgSuppliers.Value = dgSuppliers.CurrentPageIndex.ToString();
}
List <SupplierServiceUI> items = ServiceController.GetServiceSuppliersAndNumEvents(searchName, searchPhone, searchId, searchCity, from, to, true, dgSuppliers.PageSize, dgSuppliers.CurrentPageIndex);
BindList(items);
}
}
protected void Page_Init(object sender, EventArgs e)
{
//HasEditPermission = Permissions.PermissionsForUser(SessionHelper.UserId()).Contains(Permissions.PermissionKeys.sys_edit_users);
Master.AddButtonNew(SuppliersStrings.GetText(@"NewSupplierButton"), @"EditSupplier.aspx?New=yes", new string[] { Permissions.PermissionKeys.sys_perm });
dgSuppliers.PageIndexChanged += dgSuppliers_PageIndexChanging;
}
protected void Page_PreRender(object sender, EventArgs e)
{
Master.PageTitle = SuppliersStrings.GetText(IsNewMode ? @"NewSupplierPageTitle" : @"EditSupplierPageTitle");
Master.ActiveMenu = IsNewMode ? "NewSupplier" : "Suppliers";
Master.AddClientScriptInclude(@"dgDatePicker.js");
rfvPasswordRequired.Visible = rfvPasswordRequired.Enabled = IsNewMode;
rfvConfirmPasswordRequired.Visible = rfvConfirmPasswordRequired.Enabled = IsNewMode;
}
protected void btnSave_Click(object sender, EventArgs e)
{
string datepickerFromDate = txtFromDate.Text;
DateTime dtFromDate = DateTime.Now;
DateTime.TryParse(datepickerFromDate, out dtFromDate);
string datepickerToDate = txtToDate.Text;
DateTime dtToDate = DateTime.Now;
DateTime.TryParse(datepickerToDate, out dtToDate);
int areaId = int.Parse(ddlAreas.SelectedValue);
int serviceId = int.Parse(ddlServices.SelectedValue);
if (dtFromDate > dtToDate || string.IsNullOrEmpty(ddlPromtedSuppliers.SelectedValue) || ddlPromtedSuppliers.SelectedValue == "0")
{
return;
}
int supplierId = int.Parse(ddlPromtedSuppliers.SelectedValue);
int itemId = Id;
SupplierPromotedArea spa = new SupplierPromotedArea()
{
IsNewRecord = true,
PromotedAreaId = areaId,
SupplierId = supplierId,
StartTime = dtFromDate,
EndTime = dtToDate,
Id = itemId,
ServiceId = serviceId,
};
if (itemId == 0)// insert
{
spa.Insert();
}
else //update
{
spa.Update();
}
if (IsNewMode)
{
string successMessage = ResourceManagerAccessor.GetText("PromotedArea", @"MessageSupplierCreated");
string url = @"EditPromotedSuppliers.aspx?Id=" + spa.Id;
url += @"&message-success=" + Server.UrlEncode(successMessage);
Response.Redirect(url, true);
}
else
{
string successMessage = SuppliersStrings.GetText(@"MessageSupplierSaved");
Master.MessageCenter.DisplaySuccessMessage(successMessage);
LoadView();
}
}
protected void btnExportForCRM_Click(object sender, EventArgs e)
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SupplierId"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"BusinessName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SupplierServices"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"Address"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"CityName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Phone"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactPhone"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Email"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SupplierType"), typeof(string)));
List <SupplierUI> suppliers = new List <SupplierUI>();
string searchName = "%" + txtSearchName.Text.Trim() + "%";
string searchPhone = "%" + txtSearchPhone.Text.Trim() + "%";
suppliers = SupplierController.GetAllSuppliersUI(true, searchName, searchPhone);
foreach (SupplierUI supplier in suppliers)
{
int i = 0;
System.Data.DataRow row = dt.NewRow();
row[i++] = supplier.SupplierId;
row[i++] = supplier.BusinessName;
row[i++] = getSupplierServices(supplier);
row[i++] = supplier.Street + " " + supplier.HouseNum;
row[i++] = supplier.CityName;
row[i++] = "=\"" + supplier.Phone + "\"";
row[i++] = "=\"" + supplier.ContactPhone + "\"";
row[i++] = supplier.ContactName;
row[i++] = supplier.Email;
row[i++] = supplier.IsProduct ? SuppliersStrings.GetText(@"IsProduct") : SuppliersStrings.GetText(@"IsService");
dt.Rows.Add(row);
}
System.Data.DataRow sumRow = dt.NewRow();
sumRow[0] = SuppliersStrings.GetText(@"SumSumPerMonth") + " " + suppliers.Sum(o => o.SumPerMonth);
dt.Rows.Add(sumRow);
SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true);
Response.Clear();
Response.AddHeader(@"content-disposition", @"attachment;filename=SuppliersExportForCRM_" + 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 btnExport_Click(object sender, EventArgs e)
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SupplierId"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"BusinessName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Phone"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactPhone"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"CityName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SupplierEventStrings.GetText(@"ClickNum"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SupplierEventStrings.GetText(@"ClickToCallNum"), typeof(string)));
List <SupplierServiceUI> suppliers = new List <SupplierServiceUI>();
string searchName = txtSearchName.Text.Trim();
string searchPhone = txtSearchPhone.Text.Trim();
string searchId = txtSearchSupplierId.Text.Trim();
string searchCity = txtSearchCity.Text.Trim();
DateTime from, to = new DateTime();
DateTime.TryParse(datepickerFrom.Text.ToString(), out from);
DateTime.TryParse(datepickerTo.Text.ToString(), out to);
suppliers = ServiceController.GetServiceSuppliersAndNumEvents(searchName, searchPhone, searchId, searchCity, from, to, true);
foreach (SupplierServiceUI supplier in suppliers)
{
System.Data.DataRow row = dt.NewRow();
row[0] = supplier.SupplierId;
row[1] = supplier.BusinessName;
row[2] = "\"" + supplier.Phone + "\"";
row[3] = supplier.ContactName;
row[4] = "\"" + supplier.ContactPhone + "\"";
row[5] = supplier.CityName;
row[6] = supplier.ClickNum;
row[7] = supplier.ClickToCallNum;
dt.Rows.Add(row);
}
//System.Data.DataRow sumRow = dt.NewRow();
//sumRow[0] = SuppliersStrings.GetText(@"SumSumPerMonth") + " " + suppliers.Sum(o => o.SumPerMonth);
//dt.Rows.Add(sumRow);
SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true);
Response.Clear();
Response.AddHeader(@"content-disposition", @"attachment;filename=ServiceSuppliersReport_" + 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 Page_Init(object sender, EventArgs e)
{
//HasEditPermission = Permissions.PermissionsForUser(SessionHelper.UserId()).Contains(Permissions.PermissionKeys.sys_edit_users);
if (Request.QueryString["Filter"] != null)
{
filterSearch = Request.QueryString["Filter"];
}
filters.Visible = true;
Master.AddButtonNew(SuppliersStrings.GetText(@"NewSupplierButton"), @"EditSupplier.aspx?New=yes", new string[] { Permissions.PermissionKeys.sys_perm });
dgSuppliers.PageIndexChanged += dgSuppliers_PageIndexChanging;
}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Query.New<AppSupplier>().Where(AppSupplier.Columns.SupplierId, SupplierId)
.Update(AppSupplier.Columns.IsDeleted, true)
.Update(AppSupplier.Columns.UniqueIdString, null)
.Execute();
Master.MessageCenter.DisplaySuccessMessage(SuppliersStrings.GetText(@"MessageSupplierDeleted"));
lblDeleteConfirm.Visible = false;
chkDeleteConfirm.Visible = false;
btnDelete.Visible = false;
}
}
protected void approveDeviation(object sender, EventArgs e)
{
LinkButton btn = (LinkButton)(sender);
var arguments = btn.CommandArgument.Split(',');
int supplierId, productId;
Int32.TryParse(arguments[0], out supplierId);
Int32.TryParse(arguments[1], out productId);
var deviation = PriceDeviation.FetchByID(supplierId, productId);
deviation.IsApproved = true;
deviation.TimeOfApproval = DateTime.Now;
deviation.Save();
Master.PageTitleHtml = string.Format(SuppliersStrings.GetText(@"DeleteSupplierPageTitle"), SupplierName);
}
private string getSupplierServices(SupplierUI supplier)
{
if (supplier.IsProduct)
{
return(SuppliersStrings.GetText(@"IsProduct"));
}
else
{
List <core.DAL.Service> servicesList = SupplierController.GetServicesBySupplier(supplier.SupplierId);
StringBuilder services = new StringBuilder("");
foreach (core.DAL.Service service in servicesList)
{
if (!string.IsNullOrEmpty(services.ToString()))
{
services.Append(",");
}
services.Append(service.ServiceName);
}
return(services.ToString());
}
}
protected void LoadView()
{
rangeValidatorTxtPrecent.ErrorMessage = SuppliersStrings.GetText(@"RangeBetween0And100Error");
if (SupplierId > 0)
{
SupplierUI supplier = SupplierController.GetSupplierUI(SupplierId);
txtBusinessName.Text = supplier.BusinessName;
txtEmail.Text = supplier.Email;
txtEmail.Enabled = true;
// txtEmail.Enabled = false;
ddlIsProduct.SelectedValue = @"prod";
if (!supplier.IsProduct)
{
ddlIsProduct.SelectedValue = @"ser";
}
//chkIsProduct.Checked = supplier.IsProduct;
chkIsPremium.Checked = supplier.IsPremium;
//chkIsService.Checked = supplier.IsService;
services.Visible = supplier.IsService;
txtContactName.Text = supplier.ContactName;
txtContactPhone.Text = supplier.ContactPhone;
txtPhone.Text = supplier.Phone;
chkIsLocked.Checked = supplier.IsLocked;
txtStreet.Text = supplier.Street;
txtHouseNum.Text = supplier.HouseNum;
txtPrecent.Text = supplier.Precent.ToString();
txtSumPerMonth.Text = supplier.SumPerMonth.ToString();
//chkAllowChangeStatusJoinBid.Checked = supplier.AllowChangeStatusJoinBid;
//chkIsStatusJoinBid.Checked = supplier.StatusJoinBid;
//txtMaxWinningsNum.Text = supplier.MaxWinningsNum.ToString();
txtMastercardCode.Text = supplier.MastercardCode;
}
//cities list
GetCities(SupplierId);
//services list
GetServices(SupplierId);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
string Email = null;
bool EmailChanged = false;
string AdCompanyEmail = null;
AdCompany company = null;
if (IsNewMode)
{
Membership.UserCreateResults results = Membership.CreateAdCompany(txtEmail.Text, out company);
switch (results)
{
default:
case Membership.UserCreateResults.UnknownError:
Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"MessageCreateFailedUnknown"));
return;
case Membership.UserCreateResults.AlreadyExists:
Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"MessageCreateFailedAlreadyExists"));
return;
case Membership.UserCreateResults.InvalidEmailAddress:
Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"MessageCreateFailedEmailAddressInvalid"));
return;
case Membership.UserCreateResults.Success:
break;
}
CompanyId = company.CompanyId;
company.CreatedDate = DateTime.Now;
AdCompanyEmail = company.Email;
}
else
{
company = AdCompany.FetchByID(CompanyId);
AdCompanyEmail = company.Email;
}
company.BusinessName = txtBusinessName.Text;
company.ContactName = txtContactName.Text;
company.ContactPhone = txtContactPhone.Text;
company.Phone = txtPhone.Text;
company.Description = txtDescription.Text;
company.Save();
if (IsNewMode)
{
CompanyId = company.CompanyId;
}
if (company.Email != txtEmail.Text.Trim().NormalizeEmail())
{
if (AdCompany.FetchByEmail(txtEmail.Text.Trim().NormalizeEmail()) != null)
{
Master.MessageCenter.DisplayWarningMessage(AppUsersStrings.GetText(@"MessageEmailChangeFailed"));
}
else
{
company.Email = txtEmail.Text.Trim().NormalizeEmail();
EmailChanged = true;
}
}
AdCompanyEmail = company.Email;
company.Save();
if (IsNewMode)
{
string successMessage = AdvertisementsStrings.GetText(@"MessageCompanyCreated");
string url = @"EditAdCompany.aspx?Email=" + AdCompanyEmail + "&CompanyId=" + company.CompanyId;
url += @"&message-success=" + Server.UrlEncode(successMessage);
Response.Redirect(url, true);
}
else
{
string successMessage = SuppliersStrings.GetText(@"MessageSupplierSaved");
if (EmailChanged)
{
string url = @"EditAdCompany.aspx?message-success=" + Server.UrlEncode(successMessage) + "&CompanyId=" + company.CompanyId;
if (CompanyId != company.CompanyId)
{
url += @"&Email=" + AdCompanyEmail;
}
Response.Redirect(url, true);
}
else
{
Master.MessageCenter.DisplaySuccessMessage(successMessage);
LoadView();
}
}
}
protected void Page_Init(object sender, EventArgs e)
{
Master.AddButtonNew(SuppliersStrings.GetText(@"NewSupplierButton"), @"EditSupplier.aspx?New=yes", new string[] { Permissions.PermissionKeys.sys_perm });
ddlIsProduct.Items.Add(new ListItem(SuppliersStrings.GetText(@"IsProduct"), @"prod"));
ddlIsProduct.Items.Add(new ListItem(SuppliersStrings.GetText(@"IsService"), @"ser"));
}
protected void Page_PreRender(object sender, EventArgs e)
{
Master.PageTitleHtml = string.Format(SuppliersStrings.GetText(@"DeleteSupplierPageTitle"), SupplierName);
Master.ActiveMenu = "Suppliers";
}
protected void Page_PreRender(object sender, EventArgs e)
{
Master.PageTitle = SuppliersStrings.GetText(@"SuppliersPageTitle");
Master.ActiveMenu = "Suppliers";
Master.AddClientScriptInclude(@"dgDateManager.js");
}
protected void btnExportForCRM_Click(object sender, EventArgs e)
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"ActionType"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"SupplierId"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"SupplierName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Phone"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Email"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"BidId"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"Products"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"TotalPrice"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"PaymentForSupplier"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"OrderDate"), typeof(string)));
DateTime from, to = new DateTime();
if (DateTime.TryParse(datepickerFrom.Value.ToString(), out from))
{
TimeSpan tsFrom = new TimeSpan(TimeSelectorFrom.Hour, TimeSelectorFrom.Minute, 0);
from = from.Date + tsFrom;
}
if (DateTime.TryParse(datepickerTo.Value.ToString(), out to))
{
TimeSpan tsTo = new TimeSpan(TimeSelectorTo.Hour, TimeSelectorTo.Minute, 0);
to = to.Date + tsTo;
}
List <Int64> SuppliersIdList = FillSupplierList();
List <bool> IsReceivedSendDate = FillIsSendReceived();
List <int> StatusIdList = FillStatusList();
List <int> StatusPayementIdList = FillPayementStatusList();
string SearchBid = "%" + txtSearchBid.Text.Trim() + "%";
List <OrderUI> orders = OrderController.GetAllOrders(from, to, SuppliersIdList, IsReceivedSendDate, StatusIdList, StatusPayementIdList, SearchBid);
foreach (OrderUI order in orders)
{
var supplier = SupplierController.GetSupplierUI(order.SupplierId);
System.Data.DataRow row = dt.NewRow();
row[0] = "רכישה";
row[1] = order.SupplierId;
row[2] = order.SupplierName;
row[3] = supplier == null?"": "=\"" + supplier.Phone + "\"";
row[4] = supplier == null ? "" : supplier.Email;
row[5] = order.BidId;
row[6] = GetStringProduct(BidController.GetProductsByBid(order.BidId));
row[7] = order.TotalPrice;
row[8] = order.PaymentForSupplier;
row[9] = order.OrderDate;
dt.Rows.Add(row);
}
System.Data.DataRow sumRow = dt.NewRow();
dt.Rows.Add(sumRow);
SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true);
Response.Clear();
Response.AddHeader(@"content-disposition", @"attachment;filename=OrdersExportFoCRM_" + 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 btnExport_Click(object sender, EventArgs e)
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"SupplierId"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"SupplierName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"BidId"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"BidEndDate"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"DonationPrice"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"TotalPrice"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"PrecentDiscount"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"PriceAfterDiscount"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Precent"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"PaymentForSupplier"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"IsSendReceived"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"OrderDate"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"TransactionStatus"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"PaySupplierStatus"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"Remarks"), typeof(string)));
DateTime from, to = new DateTime();
if (DateTime.TryParse(datepickerFrom.Value.ToString(), out from))
{
TimeSpan tsFrom = new TimeSpan(TimeSelectorFrom.Hour, TimeSelectorFrom.Minute, 0);
from = from.Date + tsFrom;
}
if (DateTime.TryParse(datepickerTo.Value.ToString(), out to))
{
TimeSpan tsTo = new TimeSpan(TimeSelectorTo.Hour, TimeSelectorTo.Minute, 0);
to = to.Date + tsTo;
}
List <Int64> SuppliersIdList = FillSupplierList();
List <bool> IsReceivedSendDate = FillIsSendReceived();
List <int> StatusIdList = FillStatusList();
List <int> StatusPayementIdList = FillPayementStatusList();
string SearchBid = "%" + txtSearchBid.Text.Trim() + "%";
List <OrderUI> orders = OrderController.GetAllOrders(from, to, SuppliersIdList, IsReceivedSendDate, StatusIdList, StatusPayementIdList, SearchBid);
foreach (OrderUI order in orders)
{
System.Data.DataRow row = dt.NewRow();
row[0] = order.SupplierId;
row[1] = order.SupplierName;
row[2] = order.BidId;
row[3] = "\"" + order.BidEndDate + "\"";
row[4] = order.DonationPrice;
row[5] = order.TotalPrice;
row[6] = order.PrecentDiscount + "%";
row[7] = order.PriceAfterDiscount;
row[8] = order.Precent + "%";
row[9] = order.PaymentForSupplier;
row[10] = GlobalStrings.GetYesNo(order.IsSendReceived);
row[11] = "\"" + order.OrderDate + "\"";
row[12] = OrdersStrings.GetText(Enum.GetName(typeof(OrderStatus), order.TransactionStatus));
row[13] = OrdersStrings.GetText(Enum.GetName(typeof(PaymentStatus), order.PaySupplierStatus));;
row[14] = order.Remarks;
dt.Rows.Add(row);
}
System.Data.DataRow sumRow = dt.NewRow();
dt.Rows.Add(sumRow);
System.Data.DataRow sumRowTotalPrice = dt.NewRow();
sumRowTotalPrice[0] = OrdersStrings.GetText(@"SumTotalPrice") + " " + orders.Sum(o => o.TotalPrice);
dt.Rows.Add(sumRowTotalPrice);
System.Data.DataRow sumRowPriceAfterDiscount = dt.NewRow();
sumRowPriceAfterDiscount[0] = OrdersStrings.GetText(@"SumPriceAfterDiscount") + " " + orders.Sum(o => o.PriceAfterDiscount);
dt.Rows.Add(sumRowPriceAfterDiscount);
System.Data.DataRow sumRowSumPaymentForSupplier = dt.NewRow();
sumRowSumPaymentForSupplier[0] = OrdersStrings.GetText(@"SumPaymentForSupplier") + " " + orders.Sum(o => o.PaymentForSupplier);
dt.Rows.Add(sumRowSumPaymentForSupplier);
System.Data.DataRow sumRowSumDonation = dt.NewRow();
sumRowSumDonation[0] = OrdersStrings.GetText(@"SumDonation") + " " + orders.Sum(o => o.DonationPrice);
dt.Rows.Add(sumRowSumDonation);
SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true);
Response.Clear();
Response.AddHeader(@"content-disposition", @"attachment;filename=OrdersExport_" + 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 btnSave_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
string SupplierEmail = null;
bool EmailChanged = false;
AppSupplier supplier = null;
if (IsNewMode)
{
Membership.UserCreateResults results = Membership.CreateSupplier(txtEmail.Text, txtPassword.Text.Trim(), Convert.ToInt64(ddlCity.SelectedValue), out supplier);
switch (results)
{
default:
case Membership.UserCreateResults.UnknownError:
Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"MessageCreateFailedUnknown"));
return;
case Membership.UserCreateResults.AlreadyExists:
Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"MessageCreateFailedAlreadyExists"));
return;
case Membership.UserCreateResults.InvalidEmailAddress:
Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"MessageCreateFailedEmailAddressInvalid"));
return;
case Membership.UserCreateResults.Success:
break;
}
SupplierId = supplier.SupplierId;
SupplierEmail = supplier.Email;
//supplier.OrderDisplay = OrderDisplay.GetLastOrder() + 1;
}
else
{
supplier = core.DAL.AppSupplier.FetchByID(SupplierId);
SupplierEmail = supplier.Email;
}
supplier.BusinessName = txtBusinessName.Text;
if (ddlIsProduct.SelectedValue == "prod")
{
supplier.IsProduct = true;
supplier.IsService = false;
}
else
{
supplier.IsProduct = false;
supplier.IsService = true;
}
//supplier.IsProduct = chkIsProduct.Checked;
//supplier.IsService = chkIsService.Checked;
supplier.IsPremium = chkIsPremium.Checked;
supplier.IsLocked = chkIsLocked.Checked;
supplier.ContactName = txtContactName.Text;
supplier.ContactPhone = txtContactPhone.Text;
supplier.Phone = txtPhone.Text;
supplier.CityId = Convert.ToInt64(ddlCity.SelectedValue);
supplier.Street = txtStreet.Text;
supplier.HouseNum = txtHouseNum.Text;
try
{
string city = ddlCity.SelectedItem.Text;
//var address = (city != "" ? city + " " : "") +" "+ (txtStreet.Text != "" ? txtStreet.Text+" " : "") + (txtHouseNum.Text != "" ? txtHouseNum.Text : "");
var locationService = new GoogleLocationService();
var point = (city.Trim() != "" ? locationService.GetLatLongFromAddress(city) : new MapPoint());
supplier.AddressLocation = new Geometry.Point(point.Latitude, point.Longitude);
}
catch (Exception) {
supplier.AddressLocation = new Geometry.Point(0, 0);
}
supplier.HouseNum = txtHouseNum.Text;
supplier.Precent = txtPrecent.Text != "" ?Convert.ToInt32(txtPrecent.Text):0;
supplier.SumPerMonth = txtSumPerMonth.Text != "" ? Convert.ToInt32(txtSumPerMonth.Text) : 0;
//supplier.StatusJoinBid = chkIsStatusJoinBid.Checked;
//supplier.AllowChangeStatusJoinBid = chkAllowChangeStatusJoinBid.Checked;
//supplier.MaxWinningsNum =txtMaxWinningsNum.Text != "" ? Convert.ToInt32(txtMaxWinningsNum.Text) : 0;
supplier.MastercardCode = txtMastercardCode.Text;
supplier.Save();
if (IsNewMode)
{
SupplierId = supplier.SupplierId;
//if (chkIsStatusJoinBid.Checked == false)//handel
//{
// (new Query(SupplierProduct.TableSchema).Where(SupplierProduct.Columns.SupplierId, SupplierId).Delete()).Execute();
// ProductCollection pcol = ProductCollection.FetchByQuery(new Query(Product.TableSchema).Where(Product.Columns.IsDeleted, false));
// foreach (Product item in pcol)
// {
// SupplierProduct sp = new SupplierProduct();
// sp.SupplierId = SupplierId;
// sp.ProductId = item.ProductId;
// sp.Gift = "";
// sp.Save();
// }
//}
}
//if (chkIsService.Checked)
if (ddlIsProduct.SelectedValue != "prod")
{
foreach (ListItem item in ddlServices.Items)
{
if (item.Selected)
{
SupplierService supplierService = SupplierService.FetchByID(Convert.ToInt64(item.Value), SupplierId);
if (supplierService == null)
{
supplierService = new SupplierService();
supplierService.SupplierId = SupplierId;
supplierService.ServiceId = Convert.ToInt64(item.Value);
supplierService.Save();
}
}
else
{
SupplierService.Delete(Convert.ToInt64(item.Value), SupplierId);
}
}
}
else
{
SupplierController.DeleteAllSupplierServices(SupplierId);
}
if (supplier.Email != txtEmail.Text.Trim().NormalizeEmail())
{
if (AppSupplier.FetchByEmail(txtEmail.Text.Trim().NormalizeEmail()) != null)
{
Master.MessageCenter.DisplayWarningMessage(AppUsersStrings.GetText(@"MessageEmailChangeFailed"));
}
else
{
supplier.Email = txtEmail.Text.Trim().NormalizeEmail();
supplier.UniqueIdString = supplier.Email;//email.NormalizeEmail();
SupplierEmail = supplier.Email;
EmailChanged = true;
}
}
SupplierEmail = supplier.Email;
supplier.Save();
if (txtPassword.Text.Length > 0)
{
if (txtConfirmPassword.Text != txtPassword.Text)
{
Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"SupplierNewPasswordConfirmInvalid"));
return;
}
Membership.UserPasswordChangeResults results;
results = Membership.ChangeSupplierPassword(supplier.Email, txtPassword.Text);
switch (results)
{
default:
Master.MessageCenter.DisplayWarningMessage(SuppliersStrings.GetText(@"MessagePasswordChangeFailedUnknown"));
break;
case Membership.UserPasswordChangeResults.PasswordDoNotMatch:
Master.MessageCenter.DisplayWarningMessage(SuppliersStrings.GetText(@"MessagePasswordChangeBadOldPassword"));
break;
case Membership.UserPasswordChangeResults.Success:
break;
}
}
if (IsNewMode)
{
string successMessage = SuppliersStrings.GetText(@"MessageSupplierCreated");
string url = @"EditSupplier.aspx?Email=" + SupplierEmail + "&SupplierId=" + supplier.SupplierId;
url += @"&message-success=" + Server.UrlEncode(successMessage);
Response.Redirect(url, true);
}
else
{
string successMessage = SuppliersStrings.GetText(@"MessageSupplierSaved");
if (EmailChanged)
{
string url = @"EditSupplier.aspx?message-success=" + Server.UrlEncode(successMessage) + "&SupplierId=" + supplier.SupplierId;
if (SupplierId != supplier.SupplierId)
{
url += @"&Email=" + SupplierEmail;
}
Response.Redirect(url, true);
}
else
{
Master.MessageCenter.DisplaySuccessMessage(successMessage);
LoadView();
}
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"BusinessName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Email"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Phone"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactPhone"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"CityName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Street"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"HouseNum"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Precent"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SumPerMonth"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"CreateDate"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"citiesSupplied"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"citiesHomeService"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"MaxWinningsNum"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"AvgRate"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SupplierType"), typeof(string)));
List <SupplierUI> suppliers = new List <SupplierUI>();
string searchName = "%" + txtSearchName.Text.Trim() + "%";
string searchPhone = "%" + txtSearchPhone.Text.Trim() + "%";
suppliers = SupplierController.GetAllSuppliersUI(true, searchName, searchPhone);
foreach (SupplierUI supplier in suppliers)
{
System.Data.DataRow row = dt.NewRow();
row[0] = supplier.BusinessName;
row[1] = supplier.Email;
row[2] = "\"" + supplier.Phone + "\"";
row[3] = supplier.ContactName;
row[4] = "\"" + supplier.ContactPhone + "\"";
row[5] = supplier.CityName;
row[6] = supplier.Street;
row[7] = supplier.HouseNum;
row[8] = supplier.Precent;
row[9] = supplier.SumPerMonth;
row[10] = "\"" + supplier.CreateDate + "\"";
row[11] = (supplier.citiesSupplied.Count == 0 || supplier.citiesSupplied == null) ? "" : String.Join(", ", supplier.citiesSupplied.Select(o => o.CityName));
row[12] = (supplier.citiesHomeService.Count == 0 || supplier.citiesHomeService == null) ? "" : String.Join(", ", supplier.citiesHomeService.Select(o => o.CityName));
row[13] = supplier.MaxWinningsNum;
row[14] = supplier.AvgRate;
row[15] = supplier.IsProduct ? SuppliersStrings.GetText(@"IsProduct") : SuppliersStrings.GetText(@"IsService");
dt.Rows.Add(row);
}
System.Data.DataRow sumRow = dt.NewRow();
sumRow[0] = SuppliersStrings.GetText(@"SumSumPerMonth") + " " + suppliers.Sum(o => o.SumPerMonth);
dt.Rows.Add(sumRow);
SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true);
Response.Clear();
Response.AddHeader(@"content-disposition", @"attachment;filename=SuppliersExport_" + 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();
}
