public int UpdateVAT(Models.AppEquipmentTable data) { try { SqlParameter pOriginal = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnamevatoutput), this._paramnamevatupdate); var parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray(); this._db.Database.ExecuteSqlCommand(this._storeNameVATU, parameters); return(data.EquipmentID); } catch (Exception) { throw; } }
public int InsertVAT(Models.AppEquipmentTable data) { try { SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnamevatoutput).ToArray(); this._db.Database.ExecuteSqlCommand(this._storeNameVATI, parameters); data.EquipmentID = (int)parameters.GetValueSqlParam(this._paramnamevatoutput); return(data.EquipmentID); } catch (Exception) { throw; } }