/// <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;
}
}
}
