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);
}
