//update terminal
public bool ModifyTerminal(TerminalRequest param)
{
try
{
var terminal = _db.SingleOrDefault <DolTerminal>("where TerminalId=@0", param.TerminalId);
terminal.Terminalno = param.TerminalNo;
terminal.Terminalref = param.TerminalRef;
terminal.Brandid = param.BrandId;
terminal.Clientid = param.ClientId;
terminal.Engineer = param.Engineer;
terminal.Isterminalactive = param.IsTerminalActive;
terminal.Isundersupport = param.IsUnderSupport;
terminal.Location = param.Location;
terminal.Serialno = param.SerialNo;
terminal.Stateid = param.StateId;
terminal.Terminalalias = param.TerminalAlias;
terminal.Createdby = param.CreatedBy;
terminal.Createdon = param.CreatedOn;
_db.Update(terminal);
return(true);
}
catch (Exception ex)
{
Log.ErrorFormat("ModifyTerminal", ex.Message);
return(false);
}
}
public string RunTransaction(string queryString)
{
_terminalController = new TerminalController();
var input = queryString.Split(_functSplitter);
var inputRequest = Convert.ToInt64(input[0]);
var transactionInputs = input[1].Split(_inputSplitter);
TerminalRequest terminalRequest = (TerminalRequest)inputRequest;
switch (terminalRequest)
{
case TerminalRequest.ShopKeeperBalance:
return(_terminalController.ShopkeeperBalance(transactionInputs[0]));
case TerminalRequest.ShopKeeperToCustomer:
return(_terminalController.ShopkeepertoCustomerTransaction(transactionInputs[0]));
case TerminalRequest.CustomerToShopKeeper:
return(_terminalController.CustomerToShopkeeperTransaction(transactionInputs[0]));
case TerminalRequest.ShopKeeperToShopKeeper:
return(_terminalController.ShopkeeperToShopkeeperTransaction(transactionInputs[0]));
default:
throw new NotImplementedException("");
}
}
public TerminalResponse InsertTerminalDetails(TerminalRequest param)
{
if (param.TerminalNo == null)
{
return(new TerminalResponse
{
ResponseCode = "01",
ResponseMessage = "Empty Terminal Number",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
var terminal = GetTerminalDetailsByNo(param.TerminalNo);
if (terminal != null)
{
Log.InfoFormat(param.Computername, param.SystemIp, param.CreatedBy, Constants.ActionType.SetUpTerminal.ToString());
return(new TerminalResponse
{
ResponseCode = "04",
ResponseMessage = "Terminal already exist",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
try
{
bool success = InsertTerminal(param);
if (success)
{
Log.InfoFormat(param.Computername, param.SystemIp, param.CreatedBy, Constants.ActionType.SetUpTerminal.ToString());
_audit.InsertAudit(param.CreatedBy, Constants.ActionType.SetUpTerminal.ToString(), "Create terminal", DateTime.Now, param.Computername, param.SystemIp);
return(new TerminalResponse
{
ResponseCode = "00",
ResponseMessage = "Record successfully added",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
else
{
Log.InfoFormat(param.Computername, param.SystemIp, param.CreatedBy, Constants.ActionType.SetUpTerminal.ToString());
return(new TerminalResponse
{
ResponseCode = "01",
ResponseMessage = "Unable to create record",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
}
catch (Exception ex)
{
Log.ErrorFormat(param.Computername, param.SystemIp, param.CreatedBy, Constants.ActionType.SetUpTerminal.ToString(), ex);
return(new TerminalResponse
{
ResponseCode = "XX",
ResponseMessage = "System error",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
}
//Insert terminal
public bool InsertTerminal(TerminalRequest param)
{
try
{
var terminal = new DolTerminal();
terminal.Terminalno = param.TerminalNo;
terminal.Terminalref = param.TerminalRef;
terminal.Brandid = param.BrandId;
terminal.Clientid = param.ClientId;
terminal.Engineer = param.Engineer;
terminal.Isterminalactive = param.IsTerminalActive;
terminal.Isundersupport = param.IsUnderSupport;
terminal.Location = param.Location;
terminal.Serialno = param.SerialNo;
terminal.Stateid = param.StateId;
terminal.Terminalalias = param.TerminalAlias;
terminal.Createdby = param.CreatedBy;
terminal.Createdon = param.CreatedOn;
_db.Insert(terminal);
return(true);
}
catch (Exception ex)
{
Log.ErrorFormat("InsertTerminalRequest", ex.Message);
return(false);
}
}
public ActionResult NewTerminal(TerminalRequest param)
{
if (!ModelState.IsValid)
{
return(View());
}
ViewBag.Message = "Terminal";
string RoleName = "Engineer";
ViewBag.Clients = _dolphinApi.GetOnlyClients();
ViewBag.States = _dolphinApi.GetAllStates();
ViewBag.Engineers = _dolphinApi.GetAllUserByRole(RoleName);
ViewBag.Brands = _dolphinApi.GetAllBrand();
try
{
var request = new TerminalRequest();
request.BrandId = param.BrandId;
request.TerminalId = param.TerminalId;
request.TerminalRef = param.TerminalRef;
request.TerminalNo = param.TerminalNo;
request.SerialNo = param.SerialNo;
request.StateId = param.StateId;
request.ClientId = param.ClientId;
request.Engineer = param.Engineer;
request.IsUnderSupport = param.IsUnderSupport;
request.IsTerminalActive = param.IsTerminalActive;
request.Location = param.Location;
request.TerminalAlias = param.TerminalAlias;
request.CreatedBy = User.Identity.Name;
request.CreatedOn = DateTime.Now;
request.ModifiedBy = param.ModifiedBy;
request.ModifiedOn = param.ModifiedOn;
request.SystemIp = ipaddress;
request.Computername = ComputerDetails;
var success = _dolphinApi.InsertTerminal(request);
if (success != null)
{
if (success.ResponseCode.Equals("00"))
{
TempData["SuccessMsg"] = success.ResponseMessage;
return(RedirectToAction("listterminal"));
}
else
{
ViewBag.ErrorMsg = success.ResponseMessage;
}
}
else
{
ViewBag.ErrorMsg = "Unable to complete operation";
}
}
catch (Exception ex)
{
ViewBag.ErrorMsg = ex;
}
return(View());
}
public TerminalResponse UploadBulkTerminalRecords(List <TerminalBulkRequest> param)
{
int successful = 0;
int failed = 0;
int existing = 0;
try
{
foreach (var n in param)
{
var existTerminal = GetTerminalDetailsByNo(n.TerminalNo);
if (existTerminal == null)
{
var value = new TerminalRequest();
value.TerminalNo = n.TerminalNo;
value.TerminalRef = n.TerminalRef;
value.SerialNo = n.SerialNo;
value.BrandId = _brand.GetBrandByName(n.BrandName).Brandid;
value.ClientId = _client.GetClientByName(n.ClientName).Clientid;
value.Engineer = _user.GetUserByEmail(n.Engineer).Username;
value.IsUnderSupport = SupportStatus(n.Support.ToUpper());
value.IsTerminalActive = value.IsUnderSupport;
value.TerminalAlias = n.TerminalAlias;
value.StateId = GetStateByName(n.State.ToLower()).StateId;
value.Location = n.Location;
value.CreatedBy = n.CreatedBy;
value.CreatedOn = n.CreatedOn;
InsertTerminal(value);
successful++;
}
else
{
existing++;
}
}
}
catch (Exception ex)
{
Log.InfoFormat(param.FirstOrDefault().Computername, param.FirstOrDefault().SystemIp, param.FirstOrDefault().CreatedBy, Constants.ActionType.SetUpTerminal.ToString());
return(new TerminalResponse
{
ResponseCode = "01",
ResponseMessage = ex.Message + " " + successful + " was added successfully",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
Log.InfoFormat(param.FirstOrDefault().Computername, param.FirstOrDefault().SystemIp, param.FirstOrDefault().CreatedBy, Constants.ActionType.SetUpTerminal.ToString());
_audit.InsertAudit(param.FirstOrDefault().CreatedBy, Constants.ActionType.SetUpTerminal.ToString(), "Create terminal", DateTime.Now, param.FirstOrDefault().Computername, param.FirstOrDefault().SystemIp);
return(new TerminalResponse
{
ResponseCode = "00",
ResponseMessage = successful + " Record successfully added, " + failed + " failed and " + existing + " already exists",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
public ActionResult GetTerminalDetails(int TerminalId)
{
var request = new TerminalRequest();
request.TerminalId = TerminalId;
request.Computername = ComputerDetails;
request.SystemIp = ipaddress;
var terminal = _dolphinApi.GetTerminalDetails(request);
return(Json(terminal, JsonRequestBehavior.AllowGet));
}
public TerminalResponse ModifyTerminalDetails(TerminalRequest param)
{
if (param.TerminalId == 0)
{
Log.InfoFormat(param.Computername, param.SystemIp, param.CreatedBy, Constants.ActionType.ModifyTerminalDetails.ToString());
return(new TerminalResponse
{
ResponseCode = "01",
ResponseMessage = "Record updated successfully",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
try
{
bool terminal = ModifyTerminal(param);
if (terminal)
{
Log.InfoFormat(param.Computername, param.SystemIp, param.CreatedBy, Constants.ActionType.ModifyTerminalDetails.ToString());
_audit.InsertAudit(param.CreatedBy, Constants.ActionType.ModifyTerminalDetails.ToString(), "TerminalDetails modified", DateTime.Now, param.Computername, param.SystemIp);
return(new TerminalResponse
{
ResponseCode = "00",
ResponseMessage = "Record updated successfully",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
else
{
Log.InfoFormat(param.Computername, param.SystemIp, param.CreatedBy, Constants.ActionType.ModifyTerminalDetails.ToString());
return(new TerminalResponse
{
ResponseCode = "01",
ResponseMessage = "Unable to update record",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
}
catch (Exception ex)
{
Log.InfoFormat(param.Computername, param.SystemIp, param.CreatedBy, Constants.ActionType.ModifyTerminalDetails.ToString(), ex);
return(new TerminalResponse
{
ResponseCode = "XX",
ResponseMessage = "System error",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
}
public TerminalResponse TerminalDetails(TerminalRequest param)
{
if (param.TerminalId == 0)
{
Log.ErrorFormat(param.Computername, param.SystemIp, param.CreatedBy, Constants.ActionType.SetUpTerminal.ToString());
return(new TerminalResponse
{
ResponseCode = "01",
ResponseMessage = "No Terminal Id",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
try
{
var success = GetTerminalDetails(param.TerminalId);
if (success == null)
{
Log.ErrorFormat(param.Computername, param.SystemIp, param.CreatedBy, Constants.ActionType.SetUpTerminal.ToString());
return(new TerminalResponse
{
ResponseCode = "02",
ResponseMessage = "No record found",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
Log.ErrorFormat(param.Computername, param.SystemIp, param.CreatedBy, Constants.ActionType.SetUpTerminal.ToString());
var result = new List <TerminalDetailsObj>
{
success
};
return(new TerminalResponse
{
ResponseCode = "00",
ResponseMessage = "Success",
TerminalDetails = result
});
}
catch (Exception ex)
{
Log.ErrorFormat(param.Computername, param.SystemIp, param.CreatedBy, Constants.ActionType.SetUpTerminal.ToString(), ex);
return(new TerminalResponse
{
ResponseCode = "XX",
ResponseMessage = "System error",
TerminalDetails = new List <TerminalDetailsObj>()
});
}
}
public ActionResult ModifyTerminal(int TerminalId)
{
ViewBag.Message = "Terminal";
string RoleName = "Engineer";
var request = new TerminalRequest();
request.TerminalId = TerminalId;
request.Computername = ComputerDetails;
request.SystemIp = ipaddress;
ViewBag.Terminal = _dolphinApi.GetTerminalDetails(request);
ViewBag.Clients = _dolphinApi.GetOnlyClients();
ViewBag.States = _dolphinApi.GetAllStates();
ViewBag.Engineers = _dolphinApi.GetAllUserByRole(RoleName);
ViewBag.Brands = _dolphinApi.GetAllBrand();
return(View());
}
public TerminalResponse GetTerminalDetails(TerminalRequest _request)
{
string url = string.Concat(_baseUrl, "terminaldetails");
var client = new RestClient(url);
var request = new RestSharp.RestRequest(Method.POST);
request.AddHeader("content-type", "application/x-www-form-urlencoded");
string param = JsonConvert.SerializeObject(_request);
request.AddParameter("application/json", param, ParameterType.RequestBody);
request.RequestFormat = DataFormat.Json;
IRestResponse response = client.Execute(request);
TerminalResponse terminalResponse = JsonConvert.DeserializeObject <TerminalResponse>(response.Content);
if (terminalResponse == null || terminalResponse.ResponseCode == null)
{
return(null);
}
else
{
return(terminalResponse);
}
}
