//InsertOrUpdateDefaultCurrency
public bool InsertOrUpdateDefaultCurrency(DefaultCurrencyModels model, ref string msg)
{
try
{
DefaultCurrencyApiModels paraBody = new DefaultCurrencyApiModels();
paraBody.AppKey = Commons.AppKey;
paraBody.AppSecret = Commons.AppSecret;
paraBody.CreatedUser = Commons.CreateUser;
paraBody.RegisterToken = new RegisterTokenModels();
//-----
paraBody.StoreId = model.StoreId;
paraBody.Id = model.Id;
paraBody.IsSelected = model.IsSelected;
paraBody.Name = model.Name;
paraBody.Symbol = model.Symbol;
//====================
var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.CreateOrEditCurrency, null, paraBody);
if (result != null)
{
if (result.Success)
{
return(true);
}
else
{
_logger.Error(result.Message);
msg = result.Message;
return(false);
}
}
else
{
_logger.Error(result);
return(false);
}
}
catch (Exception e)
{
_logger.Error("DefaultCurrency_InsertOrUpdate: " + e);
return(false);
}
}
//Deleted
public bool DeleteDefaultCurrency(string ID, ref string msg)
{
try
{
DefaultCurrencyApiModels paraBody = new DefaultCurrencyApiModels();
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.DeleteCurrency, 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("Default Currency_Delete: " + e);
return(false);
}
}
//GetListDefaultCurrency
public List <DefaultCurrencyModels> GetListDefaultCurrency(string StoreID = null, string ID = null, List <string> ListOrganizationId = null)
{
List <DefaultCurrencyModels> listdata = new List <DefaultCurrencyModels>();
try
{
DefaultCurrencyApiModels paraBody = new DefaultCurrencyApiModels();
paraBody.AppKey = Commons.AppKey;
paraBody.AppSecret = Commons.AppSecret;
paraBody.CreatedUser = Commons.CreateUser;
//paraBody.Mode = 1;
paraBody.StoreId = StoreID;
paraBody.Id = ID;
paraBody.ListOrgID = ListOrganizationId;
NSLog.Logger.Info("GetListDefaultCurrency request", paraBody);
var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.GetCurrency, null, paraBody);
NSLog.Logger.Info("GetListDefaultCurrency response", result);
dynamic data = result.Data;
var lstZ = data["ListCurrency"];
var lstContent = JsonConvert.SerializeObject(lstZ /*result.RawData*/);
listdata = JsonConvert.DeserializeObject <List <DefaultCurrencyModels> >(lstContent);
var currentUser = (UserSession)System.Web.HttpContext.Current.Session["User"];
if (currentUser != null)
{
listdata = listdata.Where(ww => currentUser.ListStoreID.Contains(ww.StoreId)).ToList();
}
return(listdata);
}
catch (Exception e)
{
NSLog.Logger.Error("DefaultCurrency_GetList Error: ", e);
return(listdata);
}
}
//Export DefaultCurrency
public StatusResponse Export(ref IXLWorksheet ws, List <string> lstStore)
{
StatusResponse Response = new StatusResponse();
try
{
List <DefaultCurrencyModels> listData = new List <DefaultCurrencyModels>();
DefaultCurrencyApiModels paraBody = new DefaultCurrencyApiModels();
paraBody.AppKey = Commons.AppKey;
paraBody.AppSecret = Commons.AppSecret;
paraBody.CreatedUser = Commons.CreateUser;
paraBody.ListStoreID = lstStore;
var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.ExportCurrency, null, paraBody);
dynamic data = result.Data;
var lstC = data["ListCurrency"];
var lstContent = JsonConvert.SerializeObject(lstC);
listData = JsonConvert.DeserializeObject <List <DefaultCurrencyModels> >(lstContent);
listData = listData.OrderBy(o => o.StoreName).ToList();
int row = 1;
string[] listSetMenuHeader = new string[] {
_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Index"),
_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Currency Name"),
_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Currency Symbol"),
_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Selected"),
_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Store")
};
for (int i = 1; i <= listSetMenuHeader.Length; i++)
{
ws.Cell(row, i).Value = listSetMenuHeader[i - 1];
}
int cols = listSetMenuHeader.Length;
//Item
row = 2;
int countIndex = 1;
foreach (var item in listData)
{
ws.Cell("A" + row).Value = countIndex;
ws.Cell("B" + row).Value = item.Name;
ws.Cell("C" + row).Value = item.Symbol;
ws.Cell("D" + row).Value = item.IsSelected == true?_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Selected")
: _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("UnSelected");
ws.Cell("E" + 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);
}
// 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, "SBSettingCurrency.xlsx", out lstFileImg);
if (!Response.Status)
{
msg = Response.MsgError;
return(Response);
}
List <DefaultCurrencyModels> listData = new List <DefaultCurrencyModels>();
ImportItem itemErr = null;
bool flagInsert = true;
string msgError = "";
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;
}
DefaultCurrencyModels model = new DefaultCurrencyModels();
model.Index = row[0].ToString();
// 1 - Currency Name
model.Name = row[1].ToString().Trim().Replace(" ", " ");
// 2 - IsActive
model.IsSelected = string.IsNullOrEmpty(row[3].ToString()) ? false :
_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(row[3].ToString()).Equals(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("selected")) ? true : false;
// 3 - Symbol
model.Symbol = row[2].ToString().Trim().Equals("") ? "" : row[2].ToString().Trim();
model.StoreId = item;
if (model.Name.Equals(""))
{
flagInsert = false;
msgError += _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Name is required");
}
if (model.Symbol.Equals(""))
{
flagInsert = false;
msgError += "<br/>" + _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Symbol is required");
}
if (listData.Any(x => x.Name.Equals(model.Name)))
{
flagInsert = false;
msgError += "<br/>" + _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Name is exist");
}
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 + msgError);
importModel.ListImport.Add(itemErr);
}
}
catch (Exception e)
{
importModel.ListImport.Add(new ImportItem {
Name = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Currency"), ListFailStoreName = lstStore, ListErrorMsg = new List <string> {
e.Message
}
});
}
}
}
Response.Status = true;
//=====================
//try
//{
DefaultCurrencyApiModels paraBody = new DefaultCurrencyApiModels();
paraBody.AppKey = Commons.AppKey;
paraBody.AppSecret = Commons.AppSecret;
paraBody.CreatedUser = Commons.CreateUser;
paraBody.RegisterToken = new RegisterTokenModels();
paraBody.ListCurrency = listData;
//====================
var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.ImportCurrency, 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 (ImportResult 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/>" + itemError.Error);
importModel.ListImport.Add(item);
}
if (importModel.ListImport.Count == 0)
{
ImportItem item = new ImportItem();
item.Name = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Currency");
item.ListSuccessStoreName.Add(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Import Currency Successful"));
importModel.ListImport.Add(item);
}
}
return(Response);
}
