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)); }