private void LoadPage()
{
DataTable tempIL = OrderTable.DT;
RepeaterOrder.DataSource = null;
RepeaterOrder.DataBind();
RepeaterOrder.DataSource = tempIL;
RepeaterOrder.DataBind();
LabelTotal.Text = "Grand Total: ₱ " + OrderTable.getTotal();
}
protected virtual void GetDataSource()
{
// Điều kiện bắt buộc: chưa xóa và đang pending
//ICriterion criterion = Expression.Eq(Booking.DELETED, false);
//criterion = Expression.And(criterion, Expression.Eq(Booking.STATUS, StatusType.Pending));
var criterion = Expression.And(Expression.Eq("Status", StatusType.Pending),
Expression.Ge("Deadline", DateTime.Now));
criterion = Expression.And(criterion, Expression.Eq("Deleted", false));
int count;
// Điều kiện từ query string
if (Request.QueryString["UserId"] != null)
{
User user = Module.UserGetById(Convert.ToInt32(Request.QueryString["UserId"]));
criterion = Expression.And(criterion, Expression.Eq("CreatedBy", user));
// và mình là sale in charge
criterion = Expression.And(criterion, Expression.Eq("agency.Sale", UserIdentity));
}
else // nếu không có user thì lấy create by me OR sale in charge
{
if (Request.QueryString["mode"] != "all")
{
criterion = Expression.And(criterion,
Expression.Or(Expression.Eq("CreatedBy", UserIdentity),
Expression.Eq("agency.Sale", UserIdentity)));
}
}
if (Request.QueryString["TripId"] != null)
{
SailsTrip trip = Module.TripGetById(Convert.ToInt32(Request.QueryString["TripId"]));
criterion = Expression.And(criterion, Expression.Eq("Trip", trip));
}
if (Request.QueryString["Date"] != null)
{
DateTime date = DateTime.FromOADate(Convert.ToDouble(Request.QueryString["date"]));
criterion = Expression.And(criterion, Expression.Eq("StartDate", date.Date));
}
Order order = RepeaterOrder.GetOrderFromQueryString(Request.QueryString);
if (order == null)
{
order = Order.Asc("Deadline");
}
rptBookingList.DataSource = Module.BookingGetByCriterion(criterion, order, out count, pagerOrders.PageSize,
pagerOrders.CurrentPageIndex);
pagerOrders.VirtualItemCount = count;
}
protected void Order()
{
if (Session["LabId"] != null)
{
dtorder = operation.GetOrderReportGenerated(Session["LabId"].ToString());
if (dtorder != null)
{
RepeaterOrder.DataSource = dtorder;
RepeaterOrder.DataBind();
}
}
}
protected void PatientOrder()
{
if (Session["LabId"] != null && Request.QueryString["pid"] != null)
{
dtorder = operation.PatientOrder(Session["LabId"].ToString(), Request.QueryString["pid"].ToString());
if (dtorder != null)
{
RepeaterOrder.DataSource = dtorder;
RepeaterOrder.DataBind();
}
}
}
protected void GetOrder()
{
string ptc = Request.QueryString["PTC"].ToString();
string sql = "SELECT orderno AS Code,supplierid AS SupplierCode,suppliernm AS Supplier,shtime AS Date," +
"ywyid AS ClerkCode,ywynm AS Clerk,depid AS DepCode,depnm AS Dep,totalstate AS OrderState," +
"marid AS MaterialCode,marnm AS MaterialName,marcz AS Attribute,margb AS GB," +
"margg AS MaterialStandard,marunit AS Unit,zxnum AS Number,recgdnum AS ArrivedNumber,recdate AS ArrivedDate," +
"price AS UnitPrice,taxrate AS TaxRate,ctprice AS CTUP,amount AS Amount,ctamount AS CTA," +
"planmode AS PlanMode,ptcode AS PTC,detailstate AS ItemState " +
" FROM View_TBPC_PURORDERDETAIL_PLAN_TOTAL WHERE ptcode='" + ptc + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
RepeaterOrder.DataSource = dt;
RepeaterOrder.DataBind();
}
protected void Order()
{
if (Session["LabId"] != null)
{
dsorder = operation.GetOrderReportNotGenerated(Session["LabId"].ToString());
if (dsorder != null)
{
dsorder.Relations.Add(new DataRelation("OrderedTest", dsorder.Tables[0].Columns["OrderID"], dsorder.Tables[1].Columns["OrderID"], false));
dsorder.Relations.Add(new DataRelation("OrderedAllTest", dsorder.Tables[0].Columns["OrderID"], dsorder.Tables[2].Columns["OrderID"], false));
RepeaterOrder.DataSource = dsorder;
RepeaterOrder.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("pt-Pt");
if (Session["userlogin"] == null)
{
if (Session["anonimo"] != null)
{
OrderDetailsTemps = (List <OrderDetailsTemp>)Session["anonimo"];
lbl_total.Text = OrderDetailsTemps.Sum(o => Convert.ToDecimal((decimal)o.Price * o.Quantity)).ToString("C");
lbl_sub.Text = OrderDetailsTemps.Sum(o => Convert.ToDecimal((decimal)o.Price * o.Quantity)).ToString("C");
numItemInCart.Text = OrderDetailsTemps.Count().ToString();
RepeaterOrder.DataSource = OrderDetailsTemps;
RepeaterOrder.DataBind();
}
}
else
{
lbl_user.Text = $"Benvido {Session["userlogin"].ToString()}";
btn_login.Text = "Logout";
id = Convert.ToInt32(Session["userId"].ToString());
BindingRepeaterOrder(id);
if (Session["userRole"].ToString() == "Reseller")
{
resellerInfo.Visible = true;
}
}
if (OrderDetailsTemps.Count == 0 || OrderDetailsTemps == null)
{
btn_checkout.Enabled = false;
}
}
protected virtual void GetDataSource()
{
// Điều kiện bắt buộc: chưa xóa và đang pending
ICriterion criterion = Expression.Eq(Booking.DELETED, false);
criterion = Expression.And(criterion, Expression.Eq(Booking.STATUS, StatusType.Pending));
int count;
// Điều kiện từ query string
if (Request.QueryString["UserId"] != null)
{
User user = Module.UserGetById(Convert.ToInt32(Request.QueryString["UserId"]));
criterion = Expression.And(criterion, Expression.Eq(Booking.PARTNERID, user));
}
if (Request.QueryString["TripId"] != null)
{
SailsTrip trip = Module.TripGetById(Convert.ToInt32(Request.QueryString["TripId"]));
criterion = Expression.And(criterion, Expression.Eq(Booking.TRIP, trip));
}
if (Request.QueryString["Date"] != null)
{
DateTime date = DateTime.FromOADate(Convert.ToDouble(Request.QueryString["date"]));
criterion = Expression.And(criterion, Expression.Eq(Booking.STARTDATE, date.Date));
}
Order order = RepeaterOrder.GetOrderFromQueryString(Request.QueryString);
if (order == null)
{
order = Order.Desc(Booking.CREATEDDATE);
}
rptBookingList.DataSource = Module.BookingGetByCriterion(criterion, order, out count, pagerOrders.PageSize,
pagerOrders.CurrentPageIndex);
pagerOrders.VirtualItemCount = count;
}
public void BindingRepeaterOrder(int id)
{
SqlConnection myConn = new SqlConnection(ConfigurationManager.ConnectionStrings["OnShopCenterConnectionString"].ConnectionString);
SqlCommand mycommand = new SqlCommand
{
CommandType = CommandType.StoredProcedure,
CommandText = "GetOrderDetails",
Connection = myConn
};
mycommand.Parameters.AddWithValue("@userId", id);
myConn.Open();
var reader = mycommand.ExecuteReader();
SqlMoney money = 0.0m;
while (reader.Read())
{
numItemInCart.Text = reader.GetInt32(7).ToString();
lbl_total.Text = ((decimal)reader.GetSqlMoney(8)).ToString("C");
lbl_sub.Text = ((decimal)reader.GetSqlMoney(8)).ToString("C");
SqlMoney price = reader.GetSqlMoney(2);
if (Session["userRole"].ToString() == "Reseller")
{
price -= price * (SqlMoney)0.2;
money += price * reader.GetInt32(5);
lbl_sub.Text = money.ToString();
lbl_total.Text = money.ToString();
}
string base64 = string.Empty;
if (reader[9] != null && reader[9].ToString().Length > 1)
{
base64 = Convert.ToBase64String((byte[])reader[9]);
}
string path;
if (string.IsNullOrEmpty(base64))
{
path = "../Config/images/no-image.png";
}
else
{
path = $"data:image/jpeg;base64,{base64}";
}
OrderDetailsTemps.Add(new OrderDetailsTemp
{
ProductId = reader.GetInt32(0),
ProductName = reader.GetString(1),
Price = price,
Description = reader.GetString(3),
Category = reader.GetString(4),
Quantity = reader.GetInt32(5),
UserId = reader.GetInt32(6),
ImagePath = path
});
}
reader.Close();
myConn.Close();
RepeaterOrder.DataSource = OrderDetailsTemps;
RepeaterOrder.DataBind();
}
protected void rptBookingList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Header)
{
RepeaterOrder.FILE_NAME = "OrderReport.aspx";
RepeaterOrder.SetOrderLink(e, "Agency", Request.QueryString);
RepeaterOrder.SetOrderLink(e, "Trip", Request.QueryString);
RepeaterOrder.SetOrderLink(e, "StartDate", Request.QueryString);
}
if (e.Item.DataItem is Booking)
{
Booking booking = (Booking)e.Item.DataItem;
bool isDisabled = false;
var hplCode = e.Item.FindControl("hplCode") as HyperLink;
if (hplCode != null)
{
hplCode.Text = string.Format(BookingFormat, booking.Id);
hplCode.NavigateUrl = string.Format("BookingView.aspx?NodeId={0}&SectionId={1}&bi={2}",
Node.Id, Section.Id, booking.Id);
}
#region -- Date --
Label labelDate = e.Item.FindControl("labelDate") as Label;
if (labelDate != null)
{
labelDate.Text = booking.StartDate.ToString("dd/MM/yyyy");
}
#endregion
#region -- Trip --
Label labelTrip = e.Item.FindControl("labelTrip") as Label;
if (labelTrip != null)
{
labelTrip.Text = booking.Trip.Name;
if (booking.Trip.NumberOfOptions > 1)
{
labelTrip.Text += string.Format("({0})", booking.TripOption);
}
}
#endregion
#region -- Partner --
Label labelPartner = e.Item.FindControl("labelPartner") as Label;
if (labelPartner != null)
{
if (booking.Agency != null)
{
labelPartner.Text = booking.Agency.Name;
}
else
{
labelPartner.Text = SailsModule.NOAGENCY;
}
}
if (booking.Agency != null && booking.Agency.Sale != null)
{
ValueBinder.BindLiteral(e.Item, "litSale", booking.Agency.Sale.AllName);
}
#endregion
#region -- Rooms --
Label labelRoom = e.Item.FindControl("labelRoom") as Label;
if (labelRoom != null)
{
try
{
Dictionary <string, int> rooms = new Dictionary <string, int>();
Dictionary <string, int> roomAvaiable = new Dictionary <string, int>();
// Đối với mỗi booking đã đặt
foreach (BookingRoom room in booking.BookingRooms)
{
// Lấy về loại phòng
string key = room.RoomClass.Name + " " + room.RoomType.Name;
if (room.RoomType.IsShared)
{
key += " spaces";
}
if (rooms.ContainsKey(key))
{
// Nếu đã có trong từ điển thì cộng thêm
if (room.RoomType.IsShared)
{
rooms[key] += 1;
}
else
{
rooms[key] += room.VirtualAdult;
}
}
else
{
// Nếu chưa có trong từ điển thì thêm vào
if (room.RoomType.IsShared)
{
rooms.Add(key, 1);
}
else
{
rooms.Add(key, room.VirtualAdult);
}
}
// Nếu thông tin về loại phòng này chưa có trong từ điển
if (!roomAvaiable.ContainsKey(key))
{
// Hoàn toàn phụ thuộc vào số chỗ trống
roomAvaiable.Add(key, Module.RoomCount(room.RoomClass, room.RoomType, booking.Cruise, booking.StartDate, booking.Trip.NumberOfDay, booking));
}
}
//TODO: Recheck
// Kiểm tra với từng loại phòng, nếu có 1 loại ko đủ chỗ trống thì loại
foreach (KeyValuePair <string, int> entry in rooms)
{
labelRoom.Text += entry.Value + @" " + entry.Key + @"<br/>";
//if (Convert.ToInt32(entry.Value) > Convert.ToInt32(roomAvaiable[entry.Key]))
//{
// isDisabled = true;
//}
}
}
catch (Exception ex)
{
ShowError(ex.Message);
}
}
#endregion
var labelNumberOfPax = e.Item.FindControl("labelNumberOfPax") as Label;
if (labelNumberOfPax != null)
{
labelNumberOfPax.Text = string.Format(Resources.formatCustomerCount, booking.Adult, booking.Child,
booking.Baby);
}
var lbtApprove = e.Item.FindControl("lbtApprove") as LinkButton;
if (lbtApprove != null)
{
// Lấy lại giá trị đánh dấu số phòng có đủ hay không
if (!isDisabled)
{
Control chkNofity = e.Item.FindControl("chkNofity");
string popupurl = string.Format("SendEmail.aspx?NodeId={0}&SectionId={1}&BookId={2}&status=1",
Node.Id, Section.Id, booking.Id);
lbtApprove.OnClientClick = "if (document.getElementById('" + chkNofity.ClientID + "').checked == 1) PopupCenter('" + popupurl + "','Send email',800,600)";
}
else
{
lbtApprove.Enabled = false;
lbtApprove.Text = Resources.textStatusNotAvaiable;
lbtApprove.Attributes.Add("style", "color:" + SailsModule.IMPORTANT);
}
}
LinkButton lbtCancel = e.Item.FindControl("lbtCancel") as LinkButton;
if (lbtCancel != null)
{
Control chkNofity = e.Item.FindControl("chkNofity");
string popupurl = string.Format("SendEmail.aspx?NodeId={0}&SectionId={1}&BookId={2}&status=2", Node.Id, Section.Id, booking.Id);
lbtCancel.OnClientClick = "if (document.getElementById('" + chkNofity.ClientID + "').checked == 1) PopupCenter('" + popupurl + "','Send email',800,600)";
}
if (!string.IsNullOrEmpty(booking.Agency.Phone))
{
ValueBinder.BindLiteral(e.Item, "litPhone", "(" + booking.Agency.Phone + ")");
}
if (booking.Deadline.HasValue)
{
ValueBinder.BindLiteral(e.Item, "litPendingUntil", booking.Deadline.Value.ToString("HH:mm dd/MM/yyyy"));
}
}
}
protected void rptTours_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Header)
{
RepeaterOrder.FILE_NAME = "TourList.aspx";
RepeaterOrder.SetOrderLink(e, "Name", Request.QueryString);
RepeaterOrder.SetOrderLink(e, "TourType", Request.QueryString);
RepeaterOrder.SetOrderLink(e, "NumberOfDay", Request.QueryString);
RepeaterOrder.SetOrderLink(e, "LengthTrip", Request.QueryString);
}
if (e.Item.DataItem is Tour)
{
Tour tour = (Tour)e.Item.DataItem;
#region Name
HyperLink hyperLinkView = e.Item.FindControl("hyperLinkView") as HyperLink;
if (hyperLinkView != null)
{
hyperLinkView.Text = tour.Name;
if (tour.Provider != null)
{
hyperLinkView.NavigateUrl = string.Format("TourPackagePriceConfig.aspx?NodeId={0}&SectionId={1}&TourId={2}",
Node.Id, Section.Id, tour.Id);
}
else
{
hyperLinkView.NavigateUrl = string.Format("TourConfig.aspx?NodeId={0}&SectionId={1}&TourId={2}",
Node.Id, Section.Id, tour.Id);
}
}
#endregion
#region Start
Label labelCityStart = e.Item.FindControl("labelCityStart") as Label;
if (labelCityStart != null)
{
if (tour.CityStart != null)
{
labelCityStart.Text = tour.CityStart.Name;
}
else
{
if (tour.StartFrom != null)
{
labelCityStart.Text = tour.StartFrom.Name;
}
}
}
#endregion
#region End
Label labelCityEnd = e.Item.FindControl("labelCityEnd") as Label;
if (labelCityEnd != null)
{
if (tour.CityEnd != null)
{
labelCityEnd.Text = tour.CityEnd.Name;
}
else
{
if (tour.EndIn != null)
{
labelCityEnd.Text = tour.EndIn.Name;
}
}
}
Label labelTourType = e.Item.FindControl("labelTourType") as Label;
if (labelTourType != null)
{
if (tour.TourType != null)
{
labelTourType.Text = tour.TourType.Name;
}
}
#endregion
#region Days
Label labelNumberOfDays = e.Item.FindControl("labelNumberOfDays") as Label;
if (labelNumberOfDays != null)
{
if (tour.IsHalf)
{
labelNumberOfDays.Text = "½ day";
}
else
{
if (tour.NumberOfDay > 1)
{
labelNumberOfDays.Text = tour.NumberOfDay + " days";
}
else
{
labelNumberOfDays.Text = "1 day";
}
}
}
#endregion
#region HyperLink Edit
HyperLink hplEdit = e.Item.FindControl("hplEdit") as HyperLink;
Image imageEdit = e.Item.FindControl("imageEdit") as Image;
if (hplEdit != null && imageEdit != null)
{
if (UserIdentity.CanModify(Section))
{
hplEdit.NavigateUrl = string.Format("TourEdit.aspx?NodeId={0}&SectionId={1}&TourId={2}", Node.Id,
Section.Id, tour.Id);
}
else
{
hplEdit.Visible = false;
imageEdit.Visible = false;
}
}
#endregion
#region Button Delete
ImageButton btnDelete = e.Item.FindControl("btnDelete") as ImageButton;
if (btnDelete != null)
{
if (!UserIdentity.CanDelete(Section))
{
btnDelete.Visible = false;
}
}
#endregion
}
}
public IList TourSearchByQueryString(NameValueCollection queryString)
{
ICriterion criterion = Expression.Eq("Deleted", false);
criterion = Expression.And(criterion,
Expression.Or(Expression.IsNull(Tour.PACKAGESTATUS),
Expression.Not(Expression.Eq(Tour.PACKAGESTATUS,
PackageStatus.PartPackage))));
if (!string.IsNullOrEmpty(queryString["Name"]))
{
criterion = Expression.And(criterion, Expression.Like("Name", queryString["Name"], MatchMode.Anywhere));
}
#region -- Location --
Location start = null;
if (!string.IsNullOrEmpty(queryString["StartId"]) && Convert.ToInt32(queryString["StartId"]) > 0)
{
start = LocationGetById(Convert.ToInt32(queryString["StartId"]));
}
Location end = null;
if (!string.IsNullOrEmpty(queryString["EndId"]) && Convert.ToInt32(queryString["EndId"]) > 0)
{
end = LocationGetById(Convert.ToInt32(queryString["EndId"]));
}
if (start != null)
{
switch (start.Level)
{
case 3:
criterion = Expression.And(criterion, Expression.Eq("CountryStart", start));
break;
case 4:
criterion = Expression.And(criterion, Expression.Eq("RegionStart", start));
break;
case 5:
criterion = Expression.And(criterion, Expression.Eq("CityStart", start));
break;
default: //Chưa sử lý nếu Level>5. Để mặc định load ra Location
criterion = Expression.And(criterion, Expression.Eq("StartFrom", start));
break;
}
}
if (end != null)
{
switch (end.Level)
{
case 3:
criterion = Expression.And(criterion, Expression.Eq("CountryEnd", end));
break;
case 4:
criterion = Expression.And(criterion, Expression.Eq("RegionEnd", end));
break;
case 5:
criterion = Expression.And(criterion, Expression.Eq("CityEnd", end));
break;
default: //Chưa sử lý nếu Level>5. Để mặc định load ra Location
criterion = Expression.And(criterion, Expression.Eq("EndIn", end));
break;
}
}
#endregion
if (!string.IsNullOrEmpty(queryString["Type"]))
{
TourType type = TourTypeGetById(Convert.ToInt32(queryString["Type"]));
criterion = Expression.And(criterion, Expression.Eq("TourType", type));
}
if (!string.IsNullOrEmpty(queryString["TimeLt"]))
{
criterion = Expression.And(criterion, Expression.Lt("NumberOfDay", Convert.ToInt32(queryString["TimeLt"])));
}
if (!string.IsNullOrEmpty(queryString["TimeGt"]))
{
criterion = Expression.And(criterion, Expression.Gt("NumberOfDay", Convert.ToInt32(queryString["TimeGt"])));
}
if (!string.IsNullOrEmpty(queryString["LengthLt"]))
{
criterion = Expression.And(criterion, Expression.Lt("LengthTrip", Convert.ToInt32(queryString["LengthLt"])));
}
if (!string.IsNullOrEmpty(queryString["LengthGt"]))
{
criterion = Expression.And(criterion, Expression.Gt("LengthTrip", Convert.ToInt32(queryString["LengthGt"])));
}
Order order = RepeaterOrder.GetOrderFromQueryString(queryString);
if (!string.IsNullOrEmpty(queryString["Region"]))
{
TourRegion region = TourRegionGetById(Convert.ToInt32(queryString["Region"]));
return(_tourDao.TourSearch(criterion, order, region, 0));
}
return(_tourDao.TourSearch(criterion, order, 0));
}
private void LoadData()
{
PenggunaLogin Pengguna = (PenggunaLogin)Session["PenggunaLogin"];
Konfigurasi_Class Konfigurasi_Class = new Konfigurasi_Class(Pengguna.IDGrupPengguna);
DateTime[] BulanIni = new DateTime[2];
DateTime[] BulanLalu = new DateTime[2];
DateTime[] HariIni = new DateTime[2];
DateTime[] Kemarin = new DateTime[2];
BulanIni = Pengaturan.BulanIni();
BulanLalu = Pengaturan.BulanSebelumnya();
HariIni = Pengaturan.HariIni();
Kemarin = Pengaturan.HariSebelumnya();
#region Aktifitas Transaksi
if (Konfigurasi_Class.ValidasiKonfigurasi(EnumKonfigurasi.AktifitasTransaksi))
{
PanelAktifitasTransaksi1.Visible = true;
//////PanelAktifitasTransaksi2.Visible = true;
PanelAktifitasTransaksi3.Visible = true;
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
var _transaksi = db.TBTransaksis
.Where(item => item.IDTempat == Pengguna.IDTempat &&
item.TanggalOperasional.Value.Date >= BulanLalu[0] &&
item.TanggalOperasional.Value.Date <= BulanIni[1] &&
item.IDStatusTransaksi == (int)EnumStatusTransaksi.Complete)
.Select(item => new
{
item.IDTempat,
item.TanggalOperasional,
item.JumlahProduk,
item.GrandTotal
}).ToArray();
var _transaksiHariIni = _transaksi
.Where(item =>
item.TanggalOperasional.Value.Date >= HariIni[0] &&
item.TanggalOperasional.Value.Date <= HariIni[1]).ToArray();
var _transaksiKemarin = _transaksi
.Where(item =>
item.TanggalOperasional.Value.Date >= Kemarin[0] &&
item.TanggalOperasional.Value.Date <= Kemarin[1]).ToArray();
var _pelanggan = db.TBPelanggans
.Where(item =>
item.TanggalDaftar.Value.Date >= BulanLalu[0] &&
item.TanggalDaftar.Value.Date <= BulanIni[1]).ToArray();
var _pelangganBulanLalu = db.TBPelanggans
.Where(item =>
item.TanggalDaftar.Value.Date >= BulanLalu[0] &&
item.TanggalDaftar.Value.Date <= BulanLalu[1]).Count();
#region GRAFIK TRANSAKSI
string ResultTransaksi = string.Empty;
var _dataTransaksi = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanIni[0] && item.TanggalOperasional.Value.Date <= BulanIni[1])
.GroupBy(item => item.TanggalOperasional.Value.Day)
.Select(item => new
{
Key = item.Key,
GrandTotal = item.Sum(item2 => item2.GrandTotal) ?? 0
}).ToArray();
Random rd = new Random();
string[] labelsXTanggal = Manage.GetRangeDayOfMonth(Manage.GetJamServer());
ReportChart_Class ClassReport = new ReportChart_Class();
ReportChartLine_Class LineSingle = new ReportChartLine_Class();
LineSingle.Label = "My dataset";
LineSingle.Color = Manage.GetHexadecimalSAP(EnumColorSAP.Hue1);
LineSingle.Data = new List <string>();
foreach (var item in labelsXTanggal)
{
if (_dataTransaksi.FirstOrDefault(item2 => item2.Key.ToString() == item) != null)
{
LineSingle.Data.Add(_dataTransaksi.FirstOrDefault(item2 => item2.Key.ToString() == item).GrandTotal.ToString());
}
else
{
LineSingle.Data.Add("0");
}
}
LiteralChartPenjualan.Text = ClassReport.GetChartTrendAnalysis("CanvasChartPenjualan", string.Empty, "Tanggal", "Sales", labelsXTanggal, LineSingle);
#endregion
#region GRAFIK TRANSAKSI PELANGGAN
//LiteralChart.Text += "<script> $(function () { var dataChart = [";
//var dataTransaksi = _transaksiBulanIni
// .GroupBy(item => item.TanggalOperasional.Value.Date)
// .Select(item => new
// {
// Key = item.Key,
// Jumlah = item.Count()
// }).ToArray();
//var dataPelanggan = _pelangganBulanIni
// .GroupBy(item => item.TanggalDaftar.Value.Date)
// .Select(item => new
// {
// Key = item.Key,
// Jumlah = item.Count()
// }).ToArray();
//for (DateTime date = BulanIni[0]; date <= BulanIni[1]; date = date.AddDays(1))
//{
// var _transaksi = dataTransaksi.FirstOrDefault(item => item.Key.Date == date.Date);
// int _jumlahTransaksi = 0;
// if (_transaksi != null)
// _jumlahTransaksi = _transaksi.Jumlah;
// var _pelanggan = dataPelanggan.FirstOrDefault(item => item.Key.Date == date.Date);
// int _jumlahPelanggan = 0;
// if (_pelanggan != null)
// _jumlahPelanggan = _pelanggan.Jumlah;
// LiteralChart.Text += "{ 'y': '" + date.Day + "', 'Transaksi': " + _jumlahTransaksi + ", 'Pelanggan': " + _jumlahPelanggan + " },";
//}
//LiteralChart.Text += "]; Morris.Line({ element: 'graph', data: dataChart, xkey: 'y',";
//LiteralChart.Text += "ykeys: ['Transaksi', 'Pelanggan'],";
//LiteralChart.Text += "labels: ['Transaksi', 'Pelanggan'],";
//LiteralChart.Text += "lineColors:['#0aa699','#d1dade'],";
//LiteralChart.Text += " parseTime: false}); eval(dataChart); });";
//LiteralChart.Text += "</script>";
#endregion
LabelPenjualanBulanIni.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanIni[0] && item.TanggalOperasional.Value.Date <= BulanIni[1]).Sum(item => item.GrandTotal).ToFormatHarga();
LabelQuantityBulanIni.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanIni[0] && item.TanggalOperasional.Value.Date <= BulanIni[1]).Sum(item => item.JumlahProduk).ToFormatHargaBulat();
LabelPelangganBulanIni.Text = _pelanggan.Where(item => item.TanggalDaftar.Value.Date >= BulanIni[0] && item.TanggalDaftar.Value.Date <= BulanIni[1]).Count().ToFormatHargaBulat();
LabelTransaksiBulanIni.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanIni[0] && item.TanggalOperasional.Value.Date <= BulanIni[1]).Count().ToFormatHargaBulat();
LabelPenjualanBulanLalu.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanLalu[0] && item.TanggalOperasional.Value.Date <= BulanLalu[1]).Sum(item => item.GrandTotal).ToFormatHarga();
LabelQuantityBulanLalu.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanLalu[0] && item.TanggalOperasional.Value.Date <= BulanLalu[1]).Sum(item => item.JumlahProduk).ToFormatHargaBulat();
LabelPelangganBulanLalu.Text = _pelanggan.Where(item => item.TanggalDaftar.Value.Date >= BulanLalu[0] && item.TanggalDaftar.Value.Date <= BulanLalu[1]).ToFormatHargaBulat();
LabelTransaksiBulanLalu.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanLalu[0] && item.TanggalOperasional.Value.Date <= BulanLalu[1]).Count().ToFormatHargaBulat();
LabelPenjualanHariIni.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= HariIni[0] && item.TanggalOperasional.Value.Date <= HariIni[1]).Sum(item => item.GrandTotal).ToFormatHarga();
LabelQuantityHariIni.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= HariIni[0] && item.TanggalOperasional.Value.Date <= HariIni[1]).Sum(item => item.JumlahProduk).ToFormatHargaBulat();
LabelPelangganHariIni.Text = _pelanggan.Where(item => item.TanggalDaftar.Value.Date >= HariIni[0] && item.TanggalDaftar.Value.Date <= HariIni[1]).Count().ToFormatHargaBulat();
LabelTransaksiHariIni.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= HariIni[0] && item.TanggalOperasional.Value.Date <= HariIni[1]).Count().ToFormatHargaBulat();
LabelPenjualanKemarin.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= Kemarin[0] && item.TanggalOperasional.Value.Date <= Kemarin[1]).Sum(item => item.GrandTotal).ToFormatHarga();
LabelQuantityKemarin.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= Kemarin[0] && item.TanggalOperasional.Value.Date <= Kemarin[1]).Sum(item => item.JumlahProduk).ToFormatHargaBulat();
LabelPelangganKemarin.Text = _pelanggan.Where(item => item.TanggalDaftar.Value.Date >= Kemarin[0] && item.TanggalDaftar.Value.Date <= Kemarin[1]).Count().ToFormatHargaBulat();
LabelTransaksiKemarin.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= Kemarin[0] && item.TanggalOperasional.Value.Date <= Kemarin[1]).Count().ToFormatHargaBulat();
}
}
else
{
PanelAktifitasTransaksi1.Visible = false;
//////PanelAktifitasTransaksi2.Visible = false;
PanelAktifitasTransaksi3.Visible = false;
}
#endregion
#region Transaksi Terakhir
if (Konfigurasi_Class.ValidasiKonfigurasi(EnumKonfigurasi.TransaksiTerakhir))
{
panelTransaksiTerakhir.Visible = true;
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
var TransaksiTerakhir = db.TBTransaksis
.Where(item => item.IDStatusTransaksi.HasValue && item.IDTempat == Pengguna.IDTempat)
.Select(item => new
{
item.IDTransaksi,
item.IDTempat,
item.Nomor,
item.TanggalTransaksi,
Persentase = Persentase(item.IDStatusTransaksi.Value, item.TBStatusTransaksi.Nama),
item.JumlahProduk,
item.GrandTotal
}).OrderByDescending(item => item.Nomor).Take(10).ToArray();
RepeaterOrder.DataSource = TransaksiTerakhir;
RepeaterOrder.DataBind();
}
}
else
{
panelTransaksiTerakhir.Visible = false;
}
#endregion
LoadStokHabis(Konfigurasi_Class);
#region PO Bahan BakuJatuh Tempo
if (Konfigurasi_Class.ValidasiKonfigurasi(EnumKonfigurasi.POBahanBakuJatuhTempo))
{
PanelPOBahanBakuJatuhTempo.Visible = true;
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
decimal batas = db.TBStoreKonfigurasis.FirstOrDefault(item => item.IDStoreKonfigurasi == (int)EnumStoreKonfigurasi.JumlahHariSebelumJatuhTempo).Pengaturan.ToDecimal();
RepeaterPOBahanBakuJatuhTempo.DataSource = db.TBPOProduksiBahanBakus
.Where(item => item.IDTempat == Pengguna.IDTempat && item.EnumJenisProduksi != (int)PilihanEnumJenisProduksi.ProduksiSendiri && ((int)((item.TanggalJatuhTempo.Value.Date - DateTime.Now.Date).TotalDays) < batas))
.Select(item => new
{
ClassWarna = Warna((int)((item.TanggalJatuhTempo.Value.Date - DateTime.Now.Date).TotalDays), batas),
item.IDPOProduksiBahanBaku,
item.TBSupplier.Nama,
item.Tanggal,
item.TanggalJatuhTempo,
})
.OrderBy(item => item.Tanggal)
.ToArray();
RepeaterPOBahanBakuJatuhTempo.DataBind();
}
}
else
{
PanelPOBahanBakuJatuhTempo.Visible = false;
}
#endregion
#region PO Bahan BakuJatuh Tempo
if (Konfigurasi_Class.ValidasiKonfigurasi(EnumKonfigurasi.POProdukJatuhTempo))
{
PanelPOBahanBakuJatuhTempo.Visible = true;
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
decimal batas = db.TBStoreKonfigurasis.FirstOrDefault(item => item.IDStoreKonfigurasi == (int)EnumStoreKonfigurasi.JumlahHariSebelumJatuhTempo).Pengaturan.ToDecimal();
RepeaterPOProdukJatuhTempo.DataSource = db.TBPOProduksiProduks
.Where(item => item.IDTempat == Pengguna.IDTempat && item.EnumJenisProduksi != (int)PilihanEnumJenisProduksi.ProduksiSendiri && ((int)((item.TanggalJatuhTempo.Value.Date - DateTime.Now.Date).TotalDays) < batas))
.Select(item => new
{
ClassWarna = Warna((int)((item.TanggalJatuhTempo.Value.Date - DateTime.Now.Date).TotalDays), batas),
item.IDPOProduksiProduk,
item.TBVendor.Nama,
item.Tanggal,
item.TanggalJatuhTempo
})
.OrderBy(item => item.Tanggal)
.ToArray();
RepeaterPOProdukJatuhTempo.DataBind();
}
}
else
{
PanelPOProdukJatuhTempo.Visible = false;
}
#endregion
}
protected virtual void rptProvider_OnItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.DataItem is Provider)
{
Provider item = e.Item.DataItem as Provider;
if (item != null)
{
#region - HyperLink Name -
using (HyperLink hyperLinkName = e.Item.FindControl("hyperLinkName") as HyperLink)
{
if (hyperLinkName != null)
{
hyperLinkName.Text = item.Name;
hyperLinkName.NavigateUrl = "#";
}
}
#endregion
#region - Label Address -
using (Label labelProviderAddress = e.Item.FindControl("labelProviderAddress") as Label)
{
if (labelProviderAddress != null)
{
labelProviderAddress.Text = item.Address;
}
}
#endregion
#region - Location -
using (Label labelProviderLocation = e.Item.FindControl("labelProviderLocation") as Label)
{
if (labelProviderLocation != null)
{
string strLocation = "";
strLocation += item.Location.Name;
Location _location = item.Location;
while (true)
{
if (_location.Parent != null)
{
_location = _location.Parent;
strLocation += ", " + _location.Name;
}
else
{
break;
}
}
labelProviderLocation.Text = strLocation;
}
}
#endregion
#region - Featured -
using (CheckBox checkBoxFeatured = e.Item.FindControl("checkBoxFeatured") as CheckBox)
{
Label labelProviderFeatured = e.Item.FindControl("labelProviderFeatured") as Label;
if (labelProviderFeatured != null && checkBoxFeatured != null)
{
checkBoxFeatured.Checked = item.Featured;
checkBoxFeatured.Enabled = false;
labelProviderFeatured.Text = string.Format(Resources.labelProviderFeatured, item.IsFeatured);
}
}
#endregion
#region - HyperLink Edit -
using (HyperLink hyperLinkEdit = e.Item.FindControl("hyperLinkEdit") as HyperLink)
{
if (hyperLinkEdit != null)
{
hyperLinkEdit.NavigateUrl =
string.Format("/Modules/TourManagement/Admin/ProviderEdit.aspx?NodeId={0}&SectionId={1}&ProviderID={2}", Node.Id,
Section.Id, item.Id);
}
}
#endregion
}
}
if (e.Item.ItemType == ListItemType.Header)
{
RepeaterOrder.FILE_NAME = "ProviderList.aspx";
RepeaterOrder.SetOrderLink(e, Provider.NAME, Request.QueryString);
RepeaterOrder.SetOrderLink(e, Provider.ADDRESS, Request.QueryString);
RepeaterOrder.SetOrderLink(e, Provider.LOCATION, Request.QueryString);
RepeaterOrder.SetOrderLink(e, Provider.ISFEATURED, Request.QueryString);
}
}
