public async Task <IActionResult> Edit(int id, [Bind("AutoId,StdFeeCatId,StdFeeCategory,LoginName")] StdFeeCat StdFeeCat)
{
if (id != StdFeeCat.StdFeeCatId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(StdFeeCat);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StdFeeCatExists(StdFeeCat.StdFeeCatId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
return(View(StdFeeCat));
}
public async Task <IActionResult> PostStdFeeCat([FromBody] StdFeeCat StdFeeCat)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
var conn = _context.Database.GetDbConnection();
if (conn.State == ConnectionState.Closed)
{
await conn.OpenAsync();
}
using (var command = conn.CreateCommand())
{
MySql = " INSERT INTO StdCat ( StdCatID, StdCategory, ";
MySql = MySql + " Dormant, LoginName, ModTime, cTerminal, dBID) Values (0, '";
MySql = MySql + StdFeeCat.StdFeeCategory + "'";
MySql = MySql + ", 0,'" + strLoginName + "'," + GenFunc.GloFunc.ToOADate(DateTime.Now);
MySql = MySql + ",'" + Terminal + "'," + StdFeeCat.DBid + ")";
command.CommandType = CommandType.Text;
command.CommandText = MySql;
command.ExecuteNonQuery();
}
//UpdateAcaSession(acaSession);
// await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
return(CreatedAtAction("GetStdFeeCat", new { id = StdFeeCat.AutoId }, StdFeeCat));
}
public async Task <IActionResult> PutStdFeeCat([FromRoute] int id, [FromBody] StdFeeCat StdFeeCat)
{
var ssid = StdFeeCat.StdFeeCatId;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
var conn = _context.Database.GetDbConnection();
if (conn.State == ConnectionState.Closed)
{
await conn.OpenAsync();
}
using (var command = conn.CreateCommand())
{
MySql = " UPDATE StdCat SET ";
MySql = MySql + " StdCategory = '" + StdFeeCat.StdFeeCategory + "'";
MySql = MySql + " WHERE StdCatID = " + StdFeeCat.StdFeeCatId;
MySql = MySql + " AND Dormant = 0";
MySql = MySql + " AND dBID = " + StdFeeCat.DBid;
command.CommandType = CommandType.Text;
command.CommandText = MySql;
command.ExecuteNonQuery();
}
//UpdateAcaSession(acaSession);
// await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StdFeeCatExists(ssid))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> Create([Bind("StdFeeCatId,StdFeeCategory,LoginName")] StdFeeCat stdFeeCat)
{
if (ModelState.IsValid)
{
stdFeeCat.DBid = mdBId;
if (!StdFeeCatExists(stdFeeCat.StdFeeCategory))
{
using (HttpClient client = new HttpClient())
{
client.BaseAddress = new Uri(GloVar.iBaseURI);
MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json");
client.DefaultRequestHeaders.Accept.Add(contentType);
string stringData = JsonConvert.SerializeObject(stdFeeCat);
var contentData = new StringContent(stringData, System.Text.Encoding.UTF8, "application/json");
HttpResponseMessage response = client.PostAsync("/api/StdFeeCats", contentData).Result;
ViewBag.Message = response.Content.ReadAsStringAsync().Result;
if (response.IsSuccessStatusCode)
{
ViewBag.Remark = "Creation of Fee Category '" + stdFeeCat.StdFeeCategory + "' Successful";
return(View());
}
else
{
ViewBag.Remark = "Creation of Fee Category '" + stdFeeCat.StdFeeCategory + "' Failed!. Please Try Again";
return(View(stdFeeCat));
}
}
}
else
{
ViewBag.Remark = "Failed Fee Category '" + stdFeeCat.StdFeeCategory + "' Already Exists.";
return(View(stdFeeCat));
}
}
else
{
ViewBag.Remark = "Failed! Fee Category '" + stdFeeCat.StdFeeCategory + "' Unable To create. PleaseTry Again.";
return(View(stdFeeCat));
}
}
public IEnumerable <StdFeeCat> GetStdFeeCat(string dSess, int mdBId)
{
List <StdFeeCat> StdFeeCatList = new List <StdFeeCat>();
var conn = _context.Database.GetDbConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
using (var command = conn.CreateCommand())
{
MySql = " SELECT StdCatID, StdCategory FROM StdCat WITH (NOLOCK)";
MySql = MySql + " WHERE Dormant = 0";
MySql = MySql + " AND dBID = " + mdBId;
command.CommandType = CommandType.Text;
command.CommandText = MySql;
DbDataReader kMyReader = command.ExecuteReader();
if (kMyReader.HasRows)
{
while (kMyReader.Read())
{
StdFeeCat StdFeeCat = new StdFeeCat();
if (!kMyReader.IsDBNull(0))
{
StdFeeCat.StdFeeCatId = kMyReader.GetInt32(0);
}
if (!kMyReader.IsDBNull(1))
{
StdFeeCat.StdFeeCategory = kMyReader.GetString(1);
}
StdFeeCatList.Add(StdFeeCat);
}
}
}
return(StdFeeCatList);
}
