public static int Insert(PurchaseOrderItem rec) { DBAccess db = new DBAccess(); if (rec.Status <= (int)PurchaseOrderItem_StatusEnum.Create) { rec.Status = PurchaseOrderItem_StatusEnum.Active; } AddParms(ref db, rec); SqlParameter objParam = new SqlParameter("@ID", 0); objParam.Direction = ParameterDirection.Output; db.Parameters.Add(objParam); int retval = db.ExecuteNonQuery(_SQLInsert); if (retval == 1) { int res = -1; res = Funktioner.ToInteger(objParam.Value); AddLog(Status: "PurchaseOrderItem", Logtext: string.Format("Create PurchaseOrderItem: ID:{0}", rec.ID), Metode: "Insert"); return(res); } else { AddLog(Status: "PurchaseOrderItem", Logtext: string.Format("Failure to create PurchaseOrderItem:"), logtype: LogTypeEnum.Error, Metode: "Insert"); return(-1); } }
public static string Tags(string tekst, RescueTekniq.BOL.PurchaseOrderItem item) { string res = ""; StringBuilder sb = new StringBuilder(); sb.Append(tekst); sb.Replace("[PURCHASEORDER.LINE.POS]", System.Convert.ToString(item.Pos)); sb.Replace("[PURCHASEORDER.LINE.STATUS]", item.StatusText); sb.Replace("[PURCHASEORDER.LINE.ITEMNAME]", item.ItemName); sb.Replace("[PURCHASEORDER.LINE.ITEMNO]", item.ItemNo); sb.Replace("[PURCHASEORDER.LINE.QUANTITY]", System.Convert.ToString(item.Quantity)); sb.Replace("[PURCHASEORDER.LINE.ITEMPRICE]", item.ItemPrice.ToString("C")); sb.Replace("[PURCHASEORDER.LINE.LINETOTAL]", item.LinePrice.ToString("C")); //.Replace("[PURCHASEORDER.LINE.VAT]", item.VAT.ToString) //.Replace("[PURCHASEORDER.LINE.FREIGHT]", item.Freight.ToString("C")) //.Replace("[PURCHASEORDER.LINE.LINETEXT]", item.LineText) //.Replace("[PURCHASEORDER.LINE.SERIALNO]", item.SerialNo) res = sb.ToString(); res = item.Item.Tags(res); return(res); }
public static System.Collections.Generic.List <PurchaseOrderItem> GetPurchaseOrderItemList(int PurchaseOrderID) { System.Collections.Generic.List <PurchaseOrderItem> result = new System.Collections.Generic.List <PurchaseOrderItem>(); PurchaseOrderItem rec = default(PurchaseOrderItem); DBAccess db = new DBAccess(); db.AddInt("PurchaseOrderID", PurchaseOrderID); SqlDataReader dr = default(SqlDataReader); try { dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectAll)); //CType(db.ExecuteReader(_SQLSelectAllID), SqlDataReader) if (dr.HasRows) { while (dr.Read()) { rec = new PurchaseOrderItem(); Populate(dr, rec); result.Add(rec); //(PurchaseOrderItem.GetPurchaseOrderItem(dr.DBtoInt("ID"))) } } dr.Close(); } catch (Exception ex) { throw (ex); } return(result); }
public static int Save(PurchaseOrderItem rec) { int retval = 0; if (rec.ID > 0) { retval = Update(rec); } else { retval = Insert(rec); } return(retval); }
public static int Update(PurchaseOrderItem rec) { DBAccess db = new DBAccess(); db.AddInt("ID", rec.ID); AddParms(ref db, rec); int retval = 0; //Try retval = db.ExecuteNonQuery(_SQLUpdate); //Catch //End Try AddLog(Status: "PurchaseOrderItem", Logtext: string.Format("Update PurchaseOrderItem: ID:{0}", rec.ID), Metode: "Update"); return(retval); }
public static PurchaseOrderItem GetPurchaseOrderItem(int ID) { DBAccess db = new DBAccess(); PurchaseOrderItem rec = new PurchaseOrderItem(); db.AddInt("ID", ID); SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectOne)); //CType(db.ExecuteReader(_SQLSelectOne), SqlDataReader) if (dr.HasRows) { while (dr.Read()) { Populate(dr, rec); } } if (!dr.IsClosed) { dr.Close(); } return(rec); }
private static void Populate(SqlDataReader dr, PurchaseOrderItem rec) { PopulateStandard(dr, rec); var with_1 = rec; with_1.PurchaseOrderID = System.Convert.ToInt32(dr.DBtoInt("PurchaseOrderID")); with_1.Pos = System.Convert.ToInt32(dr.DBtoInt("Pos")); with_1.Status = (RescueTekniq.BOL.PurchaseOrderItem_StatusEnum)(dr.DBtoInt("Status")); with_1.ItemID = System.Convert.ToInt32(dr.DBtoInt("ItemID")); with_1.ItemName = dr.DBtoString("ItemName"); with_1.SupplierItemID = dr.DBtoString("SupplierItemID"); with_1.SupplierItemName = dr.DBtoString("SupplierItemName"); with_1.SupplierID = System.Convert.ToInt32(dr.DBtoInt("SupplierID")); with_1.Quantity = System.Convert.ToDecimal(dr.DBtoDecimal("Quantity")); with_1.ItemPrice = System.Convert.ToDecimal(dr.DBtoDecimal("ItemPrice")); with_1._LinePrice = System.Convert.ToDecimal(dr.DBtoDecimal("LinePrice")); with_1._PurchaseOrder_TotalPrice = System.Convert.ToDecimal(dr.DBtoDecimal("PurchaseOrder_TotalPrice")); with_1.ExpectedReceiptDate = System.Convert.ToDateTime(dr.DBtoDateTime("ExpectedReceiptDate")); with_1.ReceiptDate = System.Convert.ToDateTime(dr.DBtoDateTime("ReceiptDate")); }
private static void AddParms(ref DBAccess db, PurchaseOrderItem rec) { var with_1 = rec; db.AddInt("PurchaseOrderID", with_1.PurchaseOrderID); db.AddInt("Pos", with_1.Pos); db.AddInt("Status", (System.Int32)with_1.Status); db.AddInt("ItemID", with_1.ItemID); db.AddNVarChar("ItemName", with_1.ItemName, 100); db.AddNVarChar("SupplierItemID", with_1.SupplierItemID, 50); db.AddNVarChar("SupplierItemName", with_1.SupplierItemName, 250); db.AddDecimal("Quantity", with_1.Quantity); db.AddMoney("ItemPrice", (double)with_1.ItemPrice); db.AddMoney("LinePrice", (double)with_1.LinePrice); db.AddDateTime("ExpectedReceiptDate", with_1.ExpectedReceiptDate); db.AddDateTime("ReceiptDate", with_1.ReceiptDate); AddParmsStandard(db, rec); }
public static int Delete(PurchaseOrderItem rec) { return(Delete(rec.ID)); }