public List <CreditNoteListEntity> GetAllSalesCreditJson(string JsonData, bool?ExcincTax) { string ignored = string.Empty; List <CreditNoteListEntity> CreditList = new List <CreditNoteListEntity>(); CreditNoteListEntity CreditList1 = new CreditNoteListEntity(); List <CreditNoteListEntity> CreditListReturn = new List <CreditNoteListEntity>(); if (JsonData != null) { var objResponse1 = JsonConvert.DeserializeObject <List <SearchEntity> >(JsonData); CreditList = entities.Database.SqlQuery <CreditNoteListEntity>("USP_CreditNoteList @year,@Quarter,@Month,@ShowAll,@SDate,@EDate", new SqlParameter("Year", Convert.ToInt32(objResponse1[0].FieldValue)), new SqlParameter("Quarter", Convert.ToInt32(objResponse1[1].FieldValue)), new SqlParameter("Month", Convert.ToInt32(objResponse1[2].FieldValue)), new SqlParameter("ShowAll", Convert.ToBoolean(objResponse1[3].FieldValue)), new SqlParameter("SDate", objResponse1[4].FieldValue), new SqlParameter("EDate", objResponse1[5].FieldValue) ).ToList(); } else { ignored = JsonConvert.SerializeObject(JsonData, Formatting.Indented, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore }); CreditList = entities.Database.SqlQuery <CreditNoteListEntity>("USP_CreditNoteList @year,@Quarter,@Month,@ShowAll,@SDate,@EDate", new SqlParameter("Year", Convert.ToInt32(0)), new SqlParameter("Quarter", Convert.ToInt32(0)), new SqlParameter("Month", Convert.ToInt32(0)), new SqlParameter("ShowAll", Convert.ToBoolean(1)), new SqlParameter("SDate", ""), new SqlParameter("EDate", "") ).ToList(); } return(CreditList); }
public List <CreditNoteListEntity> GetAllSalesCreditJson(string JsonData, bool?ExcincTax) { List <CreditNoteListEntity> CreditList = new List <CreditNoteListEntity>(); CreditNoteListEntity CreditList1 = new CreditNoteListEntity(); List <CreditNoteListEntity> CreditListReturn = new List <CreditNoteListEntity>(); CreditList = entities.Database.SqlQuery <CreditNoteListEntity>("PRC_CreditNoteList").ToList(); if (JsonData != null && JsonData != "[]") { DateTime startDate = new DateTime(); var objResponse1 = JsonConvert.DeserializeObject <List <SearchEntity> >(JsonData); foreach (var item in objResponse1) { switch (item.FieldName) { case "Year": var year = Convert.ToInt32(item.FieldValue); CreditList = CreditList.Where(x => x.CreditDateDateTime.Value.Year == year).ToList(); break; case "Quarter": switch (item.FieldValue) { case "1": CreditList = CreditList.Where(x => x.CreditDateDateTime.Value.Month == 1 || x.CreditDateDateTime.Value.Month == 2 || x.CreditDateDateTime.Value.Month == 3).ToList(); break; case "2": CreditList = CreditList.Where(x => x.CreditDateDateTime.Value.Month == 4 || x.CreditDateDateTime.Value.Month == 5 || x.CreditDateDateTime.Value.Month == 6).ToList(); break; case "3": CreditList = CreditList.Where(x => x.CreditDateDateTime.Value.Month == 7 || x.CreditDateDateTime.Value.Month == 8 || x.CreditDateDateTime.Value.Month == 9).ToList(); break; case "4": CreditList = CreditList.Where(x => x.CreditDateDateTime.Value.Month == 10 || x.CreditDateDateTime.Value.Month == 11 || x.CreditDateDateTime.Value.Month == 12).ToList(); break; } break; case "Month": var month = Convert.ToInt32(item.FieldValue); CreditList = CreditList.Where(x => x.CreditDateDateTime.Value.Month == month).ToList(); break; case "StartDate": startDate = Convert.ToDateTime(item.FieldValue); //CreditList = CreditList.Where(x => x.CreditDateDateTime ).ToList(); break; case "EndDate": DateTime endDate = Convert.ToDateTime(item.FieldValue); CreditList = CreditList.Where(x => x.CreditDateDateTime > startDate && x.CreditDateDateTime < endDate).ToList(); break; } } CreditListReturn = CreditList; } else { CreditListReturn = CreditList; } return(CreditListReturn); }