public BusMessageModel Create(BusCategoryModel model)
{
if (IsExists(model.BusCategoryId, model.BusCategoryName) == false)
{
TravelPortalEntity.Bus_Categories obj = new TravelPortalEntity.Bus_Categories
{
BusCategoryName = model.BusCategoryName,
};
_ent.AddToBus_Categories(obj);
_ent.SaveChanges();
_res.ActionMessage = String.Format(Resources.Message.SuccessfullyCreated, "Bus Category ");
_res.ErrSource = "DataBase";
_res.MsgType = 0;
_res.MsgNumber = 0;
_res.MsgStatus = true;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.AlreadyExist, "Bus Category ");
_res.MsgNumber = 1001;
_res.ErrSource = "DataBase";
_res.MsgType = 3;
_res.MsgStatus = true;
}
return(_res);
}
public string UpdateCategory()
{
string result = "Failed";
BusApi.BusApiClient _api = new BusApi.BusApiClient();
BusApi.BusCategoryRequest _req = new BusApi.BusCategoryRequest();
_req.Auth = BusGeneralProvider.AAuth;
_req.MaxResult = 10000;
_req.BusCatagoryName = "";
_req.BusOperatorCode = "";
var onlineresult = _api.CategoryList(_req);
if (onlineresult != null && onlineresult.List.Any())
{
var localresult = _ent.Bus_Categories;
foreach (var item in onlineresult.List)
{
bool addnew = true;
foreach (var localitem in localresult)
{
if (item.CategoryId == localitem.CategoryCode)
{
// edit data....
var editData = _ent.Bus_Categories.FirstOrDefault(x => x.CategoryCode == item.CategoryId);
editData.BusCategoryName = item.CatagoryName;
editData.OperatoCode = item.OperatorId;
_ent.ApplyCurrentValues(editData.EntityKey.EntitySetName, editData);
//_ent.SaveChanges();
addnew = false;
}
}
if (addnew == true)
{
//add data....
TravelPortalEntity.Bus_Categories obj = new TravelPortalEntity.Bus_Categories
{
BusCategoryName = item.CatagoryName,
CategoryCode = item.CategoryId,
OperatoCode = item.OperatorId
};
_ent.AddToBus_Categories(obj);
//_ent.SaveChanges();
}
}
_ent.SaveChanges();
result = "Updated";
}
return(result);
}