public List <SeasonModels> GetListSeason(string StoreID = null, string SeasonId = null, List <string> ListOrganizationId = null)
{
List <SeasonModels> listData = new List <SeasonModels>();
try
{
SeasonApiModels paraBody = new SeasonApiModels();
paraBody.AppKey = Commons.AppKey;
paraBody.AppSecret = Commons.AppSecret;
paraBody.CreatedUser = Commons.CreateUser;
paraBody.IsInventory = false;
paraBody.StoreID = StoreID;
paraBody.ID = SeasonId;
paraBody.ListOrgID = ListOrganizationId;
var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.GetSeason, null, paraBody);
dynamic data = result.Data;
var lstC = data["ListSeason"];
var lstContent = JsonConvert.SerializeObject(lstC /*result.RawData*/);
listData = JsonConvert.DeserializeObject <List <SeasonModels> >(lstContent);
return(listData);
}
catch (Exception e)
{
_logger.Error("Season_GetList: " + e);
return(listData);
}
}
public bool DeleteSeason(string ID, ref string msg)
{
try
{
SeasonApiModels paraBody = new SeasonApiModels();
paraBody.AppKey = Commons.AppKey;
paraBody.AppSecret = Commons.AppSecret;
paraBody.CreatedUser = Commons.CreateUser;
paraBody.RegisterToken = new RegisterTokenModels();
paraBody.ID = ID;
//====================
var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.DeleteSeason, null, paraBody);
if (result != null)
{
if (result.Success)
{
return(true);
}
else
{
msg = result.Message;
_logger.Error(result.Message);
return(false);
}
}
else
{
_logger.Error(result);
return(false);
}
}
catch (Exception e)
{
msg = e.ToString();
_logger.Error("Season_Delete: " + e);
return(false);
}
}
public bool InsertOrUpdateSeason(SeasonModels model, ref string msg)
{
try
{
SeasonApiModels paraBody = new SeasonApiModels();
SeasonModels SeasonDTO = new SeasonModels();
SeasonDTO.ID = model.ID;
SeasonDTO.Name = model.Name;
SeasonDTO.StartDate = new DateTime(model.StartDate.Year, model.StartDate.Month, model.StartDate.Day,
12, 0, 0);
SeasonDTO.EndDate = new DateTime(model.EndDate.Year, model.EndDate.Month, model.EndDate.Day,
12, 0, 0);
if (model.Unlimited)
{
SeasonDTO.StartTime = model.StartTime;
SeasonDTO.EndTime = model.EndTime;
}
else
{
SeasonDTO.StartTime = model.StartDate.Add(model.TStartTime);
SeasonDTO.EndTime = model.EndDate.Add(model.TEndTime);
}
SeasonDTO.RepeatType = model.RepeatType;
SeasonDTO.ListDay = model.ListDay;
SeasonDTO.Unlimited = model.Unlimited;
SeasonDTO.StoreID = model.StoreID;
//---========
paraBody.SeasonDTO = SeasonDTO;
paraBody.AppKey = Commons.AppKey;
paraBody.AppSecret = Commons.AppSecret;
paraBody.CreatedUser = Commons.CreateUser;
paraBody.RegisterToken = new RegisterTokenModels();
paraBody.StoreID = model.StoreID;
paraBody.ID = model.ID;
//====================
var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.CreateOrEditSeason, null, paraBody);
if (result != null)
{
if (result.Success)
{
return(true);
}
else
{
msg = result.Message;
_logger.Error(result.Message);
return(false);
}
}
else
{
_logger.Error(result);
return(false);
}
}
catch (Exception e)
{
_logger.Error("Season_InsertOrUpdate: " + e);
return(false);
}
}
public StatusResponse Export(ref IXLWorksheet ws, List <string> lstStore)
{
StatusResponse Response = new StatusResponse();
try
{
List <SeasonModels> listData = new List <SeasonModels>();
SeasonApiModels paraBody = new SeasonApiModels();
paraBody.AppKey = Commons.AppKey;
paraBody.AppSecret = Commons.AppSecret;
paraBody.CreatedUser = Commons.CreateUser;
paraBody.ListStoreID = lstStore;
var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.ExportSeason, null, paraBody);
dynamic data = result.Data;
var lstC = data["ListSeason"];
var lstContent = JsonConvert.SerializeObject(lstC);
listData = JsonConvert.DeserializeObject <List <SeasonModels> >(lstContent);
int cols = 9;
//Header
int row = 1;
ws.Cell("A" + row).Value = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Index");
ws.Cell("B" + row).Value = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Season Name");
ws.Cell("C" + row).Value = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Start Date");
ws.Cell("D" + row).Value = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("End Date");
ws.Cell("E" + row).Value = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("StartTime");
ws.Cell("F" + row).Value = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("EndTime");
ws.Cell("G" + row).Value = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Day Range");
ws.Cell("H" + row).Value = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Days");
ws.Cell("I" + row).Value = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Store Name");
//Item
row = 2;
int countIndex = 1;
foreach (var item in listData)
{
string days = "";
if (item.ListDay != null)
{
foreach (var day in item.ListDay)
{
days += day + "-";
}
}
ws.Cell("A" + row).Value = countIndex;
ws.Cell("B" + row).Value = item.Name;
ws.Cell("C" + row).Value = "'" + item.StartDate.ToString("dd/MM/yyy");
ws.Cell("D" + row).Value = "'" + item.EndDate.ToString("dd/MM/yyy");
//============
if (item.StartTime.Value.Date == Commons._UnlimitedDate.Date || item.EndTime.Value.Date == Commons._UnlimitedDate.Date)
{
ws.Cell("E" + row).Value = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Unlimited");
ws.Cell("F" + row).Value = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Unlimited");
}
else
{
ws.Cell("E" + row).Value = "'" + item.StartTime.Value.ToLocalTime().ToString("HH:mm");
ws.Cell("F" + row).Value = "'" + item.EndTime.Value.ToLocalTime().ToString("HH:mm");
}
//=============
ws.Cell("G" + row).Value = item.RepeatType == (byte)Commons.ERepeatType.DayOfWeek ? _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(Commons.RPT_DayOfWeek) :
item.RepeatType == (byte)Commons.ERepeatType.DayOfMonth ? _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(Commons.RPT_DayOfMonth) : _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Other");
ws.Cell("H" + row).Value = days;
ws.Cell("I" + row).Value = item.StoreName;
row++;
countIndex++;
}
FormatExcelExport(ws, row, cols);
Response.Status = true;
}
catch (Exception e)
{
Response.Status = false;
Response.MsgError = e.Message;
}
finally
{
}
return(Response);
}
//public bool DeleteSeason(string ID)
//{
// try
// {
// SeasonApiModels paraBody = new SeasonApiModels();
// paraBody.AppKey = Commons.AppKey;
// paraBody.AppSecret = Commons.AppSecret;
// paraBody.CreatedUser = Commons.CreateUser;
// paraBody.RegisterToken = new RegisterTokenModels();
// paraBody.ID = ID;
// //====================
// var result = (ResponseApiModels)ApiResponse.Post<ResponseApiModels>(Commons.DeleteSeason, null, paraBody);
// if (result != null)
// {
// if (result.Success)
// return true;
// else
// {
// _logger.Error(result.Message);
// return false;
// }
// }
// else
// {
// _logger.Error(result);
// return false;
// }
// }
// catch (Exception e)
// {
// _logger.Error("Season_Delete: " + e);
// return false;
// }
//}
// IMPORT
public StatusResponse Import(HttpPostedFileBase excelFile, List <string> lstStore, ref ImportModel importModel, ref string msg)
{
StatusResponse Response = new StatusResponse();
DataTable dt = new DataTable();
FileInfo[] lstFileImg = new FileInfo[] { };
Response = ProcessDataImport(ref dt, excelFile, "SBSettingSeason.xlsx", out lstFileImg);
if (!Response.Status)
{
msg = Response.MsgError;
Response.MsgError = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(msg);
return(Response);
}
ImportItem itemErr = null;
bool flagInsert = true;
string msgError = "";
List <SeasonModels> listData = new List <SeasonModels>();
foreach (var item in lstStore)
{
foreach (DataRow row in dt.Rows)
{
try
{
flagInsert = true;
msgError = "";
string rowText = "";
for (int i = 0; i < dt.Columns.Count; i++)
{
rowText += row[i].ToString().Trim();
}
if (string.IsNullOrEmpty(rowText))
{
continue;
}
string msgItem = "";
DateTime StartDate = DateTimeHelper.GetDateImport(row[2].ToString(), ref msgItem);
DateTime EndDate = DateTimeHelper.GetDateImport(row[3].ToString(), ref msgItem);
DateTime StartTime = row[4].ToString().ToLower().Equals(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("unlimited")) ? Commons._MinDate : DateTimeHelper.GetTimeImport(row[4].ToString(), ref msgItem);
DateTime EndTime = row[5].ToString().ToLower().Equals(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("unlimited")) ? Commons._MinDate : DateTimeHelper.GetTimeImport(row[5].ToString(), ref msgItem);
if (!msgItem.Equals(""))
{
flagInsert = false;
msgError = msgItem;
}
SeasonModels model = new SeasonModels();
model.Index = row[0].ToString();
// 1 - Discount Name
model.Name = row[1].ToString().Trim().Replace(" ", " ");
model.StartDate = row[2].ToString().Equals("") ? Commons._ExpiredDate : StartDate;
model.EndDate = row[3].ToString().Equals("") ? Commons._ExpiredDate : EndDate;
model.StartTime = StartTime;
model.EndTime = EndTime;
model.RepeatType = row[6].ToString().ToLower().Equals(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(Commons.RPT_DayOfWeek.ToLower())) ? (byte)Commons.ERepeatType.DayOfWeek :
row[6].ToString().ToLower().Equals(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(Commons.RPT_DayOfMonth.ToLower())) ? (byte)Commons.ERepeatType.DayOfMonth : 0;
List <int> lstDays = new List <int>();
if (!string.IsNullOrEmpty(row[7].ToString()))
{
string[] arrInt = row[7].ToString().Split('-');
for (int i = 0; i < arrInt.Length; i++)
{
if (!string.IsNullOrEmpty(arrInt[i]))
{
lstDays.Add(int.Parse(arrInt[i]));
}
}
}
model.ListDay = lstDays;
model.StoreID = item;
if (model.StartDate > model.EndDate)
{
flagInsert = false;
msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Start Date must be less than To Date.");
msgError += "<br/>" + msgItem;
}
if (flagInsert)
{
listData.Add(model);
}
else
{
itemErr = new ImportItem();
itemErr.Name = model.Name;
itemErr.ListFailStoreName.Add("");
itemErr.ListErrorMsg.Add(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Row") + ":" + model.Index + _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(msgError));
importModel.ListImport.Add(itemErr);
}
//Insert List
//listData.Add(model);
}
catch (Exception e)
{
importModel.ListImport.Add(new ImportItem {
Name = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Season"), ListFailStoreName = lstStore, ListErrorMsg = new List <string> {
_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(e.Message)
}
});
}
}
}
Response.Status = true;
//=====================
//try
//{
SeasonApiModels paraBody = new SeasonApiModels();
paraBody.AppKey = Commons.AppKey;
paraBody.AppSecret = Commons.AppSecret;
paraBody.CreatedUser = Commons.CreateUser;
paraBody.RegisterToken = new RegisterTokenModels();
paraBody.ListSeason = listData;
//====================
var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.ImportSeason, null, paraBody);
if (result != null)
{
dynamic data = result.Data;
var lstC = data["ListProperty"];
var lstContent = JsonConvert.SerializeObject(lstC);
var listError = JsonConvert.DeserializeObject <List <ImportResult> >(lstContent);
foreach (var itemError in listError)
{
ImportItem item = new ImportItem();
item.Name = itemError.Property;
item.ListFailStoreName.Add(itemError.StoreName);
item.ListErrorMsg.Add(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Row") + ": " + itemError.Index + "<br/>" + _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(itemError.Error));
importModel.ListImport.Add(item);
}
if (importModel.ListImport.Count == 0)
{
ImportItem item = new ImportItem();
item.Name = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Season");
item.ListSuccessStoreName.Add(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Import Season Successful"));
importModel.ListImport.Add(item);
}
}
return(Response);
}
