/// <summary> /// Deletes a EF6.EPOSSubLedgerHeader object from the database. /// </summary> /// <param name="headerId">The primary key value</param> public static bool Delete(Guid headerId) { bool result = false; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.EPOSSubLedgerHeader.Find(headerId); if (item != null) { ctx.EPOSSubLedgerHeader.Remove(item); ctx.SaveChanges(); result = true; } } return(result); }
/// <summary> /// Product Onhand Qty 指定 Workplace /// </summary> /// <param name="productId"></param> /// <param name="workplaceId"></param> /// <returns></returns> public static decimal GetOnHandQtyByWorkplaceId(Guid productId, Guid workplaceId) { decimal result = 0; using (var ctx = new EF6.RT2020Entities()) { var list = ctx.ProductWorkplace .Where(x => x.ProductId == productId && x.WorkplaceId == workplaceId) .AsNoTracking() .ToList(); foreach (var item in list) { result += item.CDQTY; } } return(result); }
private void BindCityList() { this.lvCityList.ListViewItemSorter = new ListViewItemSorter(lvCityList); this.lvCityList.Items.Clear(); int iCount = 1; using (var ctx = new EF6.RT2020Entities()) { var list = new List <EF6.City>(); #region Priority: Province > Country > All if (_Filter_ProvinceId != Guid.Empty) { list = ctx.City .Where(x => x.ProvinceId == _Filter_ProvinceId) .OrderBy(x => x.Province.ProvinceName).ThenBy(x => x.CityName).AsNoTracking().ToList(); } else { if (_Filter_CountryId != Guid.Empty) { list = ctx.City .Where(x => x.Province.CountryId == _Filter_CountryId) .OrderBy(x => x.Province.ProvinceName).ThenBy(x => x.CityName).AsNoTracking().ToList(); } else { list = ctx.City.OrderBy(x => x.Province.ProvinceName).ThenBy(x => x.CityName).AsNoTracking().ToList(); } } #endregion foreach (var item in list) { var oItem = this.lvCityList.Items.Add(item.CityId.ToString()); oItem.SubItems.Add(iCount.ToString()); oItem.SubItems.Add(item.CityCode); oItem.SubItems.Add(item.CityName); oItem.SubItems.Add(item.CityName_Chs); oItem.SubItems.Add(item.CityName_Cht); iCount++; } } }
/// <summary> /// Deletes a EF6.InvtBatchRPL_Details object from the database. /// </summary> /// <param name="detailsId">The primary key value</param> public static bool Delete(Guid detailsId) { bool result = false; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.InvtBatchRPL_Details.Find(detailsId); if (item != null) { ctx.InvtBatchRPL_Details.Remove(item); ctx.SaveChanges(); result = true; } } return(result); }
/// <summary> /// Deletes a EF6.PriceManagementReason object from the database. /// </summary> /// <param name="reasonId">The primary key value</param> public static bool Delete(Guid reasonId) { bool result = false; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.PriceManagementReason.Find(reasonId); if (item != null) { ctx.PriceManagementReason.Remove(item); ctx.SaveChanges(); result = true; } } return(result); }
/// <summary> /// Deletes a EF6.MemberGroup object from the database. /// </summary> /// <param name="groupId">The primary key value</param> public static bool Delete(Guid groupId) { bool result = false; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.MemberGroup.Find(groupId); if (item != null) { ctx.MemberGroup.Remove(item); ctx.SaveChanges(); result = true; } } return(result); }
/// <summary> /// Deletes a EF6.SmartTag4Supplier_Options object from the database. /// </summary> /// <param name="optionId">The primary key value</param> public static bool Delete(Guid optionId) { bool result = false; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.SmartTag4Supplier_Options.Find(optionId); if (item != null) { ctx.SmartTag4Supplier_Options.Remove(item); ctx.SaveChanges(); result = true; } } return(result); }
/// <summary> /// Deletes a EF6.PosTenderType object from the database. /// </summary> /// <param name="typeId">The primary key value</param> public static bool Delete(Guid typeId) { bool result = false; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.PosTenderType.Find(typeId); if (item != null) { ctx.PosTenderType.Remove(item); ctx.SaveChanges(); result = true; } } return(result); }
private void FillListView() { lvLocationList.Items.Clear(); using (var ctx = new EF6.RT2020Entities()) { var list = ctx.Workplace.OrderBy(x => x.WorkplaceCode).AsNoTracking().ToList(); foreach (var wp in list) { string locInfo = wp.WorkplaceCode + " - " + wp.WorkplaceInitial; ListViewItem lvItem = lvLocationList.Items.Add(wp.WorkplaceId.ToString()); lvItem.SubItems.Add(locInfo); lvItem.SubItems.Add(":"); lvItem.SubItems.Add(GetTxInfo(wp.WorkplaceId)); } } }
public static bool ClearLogoInfo(Guid id) { bool result = false; using (var ctx = new EF6.RT2020Entities()) { var sys = ctx.SystemInfo.Find(id); if (sys != null) { sys.LOGO = string.Empty; ctx.SaveChanges(); result = true; } } return(result); }
/// <summary> /// Deletes a EF6.WorkplaceZone object from the database. /// </summary> /// <param name="zoneId">The primary key value</param> public static bool Delete(Guid zoneId) { bool result = false; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.WorkplaceZone.Find(zoneId); if (item != null) { ctx.WorkplaceZone.Remove(item); ctx.SaveChanges(); result = true; } } return(result); }
/// <summary> /// Deletes a EF6.ProductAppendix2 object from the database. /// </summary> /// <param name="appendix2Id">The primary key value</param> public static bool Delete(Guid appendix2Id) { bool result = false; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.ProductAppendix2.Find(appendix2Id); if (item != null) { ctx.ProductAppendix2.Remove(item); ctx.SaveChanges(); result = true; } } return(result); }
/// <summary> /// Binds the purchase list. /// </summary> private void BindPurchaseList() { this.lisReceivingFindList.Items.Clear(); ////清除lisPurchaseOrderList控件中的数据 int iCount = 1; string objPOnumber = (this.txtPONumber.Text.Trim() == "*") ? string.Empty : PurchasingUtils.GenSafeChars(this.txtPONumber.Text.Trim()); string objType = (this.txtType.Text.Trim() == "*") ? string.Empty : PurchasingUtils.GenSafeChars(this.txtType.Text.Trim()); string sql = "Status = 1 AND PostedBy <> '" + Guid.Empty + "' AND OrderNumber LIKE '%" + objPOnumber + "%' AND OrderType LIKE '%" + objType + "%'"; string orderBy = "OrderNumber"; using (var ctx = new EF6.RT2020Entities()) { var objHeaders = ctx.PurchaseOrderHeader.SqlQuery( string.Format("Select * from PurchaseOrderHeader Where {0} Order By {1}", sql, orderBy)) .AsNoTracking() .ToList(); foreach (var objHeader in objHeaders) { string orderType = string.Empty; switch (objHeader.OrderType) { case 0: orderType = EnumHelper.POType.FPO.ToString(); break; case 1: orderType = EnumHelper.POType.LPO.ToString(); break; case 2: orderType = EnumHelper.POType.OPO.ToString(); break; } ListViewItem objItem = this.lisReceivingFindList.Items.Add(objHeader.OrderHeaderId.ToString()); //// OrderHeaderId objItem.SubItems.Add(iCount.ToString()); //// Line Number objItem.SubItems.Add(objHeader.OrderNumber); objItem.SubItems.Add(orderType); iCount++; } } }
private string GetTxInfo(Guid workplaceId) { string result = string.Empty; using (var ctx = new EF6.RT2020Entities()) { //string sql = "WorkplaceId = '" + workplaceId.ToString() + "' AND YEAR(PostedOn) = 1900 AND LEN(ADJNUM) = 0"; var oHeader = ctx.StockTakeHeader .Where(x => x.WorkplaceId == workplaceId && x.PostedOn.Value.Year == 1900 && x.ADJNUM.Length == 0) .AsNoTracking() .FirstOrDefault(); if (oHeader != null) { result = oHeader.TxNumber + " " + DateTimeHelper.DateTimeToString(oHeader.TxDate.Value, false); } } return(result); }
/// <summary> /// Product Onhand Qty 指定 Workplace List /// </summary> /// <param name="productId"></param> /// <param name="workplaceId"></param> /// <returns></returns> public static decimal GetOnHandQtyByWorkplaceId(Guid productId, Guid[] workplaceId) { decimal result = 0; using (var ctx = new EF6.RT2020Entities()) { var idList = String.Join(",", workplaceId.Select(x => "'" + x + "'")); var list = ctx.ProductWorkplace .Where(x => x.ProductId == productId && idList.Contains(x.WorkplaceId.ToString())) .AsNoTracking() .ToList(); foreach (var item in list) { result += item.CDQTY; } } return(result); }
public static string GetProductNameBySTKCODE(string stkcode, bool switchLocale = false) { string result = ""; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.Product.Where(x => x.STKCODE == stkcode).AsNoTracking().FirstOrDefault(); if (item != null) { result = !switchLocale ? item.ProductName : CookieHelper.CurrentLocaleId == LanguageHelper.AlternateLanguage2.Key ? item.ProductName_Chs : CookieHelper.CurrentLocaleId == LanguageHelper.AlternateLanguage1.Key ? item.ProductName_Cht : item.ProductName; } } return(result); }
public static bool HasPreference(Guid staffId, Guid pageId) { bool result = false; using (var ctx = new EF6.RT2020Entities()) { var sp = ctx.StaffPreference.Where(x => x.StaffId == staffId && x.PageId == pageId).AsNoTracking().FirstOrDefault(); if (sp != null) { if (sp.MetadataXml != string.Empty) { result = true; } } } return(result); }
public static string GetZoneNameById(Guid id) { string result = ""; using (var ctx = new EF6.RT2020Entities()) { var z = ctx.WorkplaceZone.Where(x => x.ZoneId == id).FirstOrDefault(); if (z != null) { result = CookieHelper.CurrentLocaleId == LanguageHelper.AlternateLanguage2.Key ? z.ZoneName_Cht : CookieHelper.CurrentLocaleId == LanguageHelper.AlternateLanguage1.Key ? z.ZoneName_Chs : z.ZoneName; } } return(result); }
private void FillMemberNumber() { using (var ctx = new EF6.RT2020Entities()) { var list = ctx.Member.OrderBy(x => x.MemberNumber).AsNoTracking().ToList(); if (list.Count > 0) { foreach (var oMember in list) { string item = oMember.MemberNumber; cmbFrom.Items.Add(item); cmbTo.Items.Add(item); } cmbFrom.SelectedIndex = 0; cmbTo.SelectedIndex = list.Count - 1; } } }
public static string GetTagValue(Guid staffId, TagName tagName) { string result = ""; using (var ctx = new EF6.RT2020Entities()) { var sp = ctx.StaffInternetTag.Where(x => x.StaffId == staffId).AsNoTracking().FirstOrDefault(); if (sp != null) { result = tagName == TagName.Internet ? sp.InternetTag1Value : tagName == TagName.Exchange ? sp.InternetTag2Value : tagName == TagName.URL ? sp.InternetTag3Value : ""; } } return(result); }
public static bool IsMemberNumberInUse(string memberNumber) { bool result = false; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.Member .Where(x => x.MemberNumber == memberNumber) .AsNoTracking() .FirstOrDefault(); if (item != null) { result = true; } } return(result); }
/// <summary> /// Fills the workplace list. /// </summary> private void FillWorkplaceList() { int iCount = 1; using (var ctx = new EF6.RT2020Entities()) { var wpList = ctx.Workplace.OrderBy(x => x.WorkplaceCode).AsNoTracking().ToList(); foreach (var wp in wpList) { ListViewItem listItem = lvLocationList.Items.Add(wp.WorkplaceId.ToString()); listItem.SubItems.Add(string.Empty); listItem.SubItems.Add(wp.WorkplaceCode); listItem.SubItems.Add(wp.WorkplaceInitial); iCount++; } } }
public static Guid GetIdBySql(string whereClause) { Guid result = Guid.Empty; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.Member .SqlQuery(string.Format("Select * from Member Where {0}", whereClause)) .AsNoTracking() .FirstOrDefault(); if (item != null) { result = item.MemberId; } } return(result); }
private void DeleteHHTRecord(Guid headerId) { using (var ctx = new EF6.RT2020Entities()) { var hhtHeader = ctx.StocktakeHeader_HHT.Find(headerId); //StocktakeHeader_HHT hhtHeader = StocktakeHeader_HHT.Load(headerId); if (hhtHeader != null) { hhtHeader.PostedOn = DateTime.Now; hhtHeader.Status = (int)EnumHelper.Status.Draft; hhtHeader.Retired = true; hhtHeader.RetiredBy = ConfigHelper.CurrentUserId; hhtHeader.RetiredOn = DateTime.Now; ctx.SaveChanges(); } } }
public static string GetNameById(Guid id) { string result = ""; using (var ctx = new EF6.RT2020Entities()) { var z = ctx.SupplierAddressType.Find(id); if (z != null) { result = CookieHelper.CurrentLocaleId == LanguageHelper.AlternateLanguage2.Key ? z.AddressTypeName_Cht : CookieHelper.CurrentLocaleId == LanguageHelper.AlternateLanguage1.Key ? z.AddressTypeName_Chs : z.AddressTypeName; } } return(result); }
private void Delete() { using (var ctx = new EF6.RT2020Entities()) { var oAddressType = ctx.MemberAddressType.Find(_AddressTypeId); if (oAddressType != null) { try { ctx.MemberAddressType.Remove(oAddressType); } catch { MessageBox.Show("Cannot delete the record being used by other record!", "Delete Warning"); } } } }
private bool SaveAppendix3() { bool result = false; using (var ctx = new EF6.RT2020Entities()) { EF6.ProductAppendix3 item = null; switch (_EditMode) { case EnumHelper.EditMode.Add: item = new EF6.ProductAppendix3(); item.Appendix3Id = Guid.NewGuid(); item.Appendix3Code = txtCode.Text; item.CreatedBy = ConfigHelper.CurrentUserId; item.CreatedOn = DateTime.Now; ctx.ProductAppendix3.Add(item); break; case EnumHelper.EditMode.Edit: item = ctx.ProductAppendix3.Find(_AppendixId); break; } item.Appendix3Initial = txtInitial.Text; item.Appendix3Name = txtName.Text; item.Appendix3Name_Chs = txtNameChs.Text; item.Appendix3Name_Cht = txtNameCht.Text; if ((Guid)cboParentAppendix.SelectedValue != Guid.Empty) { item.ParentAppendix = (Guid)cboParentAppendix.SelectedValue; } item.ModifiedBy = ConfigHelper.CurrentUserId; item.ModifiedOn = DateTime.Now; ctx.SaveChanges(); _AppendixId = item.Appendix3Id; result = true; } return(result); }
public static bool SetMetadata(Guid preferenceId, string group, string key, string value) { bool result = false; using (var ctx = new EF6.RT2020Entities()) { var sp = ctx.StaffPreference.Find(preferenceId); if (sp != null) { try { if (sp.MetadataXml == string.Empty) { XDocument newXml = new XDocument( new XDeclaration("1.0", "utf-8", "yes"), new XComment("RT2020 User Preference"), new XElement(group)); sp.MetadataXml = newXml.ToString(); ctx.StaffPreference.Add(sp); } XDocument xmlData = XDocument.Parse(sp.MetadataXml); var target = xmlData.Descendants(group).FirstOrDefault(); if (target == null) { target = new XElement(group); target.SetAttributeValue(key, value); xmlData.Element(group).Add(target); } sp.MetadataXml = xmlData.ToString(); ctx.SaveChanges(); result = true; } catch (Exception ex) { throw ex; } } } return(result); }
private void DeleteConfirmationHandler(object sender, EventArgs e) { if (((Form)sender).DialogResult == DialogResult.Yes) { string picPath = Path.Combine(mstrDirectory, txtPicFileName.Text); imgProductPic.ImageName = Path.Combine(VWGContext.Current.Config.GetDirectory("Images"), "no_photo.jpg"); if (File.Exists(picPath)) { try { File.Delete(picPath); using (var ctx = new EF6.RT2020Entities()) { //string sql = "ProductId = '" + productId.ToString() + "' AND Photo = '" + txtPicFileName.Text + "'"; var oRemarks = ctx.ProductRemarks.Where(x => x.ProductId == _ProductId && x.Photo == txtPicFileName.Text).FirstOrDefault(); if (oRemarks != null) { oRemarks.Photo = oRemarks.Photo2; oRemarks.Photo2 = oRemarks.Photo3; oRemarks.Photo3 = oRemarks.Photo4; oRemarks.Photo4 = oRemarks.Photo5; oRemarks.Photo5 = string.Empty; ctx.SaveChanges(); imgProductPic.ImageName = Path.Combine("Product", oRemarks.Photo); MessageBox.Show("The picture '" + txtPicFileName.Text + "' is deleted.", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("The picture does not exist in database.", "Delete Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } catch (Exception exc) { MessageBox.Show(exc.Message, "Delete Failed!"); } } } }
private void LoadAddress() { using (var ctx = new EF6.RT2020Entities()) { var sa = ctx.StaffAddress.Where(x => x.StaffId == _StaffId).AsNoTracking().FirstOrDefault(); if (sa != null) { txtAddress.Text = sa.Address; txtPostal.Text = sa.PostalCode; cmbCountry.SelectedValue = sa.CountryId.HasValue ? sa.CountryId.Value : Guid.Empty; cmbProvince.SelectedValue = sa.ProvinceId.HasValue ? sa.ProvinceId.Value : Guid.Empty; cmbCity.SelectedValue = sa.CityId.HasValue ? sa.CityId.Value : Guid.Empty; txtPhoneTag1.Text = sa.PhoneTag1Value; txtPhoneTag2.Text = sa.PhoneTag2Value; txtPhoneTag3.Text = sa.PhoneTag3Value; txtPhoneTag4.Text = sa.PhoneTag4Value; } } }