/// <summary>
/// Popula o DataTable com a table de model
/// </summary>
private void PopulaDataTableListaModel(DataTable dt)
{
DataRow linha;
rItem regraItem = new rItem();
mItem modelItem = new mItem();
try
{
foreach (mItemKit model in this._listaModelItemKit)
{
modelItem = regraItem.BuscaUnicoRegistro(Convert.ToInt32(model.Id_item));
linha = dt.NewRow();
linha["id_item"] = model.Id_item;
linha["Codigo"] = modelItem.Id_item_real;
linha["Item"] = modelItem.Nom;
linha["qtd"] = model.Qtd_item;
dt.Rows.Add(linha);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
linha = null;
regraItem = null;
modelItem = null;
}
}
public mItem BuscaUnicoRegistro(int idItem)
{
DataTable dtRetorno = null;
SqlParameter param = null;
mItem modelItem = new mItem();
try
{
param = new SqlParameter("@id_item", idItem);
dtRetorno = base.BuscaDados("sp_select_item", param);
modelItem.Deserialize(dtRetorno);
return(modelItem);
}
catch (Exception ex)
{
throw ex;
}
finally
{
param = null;
if (dtRetorno != null)
{
dtRetorno.Dispose();
dtRetorno = null;
}
modelItem = null;
}
}
/// <summary>
/// Completa a lista de model Item peca com o id do item que foi gravado no Banco de dados
/// </summary>
/// <param name="modelItem">model do item onde esta o id</param>
private void CompletaListaModelItemPeca(mItem modelItem)
{
foreach (mItemPeca model in this._modelItemPeca)
{
model.Id_item = modelItem.Id_item;
}
}
/// <summary>
/// Pega os dados da tela e popula o model de Item
/// </summary>
/// <returns>model item populado</returns>
private mItem PegaDadosTelaItem()
{
mItem model = new mItem();
rItem regra = new rItem();
try
{
model.Dat_alt = DateTime.Now;
model.Flg_ativo = true;
model.Id_item = regra.BuscaIdMaximo();
model.Id_item_real = this.txtCodigoItem.Text;
model.Nom = this.txtNmItem.Text;
return(model);
}
catch (Exception ex)
{
throw ex;
}
finally
{
model = null;
regra = null;
}
}
private void ValidaDados(mItem model)
{
if (this.ExisteItemReal(model.Id_item_real) == true)
{
throw new Exceptions.Item.CodigoRealItemExistenteException();
}
else if (this.ExisteItemNome(model.Nom) == true)
{
throw new Exceptions.Item.NomeItemExistenteException();
}
}
public ActionResult DeleteItem(string ItemCode)
{
mItem item = new mItem();
item = (from u in db.mItems.ToList()
where u.ItemCode == ItemCode
select u).FirstOrDefault();
item.Is_Deleted = true;
item.Update_Date = DateTime.Now;
item.Update_User = user.UserID;
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
private void SelectTagsForMonitor()
{
mItem selectedTag = (mItem)dgrid_Tags.SelectedItem;
mTag tag = new mTag(selectedTag.Name, selectedTag.Path);
var contain = Model.opcSubscribedTags.Any(t => t.Name == tag.Name);
if (!contain)
{
mTag newTag = (mTag)dgrid_Subscribed.SelectedItem as mTag;
var mt = Model.opcSubscribedTags.FirstOrDefault(t => t.NameInDb == newTag.NameInDb);
mt.Name = tag.Name;
mt.Path = tag.Path;
}
}
public ActionResult EditItem(mItem itemdata)
{
try
{
mItem item = new mItem();
item = (from u in db.mItems.ToList()
where u.ItemCode == itemdata.ItemCode
select u).FirstOrDefault();
item.ItemName = itemdata.ItemName;
item.Description = itemdata.Description;
item.CusSupCode = itemdata.CusSupCode;
item.CargoClass = itemdata.CargoClass;
item.BaseMeasurement = itemdata.BaseMeasurement;
item.Update_User = "******";
item.Update_Date = DateTime.Now;
mItem checker = (from c in db.mItems
where c.ItemName == item.ItemName &&
c.Description == item.Description &&
c.CusSupCode == item.CusSupCode &&
c.CargoClass == item.CargoClass &&
c.BaseMeasurement == item.BaseMeasurement &&
c.SiteCode == item.SiteCode
select c).FirstOrDefault();
if (checker == null)
{
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
}
else
{
return(Json(new { result = "failed" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception err) { }
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateItem(mItem item)
{
item.SiteCode = System.Web.HttpContext.Current.Session["user"].ToString();
string gencode = string.Empty;
string lastgencode = (from u in db.mItems.ToList()
orderby u.ItemCode descending
select u.ItemCode).FirstOrDefault();
if (lastgencode == null)
{
gencode = "ITM0001";
}
else
{
gencode = lastgencode.Substring(3);
int upId = Convert.ToInt32(gencode.TrimStart(new char[] { '0' })) + 1;
gencode = string.Format("ITM{0}", upId.ToString().PadLeft(4, '0'));
}
item.ItemCode = gencode;
item.Is_Deleted = false;
item.Create_Date = DateTime.Now;
item.Create_User = user.UserID;
item.Update_Date = DateTime.Now;
item.Update_User = user.UserID;
mItem checker = (from c in db.mItems
where c.ItemName == item.ItemName &&
c.Description == item.Description &&
c.CusSupCode == item.CusSupCode &&
c.CargoClass == item.CargoClass &&
c.BaseMeasurement == item.BaseMeasurement &&
c.SiteCode == item.SiteCode &&
c.Is_Deleted == false
select c).FirstOrDefault();
if (checker == null)
{
try
{
db.mItems.Add(item);
db.SaveChanges();
mItemPrice itemprice = new mItemPrice();
itemprice.ItemCode = gencode;
itemprice.Is_Deleted = false;
itemprice.Create_Date = DateTime.Now;
itemprice.Create_User = user.UserID;
itemprice.Update_Date = DateTime.Now;
itemprice.Update_User = user.UserID;
db.mItemPrices.Add(itemprice);
db.SaveChanges();
}
catch (Exception err) { }
}
else
{
return(Json(new { result = "failed" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
public ActionResult SetInbound(INinboundSet InboundItem, STstockInventoryDetail stockdetails, ItemUnitModel itemunit)
{
InboundItem.Is_Deleted = false;
InboundItem.Create_Date = DateTime.Now;
InboundItem.Create_User = user.UserID;
InboundItem.Update_Date = DateTime.Now;
InboundItem.Update_User = user.UserID;
string DateID = DateTime.Now.ToString("yyyyMMdd");
string gencode = string.Empty;
string lastgencode = (from u in db.INinboundSets.ToList()
orderby u.InboundNoResult descending
select u.InboundNoResult).FirstOrDefault();
if (lastgencode == null)
{
gencode = DateID + "INR0000001";
}
else
{
gencode = lastgencode.Substring(11);
int upId = Convert.ToInt32(gencode.TrimStart(new char[] { '0' })) + 1;
gencode = DateID + string.Format("INR{0}", upId.ToString().PadLeft(7, '0'));
}
InboundItem.InboundNoResult = gencode;
try
{
db.INinboundSets.Add(InboundItem);
db.SaveChanges();
string gencodes = string.Empty;
string lastgencodes = (from u in db.STstockInventoryDetails.ToList()
orderby u.StockDetailCode descending
select u.StockDetailCode).FirstOrDefault();
if (lastgencodes == null)
{
gencodes = DateID + "STD0000001";
}
else
{
gencodes = lastgencodes.Substring(11);
int upId = Convert.ToInt32(gencodes.TrimStart(new char[] { '0' })) + 1;
gencodes = DateID + string.Format("STD{0}", upId.ToString().PadLeft(7, '0'));
}
INinboundPlan inboundplan = (from c in db.INinboundPlans where c.InboundPlanCode == InboundItem.InboundPlanCode select c).FirstOrDefault();
mItem itemcurrent_main = (from c in db.mItems where c.ItemCode == InboundItem.ItemCode select c).FirstOrDefault();
INinboundItem inboundplanitem = (from c in db.INinboundItems where c.InboundPlanCode == InboundItem.InboundPlanCode && c.ItemCode == itemcurrent_main.ItemCode select c).FirstOrDefault();
stockdetails.StockCode = (from c in db.STstockInventories where c.InboundPlanCode == InboundItem.InboundPlanCode select c.StockCode).FirstOrDefault();
stockdetails.InboundPlanNo = inboundplan.InboundPlanCode;
stockdetails.InboundNoResult = gencode; //Inbound result Gen code
stockdetails.StockDetailCode = gencodes; //Stock Details Code
stockdetails.ItemCode = inboundplanitem.ItemCode;
stockdetails.ExpiredDate = inboundplanitem.ExpirationDate;
stockdetails.InboundDate = inboundplan.InboundPlanDate;
stockdetails.ActualStockQty = InboundItem.ActualReceived;
stockdetails.AllocatedQty = 0;
stockdetails.PickedQty = 0;
stockdetails.LocationCode = InboundItem.Location;
stockdetails.LocationSubCode = InboundItem.SubLocation;
stockdetails.LotNo = inboundplanitem.LotNo;
stockdetails.PONo = inboundplanitem.PoNo;
stockdetails.SupplierCode = itemcurrent_main.CusSupCode;
stockdetails.SupplierCode = itemcurrent_main.CusSupCode;
stockdetails.OriginalItemCode = itemcurrent_main.ItemCode;
stockdetails.CaseQty = itemunit.pqc_q;
stockdetails.QtyPerCase = itemunit.QtyPerCase;
stockdetails.InnerCaseQty = itemunit.qpic_q;
stockdetails.InnerQtyPerCase = itemunit.QtyPerInnerCase;
stockdetails.UnitQty = itemunit.QtyPerUnit;
//stockdetails.NW = (itemunit.QtyPerCase + itemunit.QtyPerInnerCase + itemunit.QtyPerUnit) * itemcurrent_unit.Where(c => c.Type == "") sa sunod na to
stockdetails.LastInboundDate = DateTime.Now;
//stockdetails.LastOutboundDate = DateTime.Now;
stockdetails.SlipClass = inboundplan.SlipClass;
stockdetails.SlipDate = inboundplan.SlipDate;
stockdetails.SlipNo = inboundplan.SlipNo;
stockdetails.SlipRemarks = inboundplan.Remarks;
stockdetails.Is_Deleted = false;
stockdetails.Create_Date = DateTime.Now;
stockdetails.Create_User = user.UserID;
stockdetails.Update_Date = DateTime.Now;
stockdetails.Update_User = user.UserID;
db.STstockInventoryDetails.Add(stockdetails);
db.SaveChanges();
}
catch (Exception err) { }
return(Json(new { result = "success", InboundItem = InboundItem }, JsonRequestBehavior.AllowGet));
}
