public static List <CCO> GetCCO(string criteria, int intIDMasLocation) { var dbUtil = new DatabaseManager(); var dCCO = new List <CCO>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spGetEmployeeCCO"; cmd.CommandTimeout = 180; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@strCriteria", criteria); cmd.Parameters.AddWithValue("@intIDMasLocation", intIDMasLocation); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var drcrCCO = new CCO { ID = ReferenceEquals(reader["ID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["ID"]), strName = ReferenceEquals(reader["strName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strName"]), }; dCCO.Add(drcrCCO); } return(dCCO); } } } }
public void DeletVehicleServiceCompany(string uid, VehicleServiceCompany VehicleServiceCompany) { VehicleServiceCompanyOwner CurrentOwner = ServiceBookContext.VehicleServiceCompanyOwner.FirstOrDefault(x => x.UID == uid); CCO deletVehicleServiceCompany = ServiceBookContext.CCO.FirstOrDefault(x => x.COID == CurrentOwner.ID && x.CID == VehicleServiceCompany.ID); if (deletVehicleServiceCompany.VehicleServiceCompany != null) { if (deletVehicleServiceCompany.VehicleServiceCompany.WorkingPoints != null) { foreach (var workingPoint in deletVehicleServiceCompany.VehicleServiceCompany.WorkingPoints) { WorkingPointRepository.DeletWorkingPoint(workingPoint); } } } ServiceBookContext.CCO.Remove(deletVehicleServiceCompany); ServiceBookContext.SaveChanges(); }
public CCO AddVehicleServiceCompany(string uid, VehicleServiceCompany VehicleServiceCompany) { VehicleServiceCompanyOwner CurrentOwner = ServiceBookContext.VehicleServiceCompanyOwner.FirstOrDefault(x => x.UID == uid); VehicleServiceCompany Company = ServiceBookContext.VehicleServiceCompany.FirstOrDefault(x => x.ServiceName == VehicleServiceCompany.ServiceName); var CCO = ServiceBookContext.CCO.FirstOrDefault(x => x.VehicleServiceCompanyOwner.ID == CurrentOwner.ID && x.VehicleServiceCompany.ServiceName == VehicleServiceCompany.ServiceName); CCO cco = new CCO(); if (CCO == null) { cco.VehicleServiceCompanyOwner = CurrentOwner; if (Company != null) { cco.VehicleServiceCompany = Company; } else { cco.VehicleServiceCompany = VehicleServiceCompany; } cco.VehicleServiceCompany.Flag = 0; ServiceBookContext.CCO.Add(cco); ServiceBookContext.SaveChanges(); } else { if (CCO.VehicleServiceCompany.Flag == 0) { return(null); } CCO.VehicleServiceCompany.Flag = 0; ServiceBookContext.SaveChanges(); cco = CCO; } return(cco); }