public ActionResult ExportCounterParty(CounterPartyListSeachModel input)
{
using (XLWorkbook wb = new XLWorkbook())
{
//input.fromDate = DateTime.ParseExact(input.fromDate.Value.ToString("MM/dd/yyyy"), "dd/MM/yyyy", null);
//input.toDate = DateTime.ParseExact(input.toDate.Value.ToString("MM/dd/yyyy"), "dd/MM/yyyy", null);
input.length = 0;
var data = _counterPartyService.searchCounterParty(input);
if (data.resultList.Any())
{
wb.Worksheets.Add(MapModelToNewTableCounterParty(data.resultList), "CounterPartyTemplate");
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", $"attachment;filename={DateTime.Now:yyyyMMdd}_CounterPartyTemplate.xlsx");
using (MemoryStream myMemoryStream = new MemoryStream())
{
wb.SaveAs(myMemoryStream);
myMemoryStream.WriteTo(Response.OutputStream);
Response.End();
return(Content("Success"));
}
}
return(Content("No Data"));
}
}
public CounterPartySearchModel searchCounterParty(CounterPartyListSeachModel model)
{
try
{
CounterPartySearchModel resultObject = new CounterPartySearchModel();
SqlParameter[] prms = new SqlParameter[]
{
new SqlParameter {
ParameterName = "fromDate", DbType = DbType.Date, Value = model.fromDate == null ? (object)DBNull.Value : model.fromDate, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "toDate", DbType = DbType.Date, Value = model.toDate == null ? (object)DBNull.Value : model.toDate, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "cif", DbType = DbType.String, Value = model.cif == null ? (object)DBNull.Value : model.cif, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "shortName", DbType = DbType.String, Value = model.shortName == null ? (object)DBNull.Value : model.shortName, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "cpGroupCode", DbType = DbType.String, Value = model.cpGroupCode == null ? (object)DBNull.Value : model.cpGroupCode, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "userUpdated", DbType = DbType.String, Value = model.userUpdated == null ? (object)DBNull.Value : model.userUpdated, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "status", DbType = DbType.String, Value = model.status == null ? (object)DBNull.Value : model.status, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "pageNumber", DbType = DbType.Int32, Value = model.pageNumber, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "pageSize", DbType = DbType.Int32, Value = model.pageSize, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "resultMessage", DbType = DbType.String, Direction = ParameterDirection.Output, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "resultCode", DbType = DbType.Int32, Direction = ParameterDirection.Output, Size = Int32.MaxValue
}
};
var result = _Repository.ExecWithStoreProcedureCommand(Store_searchCounterParty, prms);
if (result.errorCode == 0)
{
resultObject = JsonConvert.DeserializeObject <CounterPartySearchModel>(result.errorMessage);
}
return(resultObject);
}
catch (Exception ex)
{
HDBH.Log.WriteLog.Error("CounterPartyService => searchCounterParty", ex);
return(null);
}
}
public JsonResult Search(CounterPartyListSeachModel model)
{
var result = new CounterPartySearchModel();
result = _counterPartyService.searchCounterParty(model);
return(Json(new
{
recordsTotal = result.totalRecord,
recordsFiltered = result.totalRecord,
data = result.resultList
}));
}
