public int Insert(Models.AppVoucherTable data)
{
try
{
this.Validate(data);
data.CreatedBy = GlobalVariant.GetAppUser().UserID;
data.CreatedDateTime = DateTime.Now;
SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnameoutput).ToArray();
this._db.Database.ExecuteSqlCommand(this._storeNameI, parameters);
return((int)parameters.GetValueSqlParam(this._paramnameoutput));
}
catch (Exception)
{
throw;
}
}
public int Update(Models.AppVoucherTable data)
{
try
{
this.Validate(data);
data.ModifiedBy = GlobalVariant.GetAppUser().UserID;
data.ModifiedDateTime = DateTime.Now;
SqlParameter pOriginal = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnameoutput), this._paramnameupdate);
var parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray();
this._db.Database.ExecuteSqlCommand(this._storeNameU, parameters);
return(data.VoucherID);
}
catch (Exception)
{
throw;
}
}
