private void ShowPaymentDatails(long p)
{
var result = new ExpensesManager().GetExpenseDetails(p);
if (result != null)
{
txtInvoiceNo.Text = result.InvoiceCode;
txtValue.Text = result.ExpenseValue.ToString();
txtNotes.Text = result.Notes;
txtPaymentDate.Text = MinutesuaeConcrete.GetDateOnly(result.PaymentDate);
//txt.Text = MinutesuaeConcrete.GetDateOnly(result.DueDate);
rblCompanyType.SelectedValue = result.CompanyType;
rblCompanyType_SelectedIndexChanged(rblCompanyType, new EventArgs());
ddlCurrencyUsed.SelectedValue = result.Currency_ID.ToString();
//ddlExpenseType.SelectedValue = result.ExpenseType_ID.ToString();
ddlDueforCompany.SelectedValue = result.Company_ID.ToString();
ddlExchangeCo.SelectedValue = result.ExchangeCompany_ID.ToString();
//lblCompanyCode.Text = result.Car_ID.ToString();
//linkCancel.NavigateUrl = "car/" + lblCompanyCode.Text + "/expenses.aspx";
//cbActive.Checked = (bool)result.Active;
}
}
private void ShowInvoiceDetails(long p)
{
var result = new SaleInvoicesManager().GetCarSaleInvoiceDetails(p);
if (result != null)
{
divArrivalDate.InnerHtml = MinutesuaeConcrete.GetDateOnly(result.arrive_date, "dd/MM/yyyy");
divCarModel.InnerHtml = string.Format("{0} - {1}", result.MarkerNameEn, result.TypeNameEn);
divCarNo.InnerHtml = result.engine_no;
divChassisNo.InnerHtml = result.chassis_no;
divColor.InnerHtml = result.ExtColorEn;
divLotNo.InnerHtml = result.lot_no;
divYear.InnerHtml = result.YearNameEn;
divClient.InnerHtml = result.ClientName;
divDescription.InnerHtml = result.Notes;
divEmail.InnerHtml = result.CompEmail;
divFax.InnerHtml = result.CompFax;
divFirst.InnerHtml = string.Format("{0:F} {1}", result.FirstAmount, result.CurrencySymbol);
divLotNo.InnerHtml = result.lot_no;
divName.InnerHtml = result.CompName;
divPhone.InnerHtml = result.CompPhone;
divPrice.InnerHtml = string.Format("{0:F} {1}", result.SalePrice, result.CurrencySymbol);
divWebsite.InnerHtml = result.CmopWebsite;
divBillStatus.InnerHtml = result.Active == false ? "Canceled" : "";
imgMain.ImageUrl += result.main_picture != null ? result.main_picture : "no_photo.jpg";
// Go to list.
string url = "client/" + result.Client_ID + "/invoices/" + MinutesuaeConcrete.ToSeoUrl(result.ClientName) + ".aspx";
lnkGoList.Attributes.Add("href", url);
}
}
private void ShowMainSafeDetails(int id)
{
var safe = new SafeMainManager().GetMainSafeDebitDetails(id);
if (safe != null)
{
hfId.Value = safe.SafeID.ToString();
txtValue.Text = safe.SafeDebitValue;
txtAddDate.Text = MinutesuaeConcrete.GetDateOnly(safe.SafeDebitDate);
ddlEmployee.SelectedValue = safe.Employee_ID.ToString();
ddlStore.SelectedValue = safe.Store_ID.ToString();
}
else
{
lblError.Text = Resources.AdminResources_en.DataNotFound;
}
}
private void ShowCarDetails(string p)
{
var result = new CarsManager().GetCarDetails(int.Parse(p));
if (result != null)
{
divArrivalDate.InnerHtml = MinutesuaeConcrete.GetDateOnly(result.arrive_date);
divCarModel.InnerHtml = result.MarkerNameEn + " " + result.TypeNameEn;
divCarNo.InnerHtml = result.engine_no;
divChassisNo.InnerHtml = result.chassis_no;
divColor.InnerHtml = result.ColorNameEn;
divLotNo.InnerHtml = result.lot_no;
divYear.InnerHtml = result.YearNameEn;
hfExpensesVal.Text = string.Format("{0:F}", result.CarTotalExpensesDollar);
imgMain.ImageUrl += result.main_picture != null ? result.main_picture : "no_photo.jpg";
//imgMain.Visible = (result.main_picture != null);
}
}
void StartUploadingPictures()
{
try
{
string ext = hfMasterID.Value + "_cars_";
HttpFileCollection hfc = Request.Files; // Get the HttpFileCollection
#region "start uploading"
for (int i = 0; i < hfc.Count; i++)
{
HttpPostedFile hpf = hfc[i];
if (hpf.ContentLength > 0)
{
string fileName = hfMasterID.Value + "_" + RandomValuess.GetUniqueKey() + hpf.FileName.Substring(hpf.FileName.LastIndexOf('.'));
string _path = Server.MapPath("~/Public/image/carParts/");
// Save full size image to the server.
hpf.SaveAs(_path + fileName);
// Save thumb to the server.
MinutesuaeConcrete.SaveThumb(fileName, _path);
// insert into db.
SaveImagesInDB(fileName);
//
this.divMessage.InnerHtml += "<b>Picture: </b>" + hpf.FileName + " <b>Size:</b> " +
hpf.ContentLength + " <b>Type:</b> " + hpf.ContentType + " Uploaded Successfully <br/>";
this.divMessage.Attributes.Add("class", "green-alert");
}
}
#endregion
}
catch (Exception ex)
{
lblError.Text = "Error: " + ex.Message; lblError.Visible = true; lblError.ForeColor = System.Drawing.Color.DarkRed;
}
}
private void ShowClientPaymentInformation(int Id)
{
var result = new ClientPaymentsManager().GetClientPaymentDetails(Id);
if (result != null)
{
//hfID.Value = result.ClientPaymentID.ToString();
txtDate.Text = MinutesuaeConcrete.GetDateOnly(result.PaymentDate);
txtPaymentValue.Text = result.PaymentValue.ToString();
txtReceivedName.Text = result.ReceiverName;
txtShortdesc.Text = result.Notes;
//cbActive.Checked = (bool)result.Active;
ddlClients.SelectedValue = result.Client_ID.ToString();
ddlCurrency.SelectedValue = result.Currency_ID.ToString();
ddlExchangeCo.SelectedValue = result.ExchangeCompany_ID.ToString();
if (result.Invoice_ID != null)
{
ltlInvoiceID.Text = result.Invoice_ID.ToString();
}
}
}
/// <summary>
/// Add new ClientPayment to db.
/// </summary>
private void SaveClientPaymentInformation()
{
ClientPayment item = new ClientPayment();
try
{
if (hfID.Value != "")
{
item.PaymentID = Convert.ToInt32(hfID.Value);
}
item.Client_ID = Convert.ToInt32(ddlClients.SelectedValue);
item.Currency_ID = Convert.ToInt32(ddlCurrency.SelectedValue);
item.Notes = txtShortdesc.Text;
item.ReceiverName = txtReceivedName.Text;
if (ddlExchangeCo.SelectedIndex > 0)
{
item.ExchangeCompany_ID = Convert.ToInt32(ddlExchangeCo.SelectedValue);
}
if (ltlInvoiceID.Text != "")
{
item.Invoice_ID = Convert.ToInt32(ltlInvoiceID.Text);
}
if (txtDate.Text != "")
{
item.PaymentDate = Convert.ToDateTime(txtDate.Text);
}
if (txtPaymentValue.Text != "")
{
item.PaymentValue = Convert.ToDecimal(txtPaymentValue.Text);
}
//item.Active = cbActive.Checked;
item.Store_ID = 1; // Store sale from.
item.System_Who_Add = ClientSession.Current.loginId;
item.System_LastAction_IP = ClientSession.Current.IP;
// perform saving method.
if (new ClientPaymentsManager().SaveClientPayment(item))
{
// go to ClientPayments list.
string url = string.Format("client/{0}/payments/{1}.aspx", ddlClients.SelectedValue, MinutesuaeConcrete.ToSeoUrl(ddlClients.SelectedItem.Text)); //"ClientPaymentsView.aspx";
if (hfID.Value != "")
{
Response.Redirect(ResolveClientUrl(url));
}
else
{
Response.Redirect(ResolveClientUrl(url));
}
}
else
{
lblError.Text = Resources.AdminResources_en.ErrorSave;
}
}
catch { lblError.Text = Resources.AdminResources_en.ErrorSave; }
}
void BingCarDetails()
{
string _carId = string.Format("{0}", Page.RouteData.Values["car"]);
if (_carId.IndexOf('-') > -1)
{
_carId = _carId.Substring(0, _carId.IndexOf('-'));
}
_carId = MinutesuaeConcrete.ExtractNumbers(_carId);
// get all data from db.
var dsAll = GetData("CarsData_SelectOne", _carId);
if (dsAll != null && dsAll.Tables[0].Rows.Count > 0)
{
var dtCar = dsAll.Tables[0];
_id.InnerHtml = string.Format("{0}", dtCar.Rows[0]["CarID"]);
model.InnerHtml = string.Format("{0}", dtCar.Rows[0]["TypeNameEn"]);
mker.InnerHtml = string.Format("{0}", dtCar.Rows[0]["MakerNameEn"]);
year.InnerHtml = string.Format("{0}", dtCar.Rows[0]["Year"]);
color.InnerHtml = string.Format("{0}", dtCar.Rows[0]["ColorNameAr"]);
lotno.InnerHtml = string.Format("{0}", dtCar.Rows[0]["LotNo"]);
chassisno.InnerHtml = string.Format("{0}", dtCar.Rows[0]["ChassisNo"]);
status.InnerHtml = string.Format("{0}", dtCar.Rows[0]["WorkingStatusName"]);
transmi.InnerHtml = string.Format("{0}", dtCar.Rows[0]["TransmissionNameEn"]);
arrive.InnerHtml = dtCar.Rows[0]["Arrived"].Equals("True") ? // || parseDate(dtCar.Rows[0]["ArrivalDate"]).Subtract(DateTime.Now).TotalDays <= 0
"واصـــله" : string.Format("قيد الشحن {0} {1}", dtCar.Rows[0]["ArrivalDate"],
(dtCar.Rows[0]["ShipCompanyNameEn"] != null && !string.IsNullOrEmpty(Convert.ToString(dtCar.Rows[0]["ShipCompanyNameEn"])) ? dtCar.Rows[0]["ShipCompanyNameEn"].ToString().Split('-')[1] : ""));
orangePrice.InnerHtml = price.InnerHtml = string.Format("{0:0,0} $", dtCar.Rows[0]["WesitePrice"]);
notes.InnerHtml = string.Format("{0}", dtCar.Rows[0]["Notes"]);
// client`s car
if (dtCar.Rows[0]["OwnerID"].ToString().Equals("2"))
{
divExtraInfo.Text = string.Format(@"<li class='list-group-item'><span class='inf'><i class='fa fa-info-circle text-danger'></i></span><b class='text-danger'>سيارة عميل لدي شركة</b></li>
<li class='list-group-item'><span class='inf text-danger'>للإتصال</span> <b class='text-danger'>{0}</b></li>", dtCar.Rows[0]["phone"]);
}
pageTitle.InnerHtml = string.Format("{0} - {1} - {2}", dtCar.Rows[0]["MakerNameEn"], dtCar.Rows[0]["TypeNameEn"], dtCar.Rows[0]["Year"]);
// 4 seo
Page.Title += pageTitle.InnerText;
Page.MetaDescription += pageTitle.InnerText;
Page.MetaKeywords += "," + pageTitle.InnerText.Replace(" ", ",");
StringBuilder shareTags = new StringBuilder(),
twitImgs = new StringBuilder();
var masterSocial = this.Master.FindControl("socialShare") as Literal;
shareTags.Append(string.Format(@"<meta property='og:type' content='website' />
<meta property='og:title' content='{0}' />
<meta property='og:description' content='{0}' />
<meta property='og:url' content='{1}' />
<meta property='og:site_name' content='IRAQUSEDCARS.AE' />
<meta http-equiv='imagetoolbar' content='false' />
<meta name='twitter:site' content='@aliraqusedcars' />
<meta name='twitter:creator' content='@aliraqusedcars' />
<meta name='twitter:url' content='{1}' />
<meta name='twitter:title' content='{0}' />
<meta name='twitter:description' content='{0}' />",
Resources.Resource_ar.IraqComp + " " + pageTitle.InnerText,
Request.Url.AbsoluteUri));
// bind car images
var dtImages = dsAll.Tables[1];
for (int i = 0; i < dtImages.Rows.Count; i++)
{
string imgDomain = "https://www.iraqusedcars.ae"; // Config.CDN
string path = string.Format("{0}/public/cars/{1}/{2}", imgDomain, _carId, dtImages.Rows[i]["URL"]),
pathThumb = string.Format("{0}/public/cars/{1}/_thumb/{2}", imgDomain, _carId, dtImages.Rows[i]["URL"]);
// facebook images
var fbImgTag = string.Format("<meta property='og:image' content='{0}' />", path);
shareTags.Append(fbImgTag);
// twitter images
//twitImgs.Append(path + ",");
divCarImages.InnerHtml += @"<div data-p='144.50' style='display: none;'><img alt=" + pageTitle.InnerText + " data-rel='prettyPhoto[gallery]' data-u='image' src='" + path + "' /><img data-u='thumb' src='" + pathThumb + "' /></div>";
}
masterSocial.Text = shareTags.ToString();
// bind next , prev buttons
var dtNextPrev = dsAll.Tables[2];
string prevID = string.Format("{0}", dtNextPrev.Rows[0]["PrevID"]),
nextID = string.Format("{0}", dtNextPrev.Rows[0]["NextID"]);
if (!string.IsNullOrEmpty(nextID))
{
nextCar.HRef = string.Format("/car/{0}-details", nextID);
nextCar.Attributes["class"] = nextCar.Attributes["class"].Replace("hidden", "").Trim();
}
if (!string.IsNullOrEmpty(prevID))
{
prevCar.HRef = string.Format("/car/{0}-details", prevID);
prevCar.Attributes["class"] = prevCar.Attributes["class"].Replace("hidden", "").Trim();
}
// comments
var url = string.Format(@"https://www.iraqusedcars.ae/car/{0}-{1}-{2}-{3}", _id.InnerText, dtCar.Rows[0]["MakerNameEn"], dtCar.Rows[0]["TypeNameEn"], dtCar.Rows[0]["Year"]);
divCarComments.Attributes.Add("data-href", url);
}
else
{
// show not exist message.
myMessage.InnerHtml = Resources.Resource_ar.CarDetailsNotFound; myMessage.Visible = true;
myMessage.Attributes.Add("class", "myMessage alert alert-danger");
}
}
private void SavePayment()
{
CarExpense exp = new CarExpense();
exp.ExpenseID = (hfID.Value != "" ? Convert.ToInt64(hfID.Value) : 0);
exp.InOutType = "payment";
//exp.Active = cbActive.Checked;
exp.CompanyType = rblCompanyType.SelectedValue;
exp.InvoiceCode = txtInvoiceNo.Text;
exp.Notes = txtNotes.Text;
//exp.Car_ID = Convert.ToInt64(lblCompanyCode.Text);
//exp.ExpenseType_ID = Convert.ToInt32(ddlExpenseType.SelectedValue);
exp.PaymentDate = Convert.ToDateTime(txtPaymentDate.Text);
exp.ExpenseValue = Convert.ToDecimal(txtValue.Text);
exp.PaymentValue = Convert.ToDecimal(txtValue.Text);
//exp.DueDate = Convert.ToDateTime(txtDueDate.Text);
exp.Company_ID = Convert.ToInt64(ddlDueforCompany.SelectedValue);
exp.Currency_ID = Convert.ToInt32(ddlCurrencyUsed.SelectedValue);
exp.ExchangeCompany_ID = Convert.ToInt64(ddlExchangeCo.SelectedValue);
exp.Store_ID = 1;
exp.WhoAdd = ClientSession.Current.loginId;
exp.EditIP = exp.AddIP = ClientSession.Current.IP;
if (new ExpensesManager().SaveExpense(exp))
{
string url = ResolveClientUrl("payments/" + ddlDueforCompany.SelectedValue + "/" + rblCompanyType.SelectedValue + "/" + MinutesuaeConcrete.ToSeoUrl(ddlDueforCompany.SelectedItem.Text) + ".aspx");
Response.RedirectPermanent(url);
}
else
{
lblError.Text = Resources.AdminResources_en.ErrorSave;
}
}
private void ShowCarInformation(int Id)
{
var result = new CarsManager().GetCarDetails(Id);
if (result != null)
{
cbActive.Checked = (bool)result.active;
txtcontainer_no.Text = result.container_no;
txtContainerCode.Text = result.container_code;
txtPolyFielding.Text = result.poly_fielding;
txtBookingNo.Text = result.booking_no;
if (result.arrive_date != null)
{
txtArrivael_Date.Text = MinutesuaeConcrete.GetDateOnly(result.arrive_date);
}
txtchassis_no.Text = result.chassis_no;
if (result.checkout_date != null)
{
txtCheckoutDate.Text = MinutesuaeConcrete.GetDateOnly(result.checkout_date);
}
txtCode.Text = result.car_code.ToString();
if (result.cost != null)
{
txtCost.Text = result.cost.ToString();
}
txtCustomsNo.Text = result.Customs_No;
txtEngine_no.Text = result.engine_no;
txtLot_no.Text = result.lot_no;
txtMileage.Text = result.mileage;
if (result.real_price != null)
{
txtreal_price.Text = result.real_price.ToString();
}
txtRemarks.Text = result.car_remarks;
if (result.sale_date != null)
{
txtSaleDate.Text = MinutesuaeConcrete.GetDateOnly(result.sale_date);
}
if (result.sale_price != null)
{
txtSalePrice.Text = result.sale_price.ToString();
}
txtSaleTo.Text = result.sale_to;
if (result.Shipping_date != null)
{
txtShippingDate.Text = MinutesuaeConcrete.GetDateOnly(result.Shipping_date);
}
if (result.WorkshopEntryDate != null)
{
txtWorkshopEntryDate.Text = MinutesuaeConcrete.GetDateOnly(result.WorkshopEntryDate);
}
if (result.WorkshopExitDate != null)
{
txtWorkshopExitDate.Text = MinutesuaeConcrete.GetDateOnly(result.WorkshopExitDate);
}
if (result.expected_arrive_date != null)
{
txtExpectedArrivalDate.Text = MinutesuaeConcrete.GetDateOnly(result.expected_arrive_date);
}
if (result.dubia_arrive_date != null)
{
txtDubiaArrivalDate.Text = MinutesuaeConcrete.GetDateOnly(result.dubia_arrive_date);
}
if (result.sharjah_arrive_date != null)
{
txtSharjahArrivalDate.Text = MinutesuaeConcrete.GetDateOnly(result.sharjah_arrive_date);
}
txtPurchaseDate.Text = string.Format("{0:MM/dd/yyyy}", result.purchase_date);
//if (result.Auction_ID != null) { ddlAuctions.SelectedValue = result.Auction_ID.ToString(); }
//ddlAuctions_SelectedIndexChanged(ddlAuctions, new EventArgs());
//if (result.Buyer_ID != null) { ddlBuyers.SelectedValue = result.Buyer_ID.ToString(); }
if (result.body_style != null)
{
ddlbody_style.SelectedValue = result.body_style.ToString();
}
if (result.car_capacity != null)
{
ddlcar_capacity.SelectedValue = result.car_capacity.ToString();
}
if (result.car_drive != null)
{
ddlCar_drive.SelectedValue = result.car_drive.ToString();
}
if (result.car_engine != null)
{
ddlCar_engine.SelectedValue = result.car_engine.ToString();
}
if (result.car_transmission != null)
{
ddlcar_transmission.SelectedValue = result.car_transmission.ToString();
}
if (result.CurrencyExchange_ID != null)
{
ddlCurrency.SelectedValue = result.CurrencyExchange_ID.ToString();
}
if (result.exterior_color != null)
{
ddlexterior_color.SelectedValue = result.exterior_color.ToString();
}
if (result.interior_color != null)
{
ddlinterior_color.SelectedValue = result.interior_color.ToString();
}
if (result.Store_ID != null)
{
ddlStores.SelectedValue = result.Store_ID.ToString();
}
//if (result.Transport_ID != null) { ddlTransferes.SelectedValue = result.Transport_ID.ToString(); }
if (result.Marker_ID != null)
{
ddlMarkers.SelectedValue = result.Marker_ID.ToString();
}
ddlMarkers_SelectedIndexChanged(ddlMarkers, new EventArgs());
if (result.Model_ID != null)
{
ddlModels.SelectedValue = result.Model_ID.ToString();
}
if (result.PortShipping_ID != null)
{
ddlPortShipping_ID.SelectedValue = result.PortShipping_ID.ToString();
}
if (result.Ship_ID != null)
{
ddlShip_ID.SelectedValue = result.Ship_ID.ToString();
}
if (result.ShippingCompany_ID != null)
{
ddlShippingCompany_ID.SelectedValue = result.ShippingCompany_ID.ToString();
}
//if (result.State_ID != null) { ddlState_ID.SelectedValue = result.State_ID.ToString(); }
//ddlState_ID_SelectedIndexChanged(ddlState_ID, new EventArgs());
if (result.featured_car != null && (bool)result.featured_car == true)
{
rblFeatures.SelectedValue = "true";
}
//if (result.Region_ID != null) { ddlRegion_ID.SelectedValue = result.Region_ID.ToString(); }
if (result.WorkingStatus_ID != null)
{
ddlWorkingStatus_ID.SelectedValue = result.WorkingStatus_ID.ToString();
}
if (result.Workshop_ID != null)
{
ddlWorkshop_ID.SelectedValue = result.Workshop_ID.ToString();
}
if (result.Year_ID != null)
{
ddlYears.SelectedValue = result.Year_ID.ToString();
}
hfVisitors.Value = ((result.visitors != null) ? (result.visitors.ToString()) : "0");
hfTransferStatus.Value = ((result.TransferStatus_ID != null) ? (result.TransferStatus_ID.ToString()) : "1");
hfMain_Picture.Value = ((result.main_picture != null) ? (result.main_picture) : "");
if (result.car_options != null)
{
ShowOptions(result.car_options);
}
}
}
