public WrapperChecklistTemplate CreateSingleChecklistTemplate(ChecklistTemplateENT Obj)
{
WrapperChecklistTemplate data = new WrapperChecklistTemplate();
data.ChecklistTemplate = new ChecklistTemplateCRUD().CreateSingle(Obj);
return(data);
}
public ChecklistTemplateENT UpdateSelectSingle(ChecklistTemplateENT Obj)
{
NbkDbEntities dbcontext = new NbkDbEntities();
ChecklistTemplate Data = new ChecklistTemplate()
{
Id = Obj.Id,
Title = Obj.Title,
IsDefault = Obj.IsDefault
};
dbcontext.ChecklistTemplate.Attach(Data);
var update = dbcontext.Entry(Data);
update.Property(x => x.Title).IsModified = true;
update.Property(x => x.IsDefault).IsModified = true;
dbcontext.SaveChanges();
if (Obj.ServiceSelectedID > 0)
{
var ServiceDetail = dbcontext.Service.Where(x => x.Id == Obj.ServiceSelectedID).FirstOrDefault();
ServiceDetail.ChecklistTempId = Obj.Id;
dbcontext.SaveChanges();
var PreviousService = dbcontext.Service.Where(x => x.ChecklistTempId == Obj.Id && x.Id != Obj.ServiceSelectedID).FirstOrDefault();
if (PreviousService != null)
{
PreviousService.ChecklistTempId = null;
dbcontext.SaveChanges();
}
}
return(Obj);
}
public ChecklistTemplateENT CreateSingle(ChecklistTemplateENT Obj)
{
NbkDbEntities dbcontext = new NbkDbEntities();
ChecklistTemplate Data = new ChecklistTemplate()
{
Title = Obj.Title,
IsDefault = Obj.IsDefault
};
dbcontext.ChecklistTemplate.Add(Data);
dbcontext.SaveChanges();
Obj.Id = Data.Id;
if (Convert.ToInt32(Obj.ServiceSelectedID) > 0)
{
dbcontext = new NbkDbEntities();
var ServiceDetail = dbcontext.Service.Where(x => x.Id == Obj.ServiceSelectedID).FirstOrDefault();
ServiceDetail.ChecklistTempId = Obj.Id;
dbcontext.SaveChanges();
dbcontext = new NbkDbEntities();
var PreviousService = dbcontext.Service.Where(x => x.ChecklistTempId == Obj.Id && x.Id != Obj.ServiceSelectedID).FirstOrDefault();
if (PreviousService != null)
{
PreviousService.ChecklistTempId = null;
dbcontext.SaveChanges();
}
}
if (Obj.ChecklistItemTemplateList.Count > 0)
{
foreach (var item in Obj.ChecklistItemTemplateList)
{
dbcontext = new NbkDbEntities();
ChecklistItemTemplate DataItems = new ChecklistItemTemplate()
{
Title = item.Title,
ChecklistId = item.ChecklistId
};
dbcontext.ChecklistItemTemplate.Add(DataItems);
dbcontext.SaveChanges();
item.Id = DataItems.Id;
}
}
return(Obj);
}
public ChecklistTemplateENT SelectSingle(int Id)
{
NbkDbEntities dbcontext = new NbkDbEntities();
ChecklistTemplate Obj = dbcontext.ChecklistTemplate.Where(x => x.Id == Id).FirstOrDefault();
List <ChecklistItemTemplate> ChecklistItemTemplateList = dbcontext.ChecklistItemTemplate.Where(x => x.ChecklistId == Obj.Id).ToList();
if (ChecklistItemTemplateList == null)
{
ChecklistItemTemplateList.Add(new ChecklistItemTemplate());
}
Service CheckListAttchedWithService = dbcontext.Service.Where(x => x.ChecklistTempId == Obj.Id).FirstOrDefault();
if (CheckListAttchedWithService == null)
{
CheckListAttchedWithService = new Service();
}
ChecklistTemplateENT Data = new ChecklistTemplateENT()
{
Id = Obj.Id,
Title = Obj.Title,
IsDefault = Obj.IsDefault,
ChecklistItemTemplateList = new List <ChecklistItemTemplateENT>
(
ChecklistItemTemplateList.Select(j => new ChecklistItemTemplateENT
{
Id = j.Id,
ChecklistId = j.ChecklistId,
Title = j.Title
})
),
CheckListAttchedWithService = new ServiceItemTemplateENT()
{
Id = CheckListAttchedWithService.Id,
ChecklistTempId = CheckListAttchedWithService.ChecklistTempId,
Description = CheckListAttchedWithService.Description,
Name = CheckListAttchedWithService.Name,
Rate = CheckListAttchedWithService.Rate,
ServiceChargedAs = CheckListAttchedWithService.ServiceChargedAs,
ServiceTypeId = CheckListAttchedWithService.ServiceTypeId
}
};
return(Data);
}
