public IEnumerable <ItemData> GetAllItems()
{
using (WEBFORMSEntities dctx = new WEBFORMSEntities())
{
return(dctx.ItemDatas.ToList <ItemData>());
}
}
//Primary key is must in Child Table also so that related child object data cane be saved in child table
public List <Gender> GenderData()
{
using (WEBFORMSEntities dctx = new WEBFORMSEntities())
{
return(dctx.Genders.ToList <Gender>());
}
}
public IEnumerable <ItemData> GetAllItemsbyFromDate(DateTime fd1, DateTime fd2, string sortColumn)
{
//string sortColumn -- Added this parameter for Gridview sorting in Object datasource.. Grudview allows direct sortin gin SQLDatasource and dataset only , so some explicit handling required for Object datasource
//https://blog.michaelckennedy.net/2008/07/02/dynamic-data-access-with-linq/ This has a simple way of workaround for this
//I had issue in forming dynamic linq queries. it helped to solve with simple trick of using enum for propertoes to help in ording
//return ieie = dctx.ItemDatas.Where(d => d.FromDate >= fd1 & d.FromDate <= fd2).OrderBy(sortColumn).ToList<ItemData>();
//return ieie = dctx.ItemDatas.Where(d => d.FromDate >= fd1 & d.FromDate <= fd2).OrderBy(c => sortColumn).ToList<ItemData>();
//return dctx.ItemDatas.Where(d => d.FromDate >= fd1 & d.FromDate <= fd2).OrderBy(c => c.GetType().GetProperty(sortColumn).GetValue(c,null).ToString()).ToList<ItemData>();
//return dctx.ItemDatas.Where(d => d.FromDate >= fd1 & d.FromDate <= fd2).OrderBy(c => sortpropbyreflection.GetValue(c, null)).ToList<ItemData>();
//But able to sort always in ASC only , for dual way not tried - for that can consider ADO.NET as in Kudreference
using (WEBFORMSEntities dctx = new WEBFORMSEntities())
{
if (!string.IsNullOrEmpty(sortColumn))
{
ItemOrderProp prp = (ItemOrderProp)Enum.Parse(typeof(ItemOrderProp), sortColumn.Replace(" ", ""));
switch (prp)
{
case ItemOrderProp.AvailableCount:
return(dctx.ItemDatas.Where(d => d.FromDate >= fd1 & d.FromDate <= fd2).OrderBy(c => c.AvailableCount).ToList <ItemData>());
case ItemOrderProp.FromDate:
return(dctx.ItemDatas.Where(d => d.FromDate >= fd1 & d.FromDate <= fd2).OrderBy(c => c.FromDate).ToList <ItemData>());
}
}
return(dctx.ItemDatas.Where(d => d.FromDate >= fd1 & d.FromDate <= fd2).OrderBy(c => c.ProfileDetId).ToList <ItemData>());
}
}
public IEnumerable <GRIDSIMPLEEDIT> GetEDITLessItemsProp()
{
using (WEBFORMSEntities dctx = new WEBFORMSEntities())
{
return(dctx.GRIDSIMPLEEDITs.ToList());
}
}
public void CreateItem(ItemData ie)
{
using (WEBFORMSEntities dctx = new WEBFORMSEntities())
{
dctx.ItemDatas.Add(ie);
dctx.SaveChanges();
}
}
public IEnumerable <LessPropItemData> GetLessItemsProp()
{
using (WEBFORMSEntities dctx = new WEBFORMSEntities())
{
return(dctx.ItemDatas.Select(c => new LessPropItemData {
ProfDetID = c.ProfileDetId, IName = c.ItemName, IDesc = c.ItemDescription, AvailableCount = c.AvailableCount, FromDate = c.FromDate
}).Take(5).ToList <LessPropItemData>());
}
}
public List <GenderLinks> GenderlinkedTopicData(int GenderType)
{
using (WEBFORMSEntities dctx = new WEBFORMSEntities())
{
return(dctx.GenderlinkedTopics.Where(i => i.GID == GenderType).Select(i => new GenderLinks {
ID = i.ID, Topic = i.Topic
}).ToList <GenderLinks>());
}
}
public int DeteteItem(int ProfileDetId)
{
using (WEBFORMSEntities dctx = new WEBFORMSEntities())
{
ItemData dd = dctx.ItemDatas.Find(ProfileDetId);
dctx.ItemDatas.Remove(dd);
dctx.Entry(dd).State = System.Data.Entity.EntityState.Deleted;
return(dctx.SaveChanges());//Returns the number of affected rows[int]
}
}
public int UpdateItem(ItemData ie)
{
using (WEBFORMSEntities dctx = new WEBFORMSEntities())
{
ItemData olddata = dctx.ItemDatas.Find(ie.ProfileDetId);
olddata.ItemName = ie.ItemName;
dctx.Entry(olddata).State = System.Data.Entity.EntityState.Modified;
return(dctx.SaveChanges());//Returns the number of affected rows[int]
}
}
public static IEnumerable <IDataforNestedGrid> GetMultiInterests()
{
using (WEBFORMSEntities dctx = new WEBFORMSEntities())
{
return(dctx.ItemDatas.Select(s => new IDataforNestedGrid
{
ProfileDetId = s.ProfileDetId,
ItemName = s.ItemName
}).ToList <IDataforNestedGrid>());
}
}
public void GetEDITUpdateLessItemsProp(GRIDSIMPLEEDIT GE)
{
using (WEBFORMSEntities dctx = new WEBFORMSEntities())
{
//GRIDSIMPLEEDIT GEtu=dctx.GRIDSIMPLEEDITs.Find(ID);
//GEtu.TBOX = GE.TBOX;
//GEtu.CB = GE.CB;
//GEtu.RB = GE.RB;
//GEtu.DD = GE.DD;
//dctx.Entry(GEtu).State = System.Data.Entity.EntityState.Modified;
dctx.Entry(GE).State = System.Data.Entity.EntityState.Modified;
dctx.SaveChanges();
}
}