public List <BookingVehicles> List(BookingVehicles model) { List <BookingVehicles> list = new List <BookingVehicles>(); BookingVehicles item; db.OpenConnection(); var cmd = db.CreateCommandStoredProcedure("sp_BookingVehicleGetList"); db.IntegerParameter(cmd, "@VehicleId", model.VehicleId); using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { item = new BookingVehicles { Id = Convert.ToInt32(dr["Id"]), StartDate = Convert.ToDateTime(dr["StartDate"]), EndDate = Convert.ToDateTime(dr["EndDate"]), Duration = Convert.ToDouble(dr["Duration"]), Price = Convert.ToDouble(dr["Price"]), IsCancel = Convert.ToBoolean(dr["IsCancel"]), Customer = new Customer { Id = Convert.ToInt32(dr["CustomerId"]), FirstName = dr["FirstName"].ToString(), LastName = dr["LastName"].ToString(), Caption = dr["Caption"].ToString(), IdentityNumber = dr["IdentityNumber"].ToString(), Birthdate = Convert.ToDateTime(dr["Birthdate"]), Gender = dr["Gender"].ToString().ToEnum <Gender>(), TaxNumber = dr["TaxNumber"].ToString(), TaxOffice = dr["TaxOffice"].ToString(), Mobile = dr["Mobile"].ToString(), HomePhone = dr["HomePhone"].ToString(), OfficePhone = dr["OfficePhone"].ToString(), IsActive = Convert.ToBoolean(dr["IsActiveCustomer"]) }, User = new User { Id = Convert.ToInt32(dr["UserId"]), UserName = dr["UserName"].ToString(), FirstName = dr["uFirstName"].ToString(), LastName = dr["uLastName"].ToString(), Email = dr["uEmail"].ToString(), IsActive = Convert.ToBoolean(dr["IsActiveUser"]) } }; list.Add(item); } } return(list); }
public BookingVehicles AddOrUpdate(BookingVehicles model) { db.OpenConnection(); var cmd = db.CreateCommandStoredProcedure("sp_BookingVehicleAddOrUpdate"); db.InOutParameter(cmd, "@Id", DbType.Int32, model.Id); db.DateParameter(cmd, "@StartDate", model.StartDate); db.DateParameter(cmd, "@EndDate", model.EndDate); db.DoubleParameter(cmd, "@Duration", model.Duration); db.IntegerParameter(cmd, "@VehicleId", model.VehicleId); db.IntegerParameter(cmd, "@CustomerId", model.CustomerId); db.IntegerParameter(cmd, "@UserId", model.UserId); db.DoubleParameter(cmd, "@Price", model.Price); db.BooleanParameter(cmd, "@IsCancel", model.IsCancel); cmd.ExecuteNonQuery(); if (cmd.Parameters["@Id"].Value != DBNull.Value) { model.Id = Convert.ToInt32(cmd.Parameters["@Id"].Value); } return(model); }