Beispiel #1
0
        public static int SaveFuneralService(FuneralServiceSelectModel model)
        {
            string query = "SaveFuneralService";

            DbParameter[] ObjParam = new DbParameter[7];

            ObjParam[0] = new DbParameter("@fkiFuneralID", DbParameter.DbType.Int, 0, model.fkiFuneralID);
            ObjParam[1] = new DbParameter("@fkiServiceID", DbParameter.DbType.Int, 0, model.fkiServiceID);
            ObjParam[2] = new DbParameter("@Quantity", DbParameter.DbType.Int, 0, model.Quantity);
            ObjParam[3] = new DbParameter("@LastModified", DbParameter.DbType.DateTime, 0, model.lastModified);
            ObjParam[4] = new DbParameter("@ModifiedUser", DbParameter.DbType.VarChar, 0, model.modifiedUser);
            ObjParam[5] = new DbParameter("@ServiceRate", DbParameter.DbType.Money, 0, model.ServiceRate);
            ObjParam[6] = new DbParameter("@pkiFuneralServiceSelectionID", DbParameter.DbType.Int, 0, model.pkiFuneralServiceSelectionID);

            return(Convert.ToInt32(DbConnection.GetScalarValue(CommandType.StoredProcedure, query, ObjParam)));
        }
Beispiel #2
0
 public int SaveFuneralService(FuneralServiceSelectModel model)
 {
     return(FuneralBAL.SaveFuneralService(model));
 }