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);
}
