public static void DeleteObjectOfTransactionFromDb(ObjectOfTransaction objectOfTransaction) { using (var db = new DB_Context()) { db.ObjectOfTransactions.Remove(db.ObjectOfTransactions.Find(objectOfTransaction.ObjectOfTransactionID)); db.SaveChanges(); } }
public static void AddObjectOfTransactionToDb(ObjectOfTransaction objectOfTransaction) { using (var db = new DB_Context()) { db.ObjectOfTransactions.Add(objectOfTransaction); db.SaveChanges(); } }
public static ViewObjOfTransact ConvertObjOfTransact(ObjectOfTransaction obj) { return new ViewObjOfTransact { ObjectOfTransactionID = obj.ObjectOfTransactionID, UserID = obj.UserID, UserInfo = DataManager.GetuUserFromDbById(obj.UserID).ToString(), ObjectType = (EnumObjectType)obj.ObjectTypeID, ObjectState = (EnumObjectState)obj.ObjectStateID, ServiceType = (EnumServiceType)obj.ServiceTypeID, KindOfCalculating = (EnumKindOfCalculating)obj.KindOfCalculatingID, Cost = obj.Cost, Description = obj.Description }; }
public static void UpdateObjectOfTransactionFromDb(ObjectOfTransaction objectOfTransaction) { using (var db = new DB_Context()) { var obj = db.ObjectOfTransactions.Find(objectOfTransaction.ObjectOfTransactionID); obj.ObjectTypeID = objectOfTransaction.ObjectTypeID; obj.ServiceTypeID = objectOfTransaction.ServiceTypeID; obj.KindOfCalculatingID = objectOfTransaction.KindOfCalculatingID; obj.UserID = objectOfTransaction.UserID; obj.ObjectStateID = objectOfTransaction.ObjectStateID; obj.Cost = objectOfTransaction.Cost; obj.Description = objectOfTransaction.Description; db.SaveChanges(); } }