public async Task <IActionResult> Edit(int id, [Bind("Id,Date,Category,Title,Body,OperatorId,OrderId")] Tiket tiket)
{
if (id != tiket.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tiket);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TiketExists(tiket.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["OperatorId"] = new SelectList(_context.Operator, "Id", "Id", tiket.OperatorId);
ViewData["OrderId"] = new SelectList(_context.Order, "Id", "State", tiket.OrderId);
return(View(tiket));
}
public async Task <Tiket> AddTiketAsync(Tiket tiket)
{
var tiketEntry = _tikets.Add(tiket);
await _uow.SaveChangesAsync();
return(tiketEntry.Entity);
}
public async Task <string> postDoucumento(string token, string DocRuta, string Documento_URL, string NameDoc)
{
using (var client = new HttpClient())
{
//SETUP CLIENTE
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
client.DefaultRequestHeaders.Add("Authorization", "Bearer " + token);
var method = new MultipartFormDataContent();
try
{
var streamContent = new StreamContent(File.Open(DocRuta, FileMode.Open));
method.Add(streamContent, "file", NameDoc);
HttpResponseMessage response = await client.PostAsync(Documento_URL, method);
var responseString = await response.Content.ReadAsStringAsync();
//return responseString;
Tiket to = new Tiket();
//var numero = jObject[0]["access_token"].ToString();
//Console.WriteLine(numero);
//string TOKEN = await response.Content.ReadAsStringAsync();
to = JsonConvert.DeserializeObject <Tiket>(responseString);
TIKET = to.description;
return(TIKET.ToString());
}
catch (Exception e)
{
return(e.Message);
}
}
}
public async Task <IActionResult> Edit(int id, [Bind("ID,Name,Discription,DataOfStart,DataOfEnd,Status")] Tiket tiket)
{
if (id != tiket.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tiket);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TiketExists(tiket.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tiket));
}
public void delete(Tiket dbitem, int id)
{
context.Tiket.Remove(dbitem);
var query = "DELETE FROM dbo.\"Tiket\" WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Tiket List", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public async Task <IActionResult> Create([Bind("ID,Name,Discription,DataOfStart,DataOfEnd,Status")] Tiket tiket)
{
if (ModelState.IsValid)
{
_context.Add(tiket);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tiket));
}
public ActionResult Edit(Tiket model)
{
if (ModelState.IsValid)
{
Context.Tiket dbitem = RepoTiket.FindByPK(model.Id);
model.setDb(dbitem);
RepoTiket.save(dbitem, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public async Task <IActionResult> Create([Bind("Id,Date,Category,Title,Body,OperatorId,OrderId")] Tiket tiket)
{
if (ModelState.IsValid)
{
_context.Add(tiket);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["OperatorId"] = new SelectList(_context.Operator, "Id", "Id", tiket.OperatorId);
ViewData["OrderId"] = new SelectList(_context.Order, "Id", "State", tiket.OrderId);
return(View(tiket));
}
public ActionResult Add(Tiket model)
{
if (ModelState.IsValid)
{
Context.Tiket dbitem = new Context.Tiket();
model.setDb(dbitem);
dbitem.IdCS = UserPrincipal.id;
dbitem.Urutan = RepoTiket.getUrutan() + 1;
dbitem.NoTiket = RepoTiket.generateCodePPK(model.Urutan);
dbitem.CreatedBy = UserPrincipal.id;
RepoTiket.save(dbitem, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public void save(Tiket dbitem, int id)
{
if (dbitem.Id == 0) //create
{
context.Tiket.Add(dbitem);
var query = "INSERT INTO dbo.\"Tiket\" (\"NoTiket\", \"IdCustomer\", \"TanggalLapor\", \"DitujukanKe\", \"Kategori\", \"Prioritas\", \"Status\", \"Subject\", \"Keluhan\", \"IdCS\"," +
" \"Urutan\", \"Respon\", \"NamaPelapor\", \"Attactment\", \"IdSo\", \"IdSoKontrak\") VALUES ( " + dbitem.NoTiket + ", " + dbitem.IdCustomer + ", " + dbitem.TanggalLapor + ", " +
dbitem.DitujukanKe + ", " + dbitem.Kategori + ", " + dbitem.Prioritas + ", " + dbitem.Status + ", " + dbitem.Subject + ", " + dbitem.Keluhan + ", " + dbitem.IdCS + ", " +
dbitem.Urutan + ", " + dbitem.Respon + ", " + dbitem.NamaPelapor + ", " + dbitem.Attactment + ", " + dbitem.IdSo + ", " + dbitem.IdSoKontrak + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Tiket", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
dbitem.LastUpdate = DateTime.Now;
context.Tiket.Attach(dbitem);
var query = "UPDATE dbo.\"Tiket\" SET \"IdCustomer\" = " + dbitem.IdCustomer + ", \"TanggalLapor\" = " + dbitem.TanggalLapor + ", \"DitujukanKe\" = " + dbitem.DitujukanKe +
", \"Kategori\" = " + dbitem.Kategori + ", \"Prioritas\" = " + dbitem.Prioritas + ", \"Status\" = " + dbitem.Status + ", \"Subject\" = " + dbitem.Subject + ", \"Keluhan\" = " +
dbitem.Keluhan + ", \"IdCS\" = " + dbitem.IdCS + ", \"Urutan\" = " + dbitem.Urutan + ", \"Respon\" = " + dbitem.Respon + ", \"NamaPelapor\" = " + dbitem.NamaPelapor +
", \"Attactment\" = " + dbitem.Attactment + ", \"IdSo\" = " + dbitem.IdSo + ", \"IdSoKontrak\" = " + dbitem.IdSoKontrak + " WHERE \"Id\" = " + dbitem.Id + ";";
if (dbitem.Respon != null)
{
context.TiketResponse.Add(new TiketResponse {
Respon = dbitem.Respon, IdResponder = id, IdTiket = dbitem.Id, ResponseAttachment = dbitem.ResponseAttachment, CreatedAt = DateTime.Now
});
query += "INSERT INTO dbo.\"TiketResponse\" (\"IdTiket\", \"Respon\", \"IdResponder\", \"ResponseAttachment\") VALUES (" + dbitem.Id + ", " + dbitem.Respon + ", " + id + ", " +
dbitem.ResponseAttachment + ");";
}
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Tiket List", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public ActionResult Edit(int id)
{
Context.Tiket dbitem = RepoTiket.FindByPK(id);
Tiket model = new Tiket(dbitem);
ViewBag.name = model.NoTiket;
ViewBag.Creator = dbitem.CS.Fristname + " " + dbitem.CS.Lastname;
if (dbitem.DitujukanKe.Split(',').Contains(UserPrincipal.id.ToString()) || UserPrincipal.id == dbitem.CreatedBy)
{
ViewBag.Responses = dbitem.TiketResponse;
ViewBag.setReadonly = dbitem.DitujukanKe.Split(',').Contains(UserPrincipal.id.ToString()) ? "true" : "false";
ViewBag.SO = dbitem.SalesOrder.SalesOrderOncall;
ViewBag.TanggalTiba = RepoSalesOrder.TanggalTiba(dbitem.SalesOrder.SalesOrderOncall);
ViewBag.CreatedBy = dbitem.CreatedBy;
return(View("FormComment", model));
}
else
{
return(View("Form", model));
}
}
public int update(Tiket tiket)
{
SqlCommand command = db.CreateCommand(SQL_UPDATE);
PrepareCommandUpdate(command, tiket);
return db.ExecuteNonQuery(command);
}
public int insert(Tiket tiket)
{
SqlCommand command = db.CreateCommand(SQL_INSERT);
PrepareCommandInsert(command, tiket);
return db.ExecuteNonQuery(command);
}
private Collection<Tiket> Read(SqlDataReader reader, String fce)
{
Collection<Tiket> tikety = new Collection<Tiket>();
if (fce == "select_one" || fce == "select_all")
{
while (reader.Read())
{
Tiket t = new Tiket();
t.t_ID = reader.GetInt32(0);
t.nazev = reader.GetString(1);
t.popis = reader.GetString(2);
t.priorita = reader.GetInt32(3);
t.vytvoreno = reader.GetDateTime(4);
t.lhuta = reader.GetDateTime(5);
t.status = reader.GetString(6);
if (!reader.IsDBNull(7))
{
t.uzav_pozn = reader.GetString(7);
}
t.Zamestnanec_z_ID = reader.GetInt32(8);
t.Kategorie_kat_ID = reader.GetInt32(9);
if (!reader.IsDBNull(10))
{
t.Skupina_skup_ID = reader.GetInt32(10);
}
tikety.Add(t);
}
}
else if (fce == "select_nove" ||
fce == "select_prosle")
{
while (reader.Read())
{
Tiket t = new Tiket();
t.t_ID = reader.GetInt32(0);
t.nazev = reader.GetString(1);
t.popis = reader.GetString(2);
t.priorita = reader.GetInt32(3);
t.vytvoreno = reader.GetDateTime(4);
t.lhuta = reader.GetDateTime(5);
t.status = reader.GetString(6);
if (!reader.IsDBNull(7))
{
t.uzav_pozn = reader.GetString(7);
}
t.Zamestnanec_z_ID = reader.GetInt32(8);
t.Kategorie_kat_ID = reader.GetInt32(9);
if (!reader.IsDBNull(10))
{
t.Skupina_skup_ID = reader.GetInt32(10);
}
tikety.Add(t);
}
}
return tikety;
}
//update
private void PrepareCommandUpdate(SqlCommand command, Tiket Tiket)
{
command.Parameters.Add(new SqlParameter("@nazev", SqlDbType.VarChar, Tiket.LEN_ATTR_nazev));
command.Parameters["@nazev"].Value = Tiket.nazev;
command.Parameters.Add(new SqlParameter("@popis", SqlDbType.VarChar, Tiket.LEN_ATTR_popis));
command.Parameters["@popis"].Value = Tiket.popis;
command.Parameters.Add(new SqlParameter("@priorita", SqlDbType.Int));
command.Parameters["@priorita"].Value = Tiket.priorita;
command.Parameters.Add(new SqlParameter("@vytvoreno", SqlDbType.DateTime));
command.Parameters["@vytvoreno"].Value = Tiket.vytvoreno;
command.Parameters.Add(new SqlParameter("@lhuta", SqlDbType.DateTime));
command.Parameters["@lhuta"].Value = Tiket.lhuta;
command.Parameters.Add(new SqlParameter("@status", SqlDbType.VarChar, Tiket.LEN_ATTR_status));
command.Parameters["@status"].Value = Tiket.status;
command.Parameters.Add(new SqlParameter("@uzav_pozn", SqlDbType.VarChar, Tiket.LEN_ATTR_uzav_pozn));
command.Parameters["@uzav_pozn"].Value = Tiket.uzav_pozn;
command.Parameters.Add(new SqlParameter("@Zamestnanec_z_ID", SqlDbType.Int));
command.Parameters["@Zamestnanec_z_ID"].Value = Tiket.Zamestnanec_z_ID;
command.Parameters.Add(new SqlParameter("@Kategorie_kat_ID", SqlDbType.Int));
command.Parameters["@Kategorie_kat_ID"].Value = Tiket.Kategorie_kat_ID;
command.Parameters.Add(new SqlParameter("@Skupina_skup_ID", SqlDbType.Int));
command.Parameters["@Skupina_skup_ID"].Value = Tiket.Skupina_skup_ID;
command.Parameters.Add(new SqlParameter("@t_ID", SqlDbType.Int));
command.Parameters["@t_ID"].Value = Tiket.t_ID;
}
public async Task DeleteTiketAsync(Tiket tiket)
{
_tikets.Remove(tiket);
await _uow.SaveChangesAsync();
}
static void Main(string[] args)
{
const int cPaymentMethods = 2; //Количество способов оплаты
const int cBusTypes = 3; //Количество типов автобусов
const int cTariff = 3; //Количество тарифов
const int cNonCashMethods = 3; //Количество тарифов
Console.WriteLine("Введите тип автобуса: ");
for (int i = 1; i <= cBusTypes; i++)
{
Console.WriteLine($"{i}.{(BusTypes)i}");
}
int.TryParse(Console.ReadLine(), out int Choose);
BusTypes bysType = (BusTypes)Choose;
Console.WriteLine("Введите Тариф: ");
for (int i = 1; i <= cTariff; i++)
{
Console.WriteLine($"{i}.{(Tariff)i}");
}
int.TryParse(Console.ReadLine(), out Choose);
Tariff tariff = (Tariff)Choose;
Console.WriteLine("Введите метод оплаты: ");
for (int i = 1; i <= 2; i++)
{
Console.WriteLine($"{i}.{(PaymentMethods)i}");
}
int.TryParse(Console.ReadLine(), out Choose);
PaymentMethods paymentMethod = (PaymentMethods)Choose;
Tiket tiket = new Tiket()
{
Date = DateTime.Now,
TiketNumbet = Servise.GetRandomNumber(),
Bus = new BusClass()
{
Id = Servise.GetRandomNumber(),
BusPark = Servise.GetRandomPark(),
Type = bysType
},
Tariff = tariff,
paymentMethod = PaymentMethods.CashMethod
};
switch ((int)paymentMethod)
{
case 1:
tiket.paymentMethod = PaymentMethods.CashMethod;
PayService.showTiket(tiket);
break;
case 2:
Console.WriteLine("Введите вид безналичной оплаты: ");
for (int i = 1; i <= cNonCashMethods; i++)
{
Console.WriteLine($"{i}.{(NonCashMethods)i}");
}
int.TryParse(Console.ReadLine(), out Choose);
NonCashMethods NonCashMethod = (NonCashMethods)Choose;
tiket.paymentMethod = PaymentMethods.NonCashMethods;
PayService.showTiket(tiket);
Console.WriteLine("Было оплачено через: " + NonCashMethod);
break;
}
}
public ActionResult Add()
{
Tiket model = new Tiket();
return(View("Form", model));
}
public void Add(Tiket Tiket)
{
}
public Task UpdateTiketAsync(Tiket tiket)
{
return(Task.CompletedTask);
}
