public async Task <ActionResult> DownloadExcelReport(eService _Query)
{
string Extension = ".xlsx";
var dt = DateTime.ParseExact(_Query.SelectedTxnDateRange, "yyyyMM", CultureInfo.InvariantCulture);
_Query.Month = Convert.ToInt16(dt.ToString("MM"));
_Query.Year = Convert.ToInt16(dt.ToString("yyyy"));
int colIndex = 1, rowIndex = 4;
var list = (await MechSignUpService.GetIFrameMerchGeneralInfoes(_Query.BusnLocation, Convert.ToInt32(_Query.SelectedTxnType), _Query.Month, _Query.Year)).eServices;
var headerName = string.Format("{0}_{1}", _Query.SelectedTxnType, _Query.SelectedTxnDateRange);
headerName = headerName.Trim();
var pkg = CommonHelpers.PrepareExcelHeader(headerName, new string[] { "Posting Date", "Txn Date", "Card No", "RRN", "Quantity", "Amount", "MDR", "VAT Amount", "Net Amount" });
var ws = pkg.Workbook.Worksheets[1];
var cell = ws.Cells[rowIndex, colIndex];
foreach (var x in list)
{
colIndex = 1;
cell = ws.Cells[rowIndex, colIndex];
cell.Value = x.PostingDate;
colIndex++;
cell = ws.Cells[rowIndex, colIndex];
cell.Value = x.TxnDate;
colIndex++;
cell = ws.Cells[rowIndex, colIndex];
cell.Value = x.CardNo;
colIndex++;
cell = ws.Cells[rowIndex, colIndex];
cell.Value = x.RRN;
colIndex++;
cell = ws.Cells[rowIndex, colIndex];
cell.Value = x.Quantity;
colIndex++;
cell = ws.Cells[rowIndex, colIndex];
cell.Value = x.Amount;
colIndex++;
cell = ws.Cells[rowIndex, colIndex];
cell.Value = x.MDR;
colIndex++;
cell = ws.Cells[rowIndex, colIndex];
cell.Value = x.VatAmount;
colIndex++;
cell = ws.Cells[rowIndex, colIndex];
cell.Value = x.NetAmount;
rowIndex++;
}
string contentType = CommonHelpers.ContentType(Extension);
Byte[] bin = pkg.GetAsByteArray();
return(File(bin, contentType, headerName + Extension));
}
public MechSignUpResponse()
{
merchGeneralInfo = new MA_GeneralInfo();
merchantDetail = new MerchantDetails();
merchChangeOwnerships = new List <MerchChangeOwnership>();
merchProductPrizes = new List <MerchProductPrize>();
busnLocTerminal = new BusnLocTerminal();
busnLocTerminals = new List <BusnLocTerminal>();
eService = new eService();
eServices = new List <eService>();
merchantDetails = new List <MerchantDetails>();
merchPostedTxnSearches = new List <MerchPostedTxnSearch>();
merchAgreements = new List <MA_GeneralInfo>();
merchChangeOwnership = new MerchChangeOwnership();
}
public async Task <IHttpActionResult> PosteService(int score, string date, int userid, int lessonid)
{
eService eservice = new eService();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
eservice.Score = score;
eservice.DateTime = date;
eservice.UserId = userid;
eservice.LessonId = lessonid;
db.eService.Add(eservice);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = eservice.eServiceID }, eservice));
}
public static void Warning(eService _service, String _username, CodeMessages Code)
{
try
{
FinancyContext db = new FinancyContext();
LogServiceABC dataLogApi = new LogServiceABC();
dataLogApi.Service = _service;
dataLogApi.UserName = _username;
dataLogApi.DateTransaction = DateTime.Now;;
dataLogApi.Type = TypeLog.Warning.ToString();
dataLogApi.Code = CodeString((int)Code);
dataLogApi.Message = HlpLog.GetEnumDescription(Code);
dataLogApi.StackTrace = "";
db.LogServiceABC.Add(dataLogApi);
db.SaveChanges();
}
catch (Exception ex) {
ex.ToString();
}
}
public static void Information(eService _service, String _username, CodeMessages Code, String Message)
{
FinancyContext db = new FinancyContext();
LogServiceABC dataLogApi = new LogServiceABC();
try
{
dataLogApi.Service = _service;
dataLogApi.UserName = _username;
dataLogApi.DateTransaction = DateTime.Now;;
dataLogApi.Type = TypeLog.Information.ToString();
dataLogApi.Code = CodeString((int)Code);
dataLogApi.Message = Message;
dataLogApi.StackTrace = "";
db.LogServiceABC.Add(dataLogApi);
db.SaveChanges();
writeLog(dataLogApi);
}
catch (Exception ex)
{
writeLog(dataLogApi);
ex.ToString();
}
}
public async Task <JsonResult> iFrameMerchGeneralInfoSelect(string MerchId)
{
var date = new DateTime();
var _listItem = new List <SelectListItem>();
for (var i = 0; i < 10; i++)
{
date = DateTime.Now.AddMonths(-i);
_listItem.Add(new SelectListItem
{
Text = date.ToString("MMMM") + " " + date.ToString("yyyy"),
Value = date.ToString("yyyy") + date.ToString("MM")
});
}
var Info = new eService
{
// double check
TxnType = await BaseService.GetFrameGetTxnCategory(""),
TxnDateRange = _listItem
};
var info = (await MechSignUpService.GetIFrameMerchGeneralInfo(MerchId)).eService;
return(Json(new { Model = info, Selects = Info }, JsonRequestBehavior.AllowGet));
}
public static DataTable FetchByUsername(string username)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = SqlHelper.ExecuteReader(conn, "FetchCreditsHistoryByUsername",
username);
DataTable dtResults = new DataTable();
dtResults.Columns.Add("Date");
dtResults.Columns.Add("Credits");
dtResults.Columns.Add("Service");
while (reader.Read())
{
string service = String.Empty;
int srv = (int) reader["Service"];
if (srv == (int) eService.SendMessage)
{
service = Lang.Trans("Sent Message");
}
else if (srv == (int)eService.UseIM)
{
service = Lang.Trans("Instant Messenger");
}
else if (srv == (int)eService.ViewPhotos)
{
service = Lang.Trans("View Photos");
}
else if (srv == (int)eService.ViewVideo)
{
service = Lang.Trans("View Video");
}
else if (srv == (int)eService.CreateBlogPost)
{
service = Lang.Trans("View Blog Post");
}
else if (srv == (int)eService.SendEcard)
{
service = Lang.Trans("Send e-card");
}
dtResults.Rows.Add((DateTime)reader["Date"], (int)reader["Credits"], service);
}
return dtResults;
}
}
// The main method that run our garage
public void StartService()
{
GarageManager newGarageManager = this.m_GarageManager;
bool isDone = false;
while (isDone == false)
{
// User choose the service he wish for.
eService serviceOptionChoose = ServiceOptionChoose(newGarageManager.m_ServiceList);
switch (serviceOptionChoose)
{
case eService.AddVehical:
string VehicleLicenseNum = getNewLicenseNum();
int indexOnList = newGarageManager.IndexOfVehicle(VehicleLicenseNum);
if (indexOnList != -1)
{
Console.WriteLine("Vehicle L.N " + VehicleLicenseNum +
" is allready in the garage and his status is " + newGarageManager.VehicleList[indexOnList].VehicleStatus);
}
else
{
newGarageManager.VehicleList.Add(GetNewVehicleStatusInfo(VehicleLicenseNum));
}
break;
case eService.PrintVehicalList:
PrintVehicleList(newGarageManager);
break;
case eService.UpdateVehicleStatus:
UpdateVehicleStatus(newGarageManager);
break;
case eService.FillAirInWheels:
string licenseOfVehicleToFillAir = getNewLicenseNum();
if (newGarageManager.IsInGarage(licenseOfVehicleToFillAir))
{
newGarageManager.FillAir(licenseOfVehicleToFillAir);
Console.WriteLine("We filled your wheels with air !");
}
else
{
Console.WriteLine("No such vehicle in the garage with this License number");
}
break;
case eService.FuelUpTank:
string licenseNumberForFuel = getNewLicenseNum();
if (newGarageManager.IsInGarage(licenseNumberForFuel))
{
Vehicle vehicleToFuel = newGarageManager.VehicleList[newGarageManager.IndexOfVehicle(licenseNumberForFuel)].Vehicle;
if (vehicleToFuel.EngineEnergyType != eEnergyType.Electricity)
{
eEnergyType energyTypeToFuel = getEnergyType();
float fuelToFill = ChooseNumOf("of fuel amount");
newGarageManager.AddEnergy(licenseNumberForFuel, energyTypeToFuel, fuelToFill);
}
else
{
Console.Write("we are sorry but we cannot feul up a the vehicle with fuel since he use battery ! send him to charging.");
}
}
else
{
Console.WriteLine("No such vehicle in the garage with this License number");
}
break;
case eService.ChargeUpBattery:
string licenseNumberForCharge = getNewLicenseNum();
if (newGarageManager.IsInGarage(licenseNumberForCharge))
{
Vehicle vehicleToCharge = newGarageManager.VehicleList[newGarageManager.IndexOfVehicle(licenseNumberForCharge)].Vehicle;
if (vehicleToCharge.EngineEnergyType == eEnergyType.Electricity)
{
eEnergyType energyTypeToFuel = eEnergyType.Electricity;
float batteryToCharge = ChooseNumOf("of battery time to charge");
newGarageManager.AddEnergy(licenseNumberForCharge, energyTypeToFuel, batteryToCharge);
}
else
{
Console.Write("we are sorry but we cannot Charge up a the motoric vehcile since he use Fuel ! send him to fueling tank.");
}
}
else
{
Console.WriteLine("No such vehicle in the garage with this License number");
}
break;
case eService.PrintVehicleInfo:
PrintVehicleInfo(newGarageManager);
break;
case eService.Done:
Console.WriteLine("Thanks for using our service, have a nice day and good bye!");
isDone = true;
break;
default:
Console.WriteLine("Please choose a valide option from our service");
break;
}
Console.WriteLine("\n\n");
}
}
public async Task <JsonResult> iFrameMerchTxnListSelect(jQueryDataTableParamModel Params, eService _Query)
{
var dt = DateTime.ParseExact(_Query.SelectedTxnDateRange, "yyyyMM", CultureInfo.InvariantCulture);
_Query.Month = Convert.ToInt16(dt.ToString("MM"));
_Query.Year = Convert.ToInt16(dt.ToString("yyyy"));
var list = (await MechSignUpService.GetIFrameMerchGeneralInfoes(_Query.BusnLocation, Convert.ToInt32(_Query.SelectedTxnType), _Query.Month, _Query.Year)).eServices;
var filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength);
return(Json(new
{
sEcho = Params.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = list.Count(),
aaData = filtered.Select(x => new object[] { x.PostingDate, x.TxnDate, x.TxnTime, x.CardNo, x.RRN, x.Quantity, x.Amount, x.MDR, x.VatAmount, x.NetAmount })
}, JsonRequestBehavior.AllowGet));
}
