public string CreateNewLocationGroup(LocationGroupEntity lge)
{
var locationGroupAlreadyExistsInPool =
LocationGroupEntityCheck.DoesLocationGroupNameExistForCountry(DataContext, lge.LocationGroupName,
lge.PoolId);
if (locationGroupAlreadyExistsInPool)
{
return(LocationGroupEntityCheck.LocationGroupAlreadyExistsForCountry);
}
var newLocationGroupEntity = new CMS_LOCATION_GROUP
{
IsActive = true,
cms_location_group1 = lge.LocationGroupName,
cms_location_group_code_dw = string.Empty,
cms_pool_id = lge.PoolId,
};
DataContext.CMS_LOCATION_GROUPs.InsertOnSubmit(newLocationGroupEntity);
var returned = SubmitDbChanges();
if (returned != string.Empty)
{
return(returned);
}
//Insert new MARS_CMS_NECESSARY_FLEET
var twoLetterCountryCode = DataContext.COUNTRies.Single(d => d.CountryId == lge.CountryId).country1;
int locationGroupId = newLocationGroupEntity.cms_location_group_id;
var allCarGroups = from cg in DataContext.CAR_GROUPs
where cg.CAR_CLASS.CAR_SEGMENT.COUNTRy1.CountryId == lge.CountryId
select cg.car_group_id;
var fleetToInsert = new List <MARS_CMS_NECESSARY_FLEET>();
foreach (var cg in allCarGroups)
{
fleetToInsert.Add(new MARS_CMS_NECESSARY_FLEET
{
COUNTRY = twoLetterCountryCode,
CMS_LOCATION_GROUP_ID = locationGroupId,
CAR_CLASS_ID = cg, //Not Car Class, NessFleet has bad column Naming
UTILISATION = 100,
NONREV_FLEET = 0,
});
}
DataContext.MARS_CMS_NECESSARY_FLEETs.InsertAllOnSubmit(fleetToInsert);
returned = SubmitDbChanges();
return(returned);
}
protected void btnSavePopup_Click(object sender, EventArgs e)
{
if (ddlPool.SelectedValue == string.Empty)
{
ProcessDatabaseReply("A Pool must be selected", "", AdminMappingEnum.CmsLocationGroup, lblMessage);
return;
}
var lge = new LocationGroupEntity
{
Id = int.Parse(hfLocationGroupId.Value),
PoolId = int.Parse(ddlPool.SelectedValue),
CountryId = int.Parse(ddlCountry.SelectedValue),
LocationGroupName = tbLocationGroup.Text,
Active = cbActive.Checked
};
SaveDataToDataBase(lge);
}
private void SaveDataToDataBase(LocationGroupEntity lge)
{
string message;
if (lge.Id == 0)
{
//lge.CountryId = int.Parse(ddlCountry.SelectedValue);
using (var dataAccess = new MappingDeleteAndCreate())
{
message = dataAccess.CreateNewLocationGroup(lge);
}
}
else
{
lge.Id = int.Parse(hfLocationGroupId.Value);
using (var dataAccess = new MappingSingleUpdate())
{
message = dataAccess.UpdateLocationGroup(lge);
}
}
ProcessDatabaseReply(message, UpdateLocationGroupSuccess, AdminMappingEnum.CmsLocationGroup, lblMessage);
}
public string UpdateLocationGroup(LocationGroupEntity lge)
{
var locationGroupAlreadyExistsInPool =
LocationGroupEntityCheck.DoesLocationGroupNameExistForCountry(DataContext, lge.LocationGroupName,
lge.PoolId, lge.Id);
if (locationGroupAlreadyExistsInPool)
{
return(LocationGroupEntityCheck.LocationGroupAlreadyExistsForCountry);
}
var locationGroupDbEntry =
DataContext.CMS_LOCATION_GROUPs.Single(d => d.cms_location_group_id == lge.Id);
locationGroupDbEntry.cms_pool_id = lge.PoolId;
locationGroupDbEntry.cms_location_group1 = lge.LocationGroupName;
locationGroupDbEntry.IsActive = lge.Active;
var returned = SubmitDbChanges();
return(returned);
}
