public bool deleteCount(CountEntity obj)
{
Count count = new Count
{
CountId = obj.CountId,
Blend = obj.Blend,
CountName = obj.CountName,
SingleDouble = obj.SingleDouble,
CreatedBy = obj.CreatedBy,
CreatedOn = obj.CreatedOn,
Description = obj.Description,
ModifiedBy = obj.ModifiedBy,
ModifiedOn = obj.ModifiedOn
};
using (var db = new textilaEntities())
{
try
{
db.Counts.Remove(count);
}
catch (Exception)
{
return(false);
}
return(true);
}
}
public bool updateCount(int id, CountEntity obj)
{
Count count = new Count
{
CountId = id,
Blend = obj.Blend,
CountName = obj.CountName,
SingleDouble = obj.SingleDouble,
CreatedBy = obj.CreatedBy,
CreatedOn = obj.CreatedOn,
Description = obj.Description,
ModifiedBy = obj.ModifiedBy,
ModifiedOn = obj.ModifiedOn
};
using (var db = new textilaEntities())
{
try
{
var result = db.Counts.SingleOrDefault(b => b.CountId == id);
db.Entry(result).CurrentValues.SetValues(count);
db.SaveChanges();
}
catch (Exception)
{
return(false);
}
}
return(true);
}
public BlendEntity getBlendById(int id)
{
using (var db = new textilaEntities())
{
return(db.Blends.Where(e => e.BlendId == id).Select(e => new BlendEntity
{
BlendId = e.BlendId,
BlendName = e.BlendName
}).FirstOrDefault());
}
}
public List <CountEntity> getAllCounts()
{
using (var db = new textilaEntities())
{
return(db.Counts.ToList().Select(e => new CountEntity {
Blend = e.Blend ?? 0,
CountId = e.CountId,
CountName = e.CountName,
SingleDouble = e.SingleDouble,
CreatedBy = e.CreatedBy,
CreatedOn = e.CreatedOn,
Description = e.Description,
ModifiedBy = e.ModifiedBy,
ModifiedOn = e.ModifiedOn
}).ToList());
}
}
public CountEntity getCountById(int id)
{
using (var db = new textilaEntities())
{
return(db.Counts.Where(e => e.CountId == id).Select(e => new CountEntity
{
Blend = e.Blend ?? 0,
CountId = e.CountId,
CountName = e.CountName,
SingleDouble = e.SingleDouble,
CreatedBy = e.CreatedBy,
CreatedOn = e.CreatedOn,
Description = e.Description,
ModifiedBy = e.ModifiedBy,
ModifiedOn = e.ModifiedOn,
BlendName = e.Blend1.BlendName
}).FirstOrDefault());
}
}
public List <BlendEntity> getAllBlends(string search)
{
using (var db = new textilaEntities())
{
List <Blend> blends;
if (string.IsNullOrWhiteSpace(search))
{
blends = db.Blends.ToList();
}
else
{
blends = db.Blends.Where(e => e.BlendName.Contains(search)).ToList();
}
return(blends.Select(e => new BlendEntity
{
BlendId = e.BlendId,
BlendName = e.BlendName
}).ToList());
}
}
public bool saveBlend(BlendEntity obj)
{
Blend blend = new Blend
{
BlendName = obj.BlendName
};
using (var db = new textilaEntities())
{
try
{
blend = db.Blends.Add(blend);
db.SaveChanges();
}
catch (Exception e)
{
return(false);
}
}
return(true);
}
public bool deleteBlend(BlendEntity obj)
{
Blend blend = new Blend
{
BlendId = obj.BlendId,
BlendName = obj.BlendName
};
using (var db = new textilaEntities())
{
try
{
db.Blends.Remove(blend);
}
catch (Exception)
{
return(false);
}
return(true);
}
}
public bool updateBlend(int id, BlendEntity obj)
{
Blend blend = new Blend
{
BlendId = id,
BlendName = obj.BlendName
};
using (var db = new textilaEntities())
{
try
{
var result = db.Blends.SingleOrDefault(b => b.BlendId == id);
//result = blend;
db.Entry(result).CurrentValues.SetValues(blend);
db.SaveChanges();
}
catch (Exception)
{
return(false);
}
}
return(true);
}
