public static Hospital GetFirst() { RedBloodDataContext db = new RedBloodDataContext(); return (from s in db.Hospitals select s).FirstOrDefault(); }
protected void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e) { RedBloodDataContext db = new RedBloodDataContext(); e.Result = db.vw_ProductCounts.Where(r => r.Status == Pack.StatusX.Product) .ToList() .GroupBy(r => new { r.ProductCode, r.ProductDesc, r.Status }, (r, sub) => new { r.ProductCode, r.ProductDesc, r.Status, Total = sub.Sum(r1 => r1.Count), TotalExpired = sub.Where(r1 => r1.ExpirationDate.Value.Expired()) .Sum(r1 => r1.Count).ToStringRemoveZero(), TotalExpiredInDays = sub.Where(r1 => r1.ExpirationDate.Value.ExpiredInDays(ExpiredInDays)) .Sum(r1 => r1.Count).ToStringRemoveZero(), TotalTRNA = sub.Where(r1 => r1.TestResultStatus == Donation.TestResultStatusX.Non) .Sum(r1 => r1.Count).ToStringRemoveZero(), TotalTRNeg = sub.Where(r1 => r1.TestResultStatus == Donation.TestResultStatusX.Negative) .Sum(r1 => r1.Count).ToStringRemoveZero(), TotalTRPos = sub.Where(r1 => r1.TestResultStatus == Donation.TestResultStatusX.Positive) .Sum(r1 => r1.Count).ToStringRemoveZero(), BloodGroupSumary = sub.GroupBy(r1 => r1.BloodGroup, (r1, BGSub) => new { BloodGroupDesc = BloodGroupBLL.GetDescription(r1), Total = BGSub.Sum(r3 => r3.Count) }), VolumeSumary = sub.GroupBy(r1 => r1.Volume, (r1, VolSub) => new { Volume = r1.HasValue ? r1.Value.ToString() : "_", Total = VolSub.Sum(r3 => r3.Count) }) }) .OrderBy(r => r.ProductDesc); }
protected void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e) { ucDateRange.Validated(); RedBloodDataContext db = new RedBloodDataContext(); e.Result = db.Campaigns.Where(r => r.Type == Campaign.TypeX.Short_run && ucDateRange.FromDate <= r.Date && r.Date <= ucDateRange.ToDate && r.CoopOrg.GeoID1 == ProvinceID) .ToList() .Select(r => new { CoopOrg = r.CoopOrg.Name, HostOrg = r.HostOrg.Name, r.Date, Total = r.CollectedDonations.Count(), Total450 = r.CollectedDonations.Where(r2 => r2.Pack.Volume == 450).Count().ToStringRemoveZero(), Total350 = r.CollectedDonations.Where(r2 => r2.Pack.Volume == 350).Count().ToStringRemoveZero(), Total250 = r.CollectedDonations.Where(r2 => r2.Pack.Volume == 250).Count().ToStringRemoveZero(), TotalXXX = r.CollectedDonations.Where(r2 => r2.Pack.Volume != 250 && r2.Pack.Volume != 350 && r2.Pack.Volume != 450).Count().ToStringRemoveZero(), TotalPos = r.CollectedDonations.Where(r2 => r2.TestResultStatus == Donation.TestResultStatusX.Positive).Count().ToStringRemoveZero(), TotalNeg = r.CollectedDonations.Where(r2 => r2.TestResultStatus == Donation.TestResultStatusX.Negative).Count().ToStringRemoveZero(), TotalNon = r.CollectedDonations.Where(r2 => r2.TestResultStatus == Donation.TestResultStatusX.Non).Count().ToStringRemoveZero(), TotalMiss = r.Donations.Where(r2 => r2.Pack == null).Count().ToStringRemoveZero() }) .OrderBy(r => r.Date); }
protected void btnSave_Click(object sender, EventArgs e) { RedBloodDataContext db = new RedBloodDataContext(); Donation d = DonationBLL.Get(db, DIN); if (d == null) { Clear(); } else { //TODO: Check to see too late to update // Code check will be here d.Collector = txtCollector.Text.Trim(); if (d.Pack != null) { d.Pack.Volume = txtVolume.Text.ToInt(); d.Pack.Note = txtNote.Text.Trim(); } d.Note = txtNote.Text.Trim(); db.SubmitChanges(); this.Alert("Lưu thành công."); } }
public List<string> AddDIN(string DIN) { if (DINInList.Contains(DIN)) throw new Exception("Mã túi máu này đã có."); Donation d = DonationBLL.Get(DIN); if (d == null) throw new Exception("Không có mã túi máu này."); if (d.TestResultStatus == Donation.TestResultStatusX.Positive) { throw new Exception("Xét nghiệm sàng lọc: Dương tính."); } RedBloodDataContext db = new RedBloodDataContext(); int count = db.Packs.Where(r => ProductCodeInList.Contains(r.ProductCode) && r.DIN == DIN).Count(); if (count == 0) throw new Exception("Mã túi máu này không có sản phẩm đầu vào."); count = db.Packs.Where(r => ProductCodeOutList.Contains(r.ProductCode) && r.DIN == DIN).Count(); if (count > 0) throw new Exception("Mã túi máu này đã có sản phẩm đầu ra."); DINInList.Add(DIN); return DINInList; }
protected void LinqDataSourceStart_Selecting(object sender, LinqDataSourceSelectEventArgs e) { ucDateRange.Validated(); RedBloodDataContext db = new RedBloodDataContext(); e.Result = db.Campaigns.Where(r => r.Type == Campaign.TypeX.Short_run && ucDateRange.FromDate <= r.Date && r.Date <= ucDateRange.ToDate) .ToList() .GroupBy(r => new { r.CoopOrg.Geo1 }, (r, sub) => new { Province = r.Geo1.Fullname, Url = RedBloodSystem.Url4CollectRpt11 + "ProvinceID=" + r.Geo1.ID.ToString() + "&from=" + ucDateRange.FromDate.Value.Date.ToShortDateString() + "&to=" + ucDateRange.ToDate.Value.Date.ToShortDateString(), Total = sub.Sum(r1 => r1.CollectedDonations.Count()), Total450 = sub.Sum(r1 => r1.CollectedDonations.Where(r2 => r2.Pack.Volume == 450).Count()).ToStringRemoveZero(), Total350 = sub.Sum(r1 => r1.CollectedDonations.Where(r2 => r2.Pack.Volume == 350).Count()).ToStringRemoveZero(), Total250 = sub.Sum(r1 => r1.CollectedDonations.Where(r2 => r2.Pack.Volume == 250).Count()).ToStringRemoveZero(), TotalXXX = sub.Sum(r1 => r1.CollectedDonations.Where(r2 => r2.Pack.Volume != 250 && r2.Pack.Volume != 350 && r2.Pack.Volume != 450).Count()).ToStringRemoveZero(), TotalPos = sub.Sum(r1 => r1.CollectedDonations.Where(r2 => r2.TestResultStatus == Donation.TestResultStatusX.Positive).Count()).ToStringRemoveZero(), TotalNeg = sub.Sum(r1 => r1.CollectedDonations.Where(r2 => r2.TestResultStatus == Donation.TestResultStatusX.Negative).Count()).ToStringRemoveZero(), TotalNon = sub.Sum(r1 => r1.CollectedDonations.Where(r2 => r2.TestResultStatus == Donation.TestResultStatusX.Non).Count()).ToStringRemoveZero(), TotalMiss = sub.Sum(r1 => r1.Donations.Where(r2 => r2.Pack == null).Count()).ToStringRemoveZero() }) .OrderBy(r => r.Province); }
protected void LinqDataSourceRpt_Selecting(object sender, LinqDataSourceSelectEventArgs e) { ucDateRange.Validated(); RedBloodDataContext db = new RedBloodDataContext(); e.Result = db.Campaigns.Where(r => ucDateRange.FromDate <= r.Date && r.Date <= ucDateRange.ToDate) .ToList() .Select(r => new { r.ID, Url = RedBloodSystem.Url4CollectRpt920 + "CampaignID=" + r.ID.ToString(), r.Name, r.Date, Total = r.CollectedDonations.Count(), HostName = r.HostOrg.Name, CoopName = r.CoopOrg.Name, TestResultPos = RedBloodSystem.checkingInfection.Select(r1 => new { r1.Name, Total = r.Donations.Where(r2 => r1.Decode(r2.InfectiousMarkers) == TR.pos.Name).Count() }).Where(r1 => r1.Total > 0), TestResultNA = RedBloodSystem.checkingInfection.Select(r1 => new { r1.Name, Total = r.Donations.Where(r2 => r1.Decode(r2.InfectiousMarkers) == TR.na.Name).Count() }).Where(r1 => r1.Total > 0), BloodGroupSumary = r.Donations.GroupBy(r1 => r1.BloodGroup, (r2, BGSub) => new { BloodGroupDesc = BloodGroupBLL.GetDescription(r2), Total = BGSub.Count() }) }); }
public static DonationErr Assign(string DIN, Guid peopleID, int campaignID, DateTime? collectedDate, string actor) { RedBloodDataContext db = new RedBloodDataContext(); Donation d = (from c in db.Donations where c.DIN == DIN && c.PeopleID == null && c.CampaignID == null select c).FirstOrDefault(); if (d == null) { return DonationErrEnum.NonExist; } try { d.PeopleID = peopleID; d.CollectedDate = collectedDate; d.CampaignID = campaignID; d.Actor = actor; UpdateStatus(db, d, Donation.StatusX.Assigned, "Assign peopleID=" + peopleID.ToString() + "&CampaignID=" + campaignID.ToString()); db.SubmitChanges(); CampaignBLL.SetStatus(campaignID); } catch (Exception ex) { return new DonationErr(ex.Message); } return DonationErrEnum.Non; }
protected void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e) { RedBloodDataContext db = new RedBloodDataContext(); e.Result = db.Packs.Where(r => r.Status == Pack.StatusX.Product && r.ProductCode == ProductCode && (TR == Donation.TestResultStatusX.All || r.Donation.TestResultStatus == TR) ) //.ToList() .Select(r => new { r.DIN, r.Donation.TestResultStatus, r.Donation.BloodGroup, r.Volume, r.ExpirationDate, }) .ToList() .Select(r => new { r.DIN, r.TestResultStatus, BloodGroupDesc = BloodGroupBLL.GetDescription(r.BloodGroup), r.Volume, ExpirationDate = r.ExpirationDate.ToStringVN_Hour(), Expired = r.ExpirationDate.Value.Expired() ? "X" : "", ExpiredInDays = r.ExpirationDate.Value.ExpiredInDays(ExpiredInDays) ? "X" : "" }) .OrderBy(r => r.TestResultStatus).ThenBy(r => r.DIN); }
protected void LinqDataSourceIn_Selecting(object sender, LinqDataSourceSelectEventArgs e) { ucDateRange.Validated(); RedBloodDataContext db = new RedBloodDataContext(); e.Result = db.vw_PackTrans.Where(r => PackTransactionBLL.InTypeList.Contains(r.Type) && ucDateRange.FromDate <= r.Date && r.Date <= ucDateRange.ToDate) .ToList() .GroupBy(r => new { r.ProductCode, r.ProductDesc }, (r, sub) => new { r.ProductCode, r.ProductDesc, Total = sub.Sum(r1 => r1.Count), TotalInCollect = sub.Where(r1 => r1.Type == PackTransaction.TypeX.In_Collect) .Sum(r1 => r1.Count), TotalInProduct = sub.Where(r1 => r1.Type == PackTransaction.TypeX.In_Product) .Sum(r1 => r1.Count), TotalInReturn = sub.Where(r1 => r1.Type == PackTransaction.TypeX.In_Return) .Sum(r1 => r1.Count), BloodGroupSumary = sub.GroupBy(r1 => r1.BloodGroup, (r1, BGSub) => new { BloodGroupDesc = BloodGroupBLL.GetDescription(r1), Total = BGSub.Sum(r3 => r3.Count) }), VolumeSumary = sub.GroupBy(r1 => r1.Volume, (r1, VolSub) => new { Volume = r1, Total = VolSub.Sum(r3 => r3.Count) }) }) .OrderBy(r => r.ProductDesc); }
public static void Backup(DateTime date) { Validate(date); string err = "Process for day: " + date.Date.ToShortDateString() + ". "; RedBloodDataContext db = new RedBloodDataContext(); if (db.PackRemainDailies.Where(r => r.Date.Value.Date == date.Date).Count() > 0) { LogBLL.LogsFailAndThrow(err + "Existing data."); } IQueryable<Pack> rows = db.Packs.Where(r => r.Status == Pack.StatusX.Product); //Insert foreach (Pack item in rows) { PackRemainDaily r = new PackRemainDaily(); r.PackID = item.ID; r.Status = item.Status; r.Date = date; r.Note = "Process on: " + DateTime.Now.ToString(); db.PackRemainDailies.InsertOnSubmit(r); } db.SubmitChanges(); LogBLL.Logs(); }
protected void LinqDataSourceEnd_Selecting(object sender, LinqDataSourceSelectEventArgs e) { ucDateRange.Validated(); RedBloodDataContext db = new RedBloodDataContext(); e.Result = db.vw_PackRemainDailies.Where(r => r.Date == ucDateRange.ToDate) .ToList() .GroupBy(r => new { r.ProductCode, r.ProductDesc }, (r, sub) => new { r.ProductCode, r.ProductDesc, Total = sub.Sum(r1 => r1.Count), BloodGroupSumary = sub.GroupBy(r1 => r1.BloodGroup, (r1, BGSub) => new { BloodGroupDesc = BloodGroupBLL.GetDescription(r1), Total = BGSub.Sum(r3 => r3.Count) }), VolumeSumary = sub.GroupBy(r1 => r1.Volume, (r1, VolSub) => new { Volume = r1, Total = VolSub.Sum(r3 => r3.Count) }) }) .OrderBy(r => r.ProductDesc); }
public static bool IsLogged(string method, DateTime date) { RedBloodDataContext db = new RedBloodDataContext(); //return db.Logs.Count(r => r.Method == method && r.Date.Value.Date == date) > 0; return db.Logs.Any(r => r.Method == method && r.Date.Value.Date == date); }
public static void UpdateStatus(RedBloodDataContext db, Guid packID, string note = "") { var p = PackDAL.Get(db, packID); var v = p.Donation; //Check Packs.Count is better than check Original Pack. //Sometime DIN has Pack but not update Original Pack yet. //Ex. Add Pack => Add Pack Status => Update DIN Status => Update Orginal Pack if (v.Packs.Count == 0) { if (v.People == null) { UpdateStatus(db, v.DIN, Donation.StatusX.Init, note); } else { UpdateStatus(db, v.DIN, Donation.StatusX.Assigned, note); } } else { if (v.Packs.Any(r => r.Status == Pack.StatusX.Delivered)) { UpdateStatus(db, v.DIN, Donation.StatusX.HasPack_Lock, note); } else { UpdateStatus(db, v.DIN, Donation.StatusX.HasPack_UnLock, note); } } //db.SubmitChanges(); }
public static TestDef Get(RedBloodDataContext db, int ID) { List<int> l = new List<int>(); l.Add(ID); return Get(db, l).FirstOrDefault(); }
public static void Add(int orderID, string DIN, string productCode) { //using (TransactionScope scope = new TransactionScope()) //{ // scope.Complete(); //} RedBloodDataContext db = new RedBloodDataContext(); Order r = OrderBLL.Get4Add(orderID); Pack p = PackBLL.Get4Order(DIN, productCode); var check_po = db.PackOrders.FirstOrDefault(r1 => r1.PackID == p.ID && r1.OrderID == r.ID && r1.ReturnID == null); if (check_po == null) { PackOrder po = new PackOrder(); po.OrderID = r.ID; po.PackID = p.ID; db.PackOrders.InsertOnSubmit(po); db.SubmitChanges(); PackTransaction.TypeX transType = r.Type == Order.TypeX.ForCR ? PackTransaction.TypeX.Out_Order4CR : r.Type == Order.TypeX.ForOrg ? PackTransaction.TypeX.Out_Order4Org : PackTransaction.TypeX.Out_OrderGen; PackBLL.ChangeStatus(p.ID, Pack.StatusX.Delivered, transType, "PackOrderID = " + po.ID.ToString()); } else { throw new Exception("Túi máu đã có trong đợt cấp phát này."); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { RedBloodDataContext db = new RedBloodDataContext(); List<Guid> geo1List = new List<Guid>(); geo1List.Add(Geo.BinhDuong); geo1List.Add(Geo.BRVT); geo1List.Add(Geo.DongNai); geo1List.Add(Geo.TayNinh); geo1List.Add(Geo.HCMC); CheckBoxListGeo1.DataSource = db.Geos.Where(r => geo1List.Contains(r.ID)); CheckBoxListGeo1.DataBind(); foreach (ListItem item in CheckBoxListGeo1.Items) { item.Selected = true; } List<int> sourceList = new List<int>(); sourceList.Add(TestDef.Source.Donation); sourceList.Add(TestDef.Source.RedCross); sourceList.Add(TestDef.Source.Other); CheckBoxListSource.DataSource = db.TestDefs.Where(r => sourceList.Contains(r.ID)); CheckBoxListSource.DataBind(); foreach (ListItem item in CheckBoxListSource.Items) { item.Selected = true; } } }
public void Delete_Route(TestDef c, RedBloodDataContext db) { foreach (TestDef e in c.Children) { Delete_Route(e, db); } db.TestDefs.DeleteOnSubmit(c); }
public static Facility Get(string FIN) { RedBloodDataContext db = new RedBloodDataContext(); return (from s in db.Facilities where s.FIN == FIN select s).FirstOrDefault(); }
public static Hospital Get(Guid ID) { RedBloodDataContext db = new RedBloodDataContext(); return (from s in db.Hospitals where s.ID == ID select s).FirstOrDefault(); }
public static Department GetByFullnameAndLevel(string fullname, int lvl) { RedBloodDataContext db = new RedBloodDataContext(); return (from e in db.Departments where e.Level.Value == lvl && e.Fullname == fullname.Trim() select e).FirstOrDefault(); }
public static Donation Get(RedBloodDataContext db, string DIN) { Donation d = db.Donations.Where(r => r.DIN == DIN).FirstOrDefault(); if (d == null) throw new Exception("Chưa tạo mã túi máu."); return d; }
public static SideEffect GetByFullname(string fullname) { RedBloodDataContext db = new RedBloodDataContext(); return (from e in db.SideEffects where e.Fullname.ToLower() == fullname.Trim().ToLower() select e).FirstOrDefault(); }
public static void Delete(int ID) { RedBloodDataContext db = new RedBloodDataContext(); Campaign e = Get(ID, db); db.Campaigns.DeleteOnSubmit(e); db.SubmitChanges(); }
public static SideEffect GetByName(string name, int level) { RedBloodDataContext db = new RedBloodDataContext(); return (from e in db.SideEffects where e.Name.ToLower() == name.Trim().ToLower() && e.Level == level select e).FirstOrDefault(); }
public static Delete Get(int ID, RedBloodDataContext db) { Delete e = db.Deletes.Where(r => r.ID == ID).FirstOrDefault(); if (e == null) throw new Exception("Không tìm thấy đợt hủy."); return e; }
public static void Delete(Guid ID) { RedBloodDataContext db = new RedBloodDataContext(); Receipt e = Get(ID, db); db.Receipts.DeleteOnSubmit(e); db.SubmitChanges(); }
public static PackOrder Get(RedBloodDataContext db, int ID) { PackOrder r = db.PackOrders.Where(r1 => r1.ID == ID).FirstOrDefault(); if (r == null) throw new Exception("Chưa có cấp phát túi máu này."); return r; }
public static PackOrder Get4Return(RedBloodDataContext db, int ID) { PackOrder r = Get(db, ID); if (r.ReturnID > 0) throw new Exception("Đã thu hồi túi máu này."); return r; }
public static Pack Get(RedBloodDataContext db, Guid ID) { Pack p = db.Packs.FirstOrDefault(r => r.ID == ID); if (p == null) throw new Exception("Không tìm thấy túi máu."); return p; }
protected void LinqDataSourcePack_Selecting(object sender, LinqDataSourceSelectEventArgs e) { RedBloodDataContext db = new RedBloodDataContext(); e.Result = db.PackOrders.Where(r => PackOrderList.Contains(r.ID)) .Select(r => new { r.ID, r.OrderID, OrderType = r.Order.Type, DIN = r.Pack.Donation.DIN, r.Pack.ProductCode, Expired = r.Pack.ExpirationDate.Value.Expired() }); }
public static Org GetByName(string name) { RedBloodDataContext db = new RedBloodDataContext(); Org e = (from c in db.Orgs where c.Name == name.Trim() select c).FirstOrDefault(); if (e == null) { throw new Exception("Sai tên đơn vị."); } return(e); }
protected void Page_Load(object sender, EventArgs e) { string code = ""; string addText = ""; int count = 0; try { code = Request["code"]; } catch (Exception) { } try { count = Request["count"].ToInt(); } catch (Exception) { } try { addText = Request["addText"]; } catch (Exception) { } PrintSettingBLL.Reload(); RedBloodDataContext db = new RedBloodDataContext(); string desc = BloodGroupBLL.GetDescription(code); for (int i = 0; i < count; i++) { Panel p = new Panel(); p.Style.Add("position", "relative"); p.Style.Add("page-break-after", "always"); p.Style.Apply(PrintSettingBLL.BloodGroupLabel.PaperSize); p.Style.Add("border", "1px solid white"); divCon.Controls.Add(p); AddDINLabelControl(code, desc + addText, PrintSettingBLL.BloodGroupLabel.Label1, p); AddDINLabelControl(code, desc + addText, PrintSettingBLL.BloodGroupLabel.Label2, p); AddDINLabelControl(code, desc + addText, PrintSettingBLL.BloodGroupLabel.Label3, p); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strParamID = Request["ReturnID"]; if (!string.IsNullOrEmpty(strParamID)) { returnObj = ReturnBLL.Get(strParamID.ToInt()); if (returnObj != null) { LabelTitle1.Text = "BIÊN BẢN THU HỒI"; LoadReturn(); RedBloodDataContext db = new RedBloodDataContext(); var v1 = db.PackOrders.Where(r => r.ReturnID.Value == returnObj.ID) .Select(r => r.Pack) .ToList(); var v = v1.GroupBy(r => r.ProductCode) .Select(r => new { ProductCode = r.Key, Sum = r.Count(), BloodGroupSumary = r.GroupBy(r1 => r1.Donation.BloodGroup).Select(r1 => new { BloodGroupDesc = BloodGroupBLL.GetDescription(r1.Key), Total = r1.Count(), VolumeSumary = r1.GroupBy(r2 => r2.Volume).Select(r2 => new { Volume = r2.Key.HasValue ? r2.Key.Value.ToString() : "_", Total = r2.Count(), DINList = r2.Select(r3 => new { DIN = r3.DIN }).OrderBy(r4 => r4.DIN), }).OrderBy(r2 => r2.Volume) }).OrderBy(r1 => r1.BloodGroupDesc), }); GridViewSum.DataSource = v; GridViewSum.DataBind(); LableCount.Text = v1.Count().ToStringRemoveZero(); } } } }
void LoadData() { DateTime?dtFrom = txtDateFrom.Text.ToDatetimeFromVNFormat(); DateTime?dtTo = txtDateTo.Text.ToDatetimeFromVNFormat(); if (dtFrom.HasValue) { DateTime hourFrom; if (DateTime.TryParse(txtHourFrom.Text, out hourFrom)) { dtFrom = dtFrom.Value.AddHours(hourFrom.Hour).AddMinutes(hourFrom.Minute); } } if (dtTo.HasValue) { DateTime hourTo; if (DateTime.TryParse(txtHourTo.Text, out hourTo)) { dtTo = dtTo.Value.AddHours(hourTo.Hour).AddMinutes(hourTo.Minute); } } RedBloodDataContext db = new RedBloodDataContext(); //var packs = db.Packs.Where(r => r.Date.Value >= dtFrom && r.Date.Value <= dtTo // && r.Donation.OrgPackID != r.ID).OrderBy(r => r.Date); var v = db.Returns.Where(r => r.Date.Value >= dtFrom && r.Date.Value <= dtTo) .OrderBy(r => r.Date) .ToList() .Select(r => new { r.ID, Date = r.Date.ToStringVN_Hour(), r.Note, r.Actor, Packs = r.PackOrders.Select(r1 => r1.Pack) }); GridView1.DataSource = v; GridView1.DataBind(); GridViewSummary.DataSource = v.SelectMany(r => r.Packs).GroupBy(r => r.ProductCode).Select(r => new { ProductCode = r.Key, Count = r.Count() }); GridViewSummary.DataBind(); }
public object GetByPeopleID4PackHistory(Guid peopleID) { RedBloodDataContext db = new RedBloodDataContext(); var v = db.Donations.Where(r => r.PeopleID == peopleID) .OrderByDescending(r => r.CollectedDate) .ToList().Select(c => new { c.DIN, c.Status, c.CollectedDate, Note = (c.TestResultStatus != Donation.TestResultStatusX.Negative ? c.Markers.Description : "") + " | " + c.Note, c.BloodGroupDesc, ProductDesc = ProductBLL.GetDesc(c.Pack.ProductCode), c.Pack.Volume }); //foreach (var e in v) //{ //if (e.Status == Donation.StatusX.DataErr) //{ // e.Note = PackErrEnum.DataErr.Message; //} //else if (e.Status == Donation.StatusX.Delete) //{ // if (e.PackStatusHistories.Count == 0) // e.Note = "Unknown"; // else // e.Note = e.Status.ToString() + ": " + e.PackStatusHistories.Where(h => h.ToStatus == Pack.StatusX.Delete).First().Note; //} //else if (e.Status == Donation.StatusX.Assigned) //{ // e.Note = e.Status.ToString() + ": " + e.TestResultStatus.ToString(); //} //else if (e.Status == Pack.StatusX.Expired) //{ // e.Note = e.Note = e.Status.ToString() + ": " + e.PackStatusHistories.Where(h => h.ToStatus == Pack.StatusX.Expired).First().Note; //} //else //{ // e.Note = e.Status.ToString(); //} //} return(v); }
public static Pack Get(RedBloodDataContext db, string DIN, string productCode) { var l = db.Packs.Where(r => r.DIN == DIN && r.ProductCode == productCode).ToList(); if (l.Count > 1) { throw new Exception("Dữ liệu túi máu bị trùng."); } if (l.Count == 0) { throw new Exception("Không có túi máu."); } return(l.FirstOrDefault()); }
public static void ChangeStatus(Guid ID, Pack.StatusX toStatus, PackTransaction.TypeX transType, string note) { RedBloodDataContext db = new RedBloodDataContext(); Pack p = Get(db, ID); if (p.Status == toStatus) { throw new Exception("Can not change statuses which are the same."); } PackTransactionBLL.Add(ID, p.Status, toStatus, transType, note); p.Status = toStatus; db.SubmitChanges(); }
//public static void Add(int ID, string DIN, string productCode) //{ // Order r = OrderBLL.Get(ID); // if (r.Status == Order.StatusX.Done) // throw new Exception("Đợt cấp phát này đã kết thúc."); // Pack p = PackBLL.Get4Order(DIN, productCode); // PackOrder po = new PackOrder(); // po.OrderID = r.ID; // po.PackID = p.ID; // po.Status = PackOrder.StatusX.Order; // RedBloodDataContext db = new RedBloodDataContext(); // db.PackOrders.InsertOnSubmit(po); // db.SubmitChanges(); // string fullNote = "Add to Order: " + po.OrderID.Value.ToString() + "."; // PackBLL.Update(db, po.Pack, Pack.StatusX.Delivered, fullNote); // PackTransaction.TypeX transType = r.Type == Order.TypeX.ForCR ? PackTransaction.TypeX.Out_Order4CR // : r.Type == Order.TypeX.ForOrg ? PackTransaction.TypeX.Out_Order4Org // : PackTransaction.TypeX.Out_OrderGen; // PackTransactionBLL.Add(p.ID, // transType, // fullNote); //} //public static void Remove(int packOrderID, string note) //{ // RedBloodDataContext db = new RedBloodDataContext(); // PackOrder po = db.PackOrders.Where(r => r.ID == packOrderID).FirstOrDefault(); // if (po == null // || po.Pack == null // || po.Order == null) return; // string fullNote = DateTime.Now.ToStringVNLong() + ". " + RedBloodSystem.CurrentActor + ". Remove from Order: " + po.OrderID.Value.ToString() + ". " + note; // PackBLL.Update(db, po.Pack, Pack.StatusX.Product, fullNote); // po.Status = PackOrder.StatusX.Return; // po.Note = fullNote; // db.SubmitChanges(); // PackTransactionBLL.Add(po.Pack.ID, PackTransaction.TypeX.In_Return, fullNote); //} public static void CloseOrder() { RedBloodDataContext db = new RedBloodDataContext(); var v = db.Orders.Where(r => r.Status == Order.StatusX.Init && r.Date.Value.Date < DateTime.Now.Date).ToList(); foreach (var item in v) { item.Status = Order.StatusX.Done; } db.SubmitChanges(); LogBLL.Logs(); }
public static IQueryable <Campaign> Get(List <Guid> provinceIDList, DateTime?from, DateTime?to, Campaign.TypeX type) { RedBloodDataContext db = new RedBloodDataContext(); if (provinceIDList == null || provinceIDList.Count == 0) { return(null); } return(db.Campaigns.Where(r => provinceIDList.Contains(r.CoopOrg.GeoID1.Value) && r.Type == type && r.Date != null && (from == null || r.Date.Value.Date >= from.Value.Date) && (to == null || r.Date.Value.Date <= to.Value.Date) )); }
public void Update(int ID, string name) { RedBloodDataContext db = new RedBloodDataContext(); TestDef c = (from i in db.TestDefs where i.ID == ID select i).First(); if (c == null) { return; } c.Name = name; db.SubmitChanges(); }
protected void LinqDataSourceSum_Selecting(object sender, LinqDataSourceSelectEventArgs e) { RedBloodDataContext db = new RedBloodDataContext(); var v = db.Deletes.Where(r => r.ID == DeleteID) .SelectMany(r => r.Packs) .ToList() .GroupBy(r => r.ProductCode) .Select(r => new { ProductCode = r.Key, Sum = r.Count() }); e.Result = v; }
public object GetByPeopleID4PackHistory(Guid peopleID) { RedBloodDataContext db = new RedBloodDataContext(); var v = from c in db.Donations where c.PeopleID == peopleID orderby c.Status descending, c.CollectedDate descending select new { c.DIN, c.Status, c.CollectedDate, c.Note, c.BloodGroupDesc, ProductDesc = c.Pack.Product.Description, c.Pack.Volume }; //foreach (var e in v) //{ //if (e.Status == Donation.StatusX.DataErr) //{ // e.Note = PackErrEnum.DataErr.Message; //} //else if (e.Status == Donation.StatusX.Delete) //{ // if (e.PackStatusHistories.Count == 0) // e.Note = "Unknown"; // else // e.Note = e.Status.ToString() + ": " + e.PackStatusHistories.Where(h => h.ToStatus == Pack.StatusX.Delete).First().Note; //} //else if (e.Status == Donation.StatusX.Assigned) //{ // e.Note = e.Status.ToString() + ": " + e.TestResultStatus.ToString(); //} //else if (e.Status == Pack.StatusX.Expired) //{ // e.Note = e.Note = e.Status.ToString() + ": " + e.PackStatusHistories.Where(h => h.ToStatus == Pack.StatusX.Expired).First().Note; //} //else //{ // e.Note = e.Status.ToString(); //} //} return(v); }
static public SideEffect GetByFullnameAndLevel(string fullname, int lvl) { RedBloodDataContext db = new RedBloodDataContext(); var r = from e in db.SideEffects where e.Level.Value == lvl && e.Fullname == fullname.Trim() select e; if (r.Count() == 0) { return(null); } else { return(r.First()); } }
public static int CountPackRemainByStoreFinalize(DateTime date) { RedBloodDataContext db = new RedBloodDataContext(); var v = db.StoreFinalizes.Where(r => r.Date == date.Date && r.Type == PackTransaction.TypeX.Remain) .Select(r => r.Count); if (v.Count() > 1) { LogBLL.LogsFailAndThrow("Data Err."); } int?i = v.FirstOrDefault(); return(i.HasValue ? i.Value : 0); }
static void LoadData(Type type) { RedBloodDataContext db = new RedBloodDataContext(); List <PrintSetting> list = db.PrintSettings.Where(r => r.Type == type.Name).ToList(); var l = type .GetMembers(BindingFlags.Public | BindingFlags.Static | BindingFlags.GetProperty) .Where(r => r is PropertyInfo) .Select(r => r as PropertyInfo) .Where(r => r.PropertyType == typeof(PrintSetting)); foreach (var item in l) { item.SetValue(type, list.Where(r => r.Name == item.Name).FirstOrDefault(), null); } }
public bool IsExistName(string name, int ID) { RedBloodDataContext db = new RedBloodDataContext(); int count = (from r in db.Orgs where r.ID != ID && r.Name.Trim() == name.Trim() select r).Count(); if (count == 0) { return(false); } else { return(true); } }
public static DonationStatusLog UpdateStatus(RedBloodDataContext db, Donation e, Donation.StatusX to, string actor, string note) { if (e.Status == to) { return(null); } Donation.StatusX from = e.Status; e.Status = to; DonationStatusLog l = new DonationStatusLog(e, from, to, actor, note); db.DonationStatusLogs.InsertOnSubmit(l); return(l); }
public static People GetByID(int autonum) { RedBloodDataContext db = new RedBloodDataContext(); var e = from c in db.Peoples where c.Autonum == autonum select c; if (e.Count() != 1) { return(null); } else { return(e.First()); } }
private void DINEnter(string code) { string tempDIN = BarcodeBLL.ParseDIN(code); RedBloodDataContext db = new RedBloodDataContext(); Donation d = DonationBLL.Get(tempDIN); if (d == null) { this.Alert(DonationErrEnum.NonExist.Message); return; } if (d.PeopleID != null) { DIN = tempDIN; ucPDL.PeopleID = d.PeopleID.Value; return; } if (ucPeople.PeopleID == Guid.Empty) { this.Alert("Chưa nhập thông tin người cho máu."); return; } if (CamDetailLeft.CampaignID == 0) { this.Alert("Chưa nhập thông tin đợt thu máu."); return; } DIN = tempDIN; DonationErr err = DonationBLL.Assign(DIN, ucPeople.PeopleID, CamDetailLeft.CampaignID); if (err != DonationErrEnum.Non) { this.Alert("Túi máu: " + err.Message); } else { ucPDL.ShowLog(); } return; }
static public bool IsExistNameInSameDate(string name, int ID, DateTime dt) { RedBloodDataContext db = new RedBloodDataContext(); int count = (from r in db.Campaigns where r.ID != ID && r.Name.Trim() == name.Trim() && r.Date == dt select r).Count(); if (count == 0) { return(false); } else { return(true); } }
partial void OnValidate(System.Data.Linq.ChangeAction action) { if (action == System.Data.Linq.ChangeAction.Insert || action == System.Data.Linq.ChangeAction.Update) { RedBloodDataContext db = new RedBloodDataContext(); int count = (from e in db.TestDefs where object.Equals(e.ParentID, this.ParentID) && e.Name == this.Name.Trim() select e).Count(); if (count > 0) { throw new Exception("Trùng tên"); } } }
protected void btnUpdate_Click(object sender, EventArgs e) { //Thread.Sleep(5000); if (PeopleID == Guid.Empty) { RedBloodDataContext db = new RedBloodDataContext(); People p = new People(); if (LoadFromGUI(p)) { db.Peoples.InsertOnSubmit(p); db.SubmitChanges(); PeopleID = p.ID; } else { return; } } else { RedBloodDataContext db = new RedBloodDataContext(); var p = (from c in db.Peoples where c.ID == PeopleID select c).First(); if (p == null) { return; } if (LoadFromGUI(p)) { db.SubmitChanges(); PeopleID = p.ID; } else { return; } } Page.Alert("Lưu thành công."); }
public static People GetByID(Guid ID) { RedBloodDataContext db = new RedBloodDataContext(); var e = from c in db.Peoples where c.ID == ID select c; if (e.Count() != 1) { return(null); } else { return(e.First()); } }
protected void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e) { RedBloodDataContext db = new RedBloodDataContext(); e.Result = db.Packs.Where(r => r.Status == Pack.StatusX.Product && r.ProductCode == ProductCode) .ToList() .Select(r => new { r.DIN, r.Donation.TestResultStatus, r.Donation.BloodGroupDesc, r.Volume, ExpirationDate = r.ExpirationDate.ToStringVN_Hour(), Expired = r.ExpirationDate.Value.Expired() ? "X" : "", ExpiredInDays = r.ExpirationDate.Value.ExpiredInDays(ExpiredInDays) ? "X" : "" }) .OrderBy(r => r.DIN); }
//public object GetTSIn(bool isLongRun) //{ // RedBloodDataContext db = new RedBloodDataContext(); // if (isLongRun) // { // var rs = from r in db.Campaigns // let total = (r.Packs.Count(p => p.Status == Pack.StatusX.CommitReceived)) // where total > 0 && r.Type == Campaign.TypeX.Long_run // select new { r.ID, r.Name, SourceName = r.Source.Name, r.Note, total }; // return rs; // } // else // { // var rs = from r in db.Campaigns // let total = (r.Packs.Count(p => p.Status == Pack.StatusX.CommitReceived)) // where r.Type == Campaign.TypeX.Short_run && r.Status == Campaign.StatusX.Assign // select new { r.ID, r.Name, SourceName = r.Source.Name, r.Date, r.Note, total }; // return rs; // } //} static public void New(Campaign e) { RedBloodDataContext db = new RedBloodDataContext(); if (e.Type == Campaign.TypeX.Long_run) { e.Status = Campaign.StatusX.Assign; } if (e.Type == Campaign.TypeX.Short_run) { e.Status = Campaign.StatusX.Init; } db.Campaigns.InsertOnSubmit(e); db.SubmitChanges(); }
private static bool Validate(DateTime date) { string err = "Process for day: " + date.Date.ToShortDateString() + ". "; if (date.Date > DateTime.Now.Date) { LogBLL.LogsFailAndThrow(MyMethodBase.Current.Caller, err + "Date is in future."); } RedBloodDataContext db = new RedBloodDataContext(); if (db.PackRemainDailies.Where(r => r.Date.Value.Date > date.Date).Count() > 0) { LogBLL.LogsFailAndThrow(MyMethodBase.Current.Caller, err + "Existing newer data."); } return(true); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //DropDownList1.DataSource = PrintSetting.TypeX. RedBloodDataContext db = new RedBloodDataContext(); DropDownList1.DataSource = db.PrintSettings.Select(r => r.Type).Distinct(); DropDownList1.DataBind(); //foreach (PrintSetting.TypeX r in Enum.GetValues(typeof(PrintSetting.TypeX))) //{ // ListItem item = new ListItem(Enum.GetName(typeof(PrintSetting.TypeX), r), ((int)r).ToString() ); // DropDownList1.Items.Add(item); //} } }
public static void RemoveOriginalPack(string DIN) { RedBloodDataContext db = new RedBloodDataContext(); Donation d = Get(db, DIN); if (d.CanRemoveOriginalPack) { Pack p = d.Pack; d.Pack = null; db.PackTransactions.DeleteAllOnSubmit(p.PackTransactions); db.PackRemainDailies.DeleteAllOnSubmit(p.PackRemainDailies); db.Packs.DeleteOnSubmit(p); db.SubmitChanges(); } }
protected void btnUpdate_Click(object sender, EventArgs e) { if (OrderID == 0) { RedBloodDataContext db = new RedBloodDataContext(); Order p = new Order(); p.Status = Order.StatusX.Init; p.Actor = RedBloodSystem.CurrentActor; if (LoadFromGUI(p)) { db.Orders.InsertOnSubmit(p); db.SubmitChanges(); OrderID = p.ID; } else { return; } } else { RedBloodDataContext db = new RedBloodDataContext(); Order p = OrderBLL.Get(OrderID, db); if (p == null) { return; } if (LoadFromGUI(p)) { db.SubmitChanges(); OrderID = p.ID; } else { return; } } this.Alert("Lưu thành công."); }