private void UpdateHHtHeader(Guid headerId, int totalLine, int missingLine, decimal totalQty, decimal missingQty)
{
using (var ctx = new EF6.RT2020Entities())
{
var hhtHeader = ctx.StocktakeHeader_HHT.Find(headerId);
if (hhtHeader != null)
{
hhtHeader.TOTALQTY = totalQty;
hhtHeader.TotalRows = totalLine;
hhtHeader.MissingRows = missingLine;
hhtHeader.MissingQty = missingQty;
ctx.SaveChanges();
}
}
}
public static bool SetMetadata(Guid preferenceId, string group, List <KeyValuePair <string, string> > items)
{
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 Proference"),
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);
xmlData.Element(group).Add(target);
}
foreach (var item in items)
{
target.SetAttributeValue(item.Key, item.Value);
}
sp.MetadataXml = xmlData.ToString();
ctx.SaveChanges();
result = true;
}
catch (Exception ex)
{
throw ex;
}
}
}
return(result);
}
/// <summary>
/// Queuings the tx number.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="typeName">Name of the type. Enums: EnumHelper.TxType, EnumHelper.POType</param>
/// <returns>TxNumber</returns>
public static string QueuingTxNumber <T>(T typeName)
{
string query = " 1 = 1 ";
string queuingType = string.Empty;
switch (typeName.GetType().Name)
{
case "TxType":
EnumHelper.TxType txType = (EnumHelper.TxType)Convert.ChangeType(typeName, typeof(EnumHelper.TxType));
query = "QueuingType = '" + txType.ToString() + "'";
queuingType = txType.ToString();
break;
case "POType":
EnumHelper.POType poType = (EnumHelper.POType)Convert.ChangeType(typeName, typeof(EnumHelper.POType));
query = "QueuingType = '" + poType.ToString() + "'";
queuingType = poType.ToString();
break;
}
long queuedTxNumber = 1;
using (var ctx = new EF6.RT2020Entities())
{
var oQueue = ctx.SystemQueue.SqlQuery(
String.Format(
"Select * from SystemQueue Where {0}",
String.IsNullOrEmpty(query) ? "1 = 1" : query
))
.FirstOrDefault();
if (oQueue == null)
{
oQueue = new EF6.SystemQueue();
oQueue.QueueId = Guid.NewGuid();
oQueue.QueuingType = queuingType;
oQueue.LastNumber = "000000000000";
ctx.SystemQueue.Add(oQueue);
}
queuedTxNumber = Convert.ToInt64(oQueue.LastNumber) + 1;
oQueue.LastNumber = queuedTxNumber.ToString();
ctx.SaveChanges();
}
return(queuedTxNumber.ToString().PadLeft(12, '0'));
}
/// <summary>
/// Deletes a EF6.EPOSSubLedgerTender object from the database.
/// </summary>
/// <param name="tenderId">The primary key value</param>
public static bool Delete(Guid tenderId)
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var item = ctx.EPOSSubLedgerTender.Find(tenderId);
if (item != null)
{
ctx.EPOSSubLedgerTender.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.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>
/// Deletes a EF6.InvtBatchADJ_Header 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.InvtBatchADJ_Header.Find(headerId);
if (item != null)
{
ctx.InvtBatchADJ_Header.Remove(item);
ctx.SaveChanges();
result = true;
}
}
return(result);
}
public static bool Delete(Guid id)
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var item = ctx.SupplierSmartTag.Find(id);
if (item != null)
{
ctx.SupplierSmartTag.Remove(item);
ctx.SaveChanges();
result = true;
}
}
return(result);
}
/// <summary>
/// Deletes a EF6.PosAnalysisCode object from the database.
/// </summary>
/// <param name="analysisCodeId">The primary key value</param>
public static bool Delete(Guid analysisCodeId)
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var item = ctx.PosAnalysisCode.Find(analysisCodeId);
if (item != null)
{
ctx.PosAnalysisCode.Remove(item);
ctx.SaveChanges();
result = true;
}
}
return(result);
}
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.MemberAddressType object from the database.
/// </summary>
/// <param name="addressTypeId">The primary key value</param>
public static bool Delete(Guid addressTypeId)
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var item = ctx.MemberAddressType.Find(addressTypeId);
if (item != null)
{
ctx.MemberAddressType.Remove(item);
ctx.SaveChanges();
result = true;
}
}
return(result);
}
/// <summary>
/// Deletes a EF6.SmartTag4Workplace_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.SmartTag4Workplace_Options.Find(optionId);
if (item != null)
{
ctx.SmartTag4Workplace_Options.Remove(item);
ctx.SaveChanges();
result = true;
}
}
return(result);
}
/// <summary>
/// Deletes a EF6.MemberVipLineOfOperation object from the database.
/// </summary>
/// <param name="vipLooId">The primary key value</param>
public static bool Delete(Guid vipLooId)
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var item = ctx.MemberVipLineOfOperation.Find(vipLooId);
if (item != null)
{
ctx.MemberVipLineOfOperation.Remove(item);
ctx.SaveChanges();
result = true;
}
}
return(result);
}
/// <summary>
/// Deletes a EF6.InvtBatchCAP_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.InvtBatchCAP_Details.Find(detailsId);
if (item != null)
{
ctx.InvtBatchCAP_Details.Remove(item);
ctx.SaveChanges();
result = true;
}
}
return(result);
}
public static bool Delete(Guid userId, Guid objectId)
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var item = ctx.UserPreference.Where(x => x.UserId == userId && x.PreferenceObjectId == objectId).FirstOrDefault();
if (item != null)
{
ctx.UserPreference.Remove(item);
ctx.SaveChanges();
result = true;
}
}
return(result);
}
/// <summary>
/// Deletes a EF6.StaffDept object from the database.
/// </summary>
/// <param name="deptId">The primary key value</param>
public static bool Delete(Guid deptId)
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var item = ctx.StaffDept.Find(deptId);
if (item != null)
{
ctx.StaffDept.Remove(item);
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.MarketSector object from the database.
/// </summary>
/// <param name="marketSectorId">The primary key value</param>
public static bool Delete(Guid marketSectorId)
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var item = ctx.MarketSector.Find(marketSectorId);
if (item != null)
{
ctx.MarketSector.Remove(item);
ctx.SaveChanges();
result = true;
}
}
return(result);
}
public static bool Delete(Guid id)
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var st = ctx.SupplierTerms.Find(id);
if (st != null)
{
ctx.SupplierTerms.Remove(st);
ctx.SaveChanges();
result = true;
}
}
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();
}
}
}
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);
}
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 Delete()
{
using (var ctx = new EF6.RT2020Entities())
{
var oPosTenderType = ctx.PosTenderType.Find(_TenderTypeId);
if (oPosTenderType != null)
{
try
{
ctx.PosTenderType.Remove(oPosTenderType);
ctx.SaveChanges();
}
catch
{
MessageBox.Show("Cannot delete the record being used by other record!", "Delete Warning");
}
}
}
}
private void ImportProductSupplement(Guid productId, StockCodeRec oRec)
{
using (var ctx = new EF6.RT2020Entities())
{
//string sql = "ProductId = '" + productId.ToString() + "' AND VendorCurrencyCode = '" + oRec.VCURR + "'";
var oProdSupp = ctx.ProductSupplement.Where(x => x.ProductId == productId && x.VendorCurrencyCode == oRec.VCURR).FirstOrDefault();
if (oProdSupp == null)
{
oProdSupp = new EF6.ProductSupplement();
oProdSupp.SupplementId = Guid.NewGuid();
oProdSupp.ProductId = productId;
oProdSupp.VendorCurrencyCode = oRec.VCURR;
oProdSupp.VendorPrice = Convert.ToDecimal(oRec.VPRC);
ctx.ProductSupplement.Add(oProdSupp);
ctx.SaveChanges();
}
}
}
private void Delete()
{
using (var ctx = new EF6.RT2020Entities())
{
try
{
var zone = ctx.WorkplaceZone.Find(this.ZoneId);
if (zone != null)
{
ctx.WorkplaceZone.Remove(zone);
ctx.SaveChanges();
}
}
catch
{
MessageBox.Show("Cannot delete the record...Might be in use by other record!", "Delete Warning");
}
}
}
private void CreatedStockTakeDetail(Guid stktkHeaderId, string txNumber, List <ImportDetailsInfo> detailList, Guid workplaceId, DateTime uploadedOn)
{
using (var ctx = new EF6.RT2020Entities())
{
using (var scope = ctx.Database.BeginTransaction())
{
try
{
foreach (ImportDetailsInfo detail in detailList)
{
Guid productId = ProductBarcodeEx.GetProductIdByBarcode(detail.Barcode);
if (!string.IsNullOrEmpty(detail.Barcode.Trim()) && productId != Guid.Empty)
{
//string sql = "HeaderId = '" + stktkHeaderId.ToString() + "' AND TxNumber = '" + txNumber + "' AND ProductId = '" + productId.ToString() + "' AND WorkplaceId = '" + workplaceId.ToString() + "'";
var item = ctx.StockTakeDetails.Where(x => x.HeaderId == stktkHeaderId && x.TxNumber == txNumber && x.ProductId == productId && x.WorkplaceId == workplaceId).FirstOrDefault();
if (item == null)
{
item = new EF6.StockTakeDetails();
item.DetailsId = Guid.NewGuid();
item.HeaderId = stktkHeaderId;
item.TxNumber = txNumber;
item.ProductId = productId;
item.WorkplaceId = workplaceId;
item.ModifiedOn = uploadedOn;
item.ModifiedBy = ConfigHelper.CurrentUserId;
ctx.StockTakeDetails.Add(item);
}
ctx.SaveChanges();
}
}
scope.Commit();
}
catch (Exception ex)
{
scope.Rollback();
}
}
}
}
private void Delete()
{
using (var ctx = new EF6.RT2020Entities())
{
var oMemberGroup = ctx.MemberGroup.Find(_GroupId);
if (oMemberGroup != null)
{
try
{
ctx.MemberGroup.Remove(oMemberGroup);
ctx.SaveChanges();
}
catch
{
MessageBox.Show("Cannot delete the record being used by other record!", "Delete Warning");
}
}
}
}
private void Delete()
{
using (var ctx = new EF6.RT2020Entities())
{
try
{
var m = ctx.LineOfOperation.Find(this.LineOfOperationId);
if (m != null)
{
ctx.LineOfOperation.Remove(m);
ctx.SaveChanges();
}
}
catch
{
MessageBox.Show("Cannot delete the record...Might be in use by other record!", "Delete Warning");
}
}
}
private void Delete()
{
using (var ctx = new EF6.RT2020Entities())
{
try
{
var item = ctx.SmartTag4Staff_Options.Find(_OptionId);
if (item != null)
{
ctx.SmartTag4Staff_Options.Remove(item);
ctx.SaveChanges();
}
}
catch
{
MessageBox.Show("Cannot delete the record...Might be in use by other record!", "Delete Warning");
}
}
}
public bool SaveData()
{
var result = false;
using (var ctx = new EF6.RT2020Entities())
{
var item = ctx.Product.Where(x => x.ProductId == _ProductId).FirstOrDefault();
if (item != null)
{
item.AlternateItem = txtVendorItemNum.Text.Trim();
item.ReorderLevel = DecimalHelper.StringToDecimal(txtReorderLevel.Text);
item.ReorderQty = DecimalHelper.StringToDecimal(txtReorderQuantity.Text);
ctx.SaveChanges();
}
}
return(result);
}
