public ActionResult DataSource(string clss, DateTime stDate, [FromBody] DataManagerRequest dm)
{
double fStDate = GloFunc.ToOADate(stDate);
using (HttpClient client = new HttpClient())
{
client.BaseAddress = new Uri(iBaseURI);
MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json");
client.DefaultRequestHeaders.Accept.Add(contentType);
HttpResponseMessage response = client.GetAsync("/api/Conveyances?clss=" + clss + "&stDate=" + fStDate + "&dSess=" + dSess + "&mdBID=" + mdBId).Result;
var stringData = response.Content.ReadAsStringAsync().Result;
List <Conveyance> subjects = JsonConvert.DeserializeObject <List <Conveyance> >(stringData);
DataOperations operation = new DataOperations();
IEnumerable data = subjects;
var count = data.AsQueryable().Count();
if (dm.Skip > 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take > 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }));
}
}
public async Task <IActionResult> PutTransActivity([FromRoute] int id, [FromBody] TransActivity transActivity)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
transActivity.ActivityId = GetActivityID(_context, transActivity.Activity, transActivity.ActGroupID, transActivity.DBid);
var conn = _context.Database.GetDbConnection();
if (conn.State == ConnectionState.Closed)
{
await conn.OpenAsync();
}
using (var command = conn.CreateCommand())
{
if (transActivity.Activity == "None")
{
if (transActivity.TransActId != 0)
{
MySql = " UPDATE TransActivity SET ";
MySql = MySql + " Dormant = 1 ";
MySql = MySql + " WHERE TransActID = " + transActivity.TransActId;
MySql = MySql + " AND RegNumber = " + transActivity.RegNumber;
command.CommandType = CommandType.Text;
command.CommandText = MySql;
command.ExecuteNonQuery();
}
}
else
{
MySql = " INSERT INTO TransActivity (TransActID, TransActName, ActivityID, RegNumber, TransActValue, "
+ "TransActDate, TransActObserver, TeachID, TransActRemarks, UniReg, Score, ";
MySql = MySql + " Dormant, LoginName, ModTime, cTerminal, dBID) Values (0, '";
MySql = MySql + transActivity.Activity + "'," + transActivity.ActivityId + "," + transActivity.RegNumber + ","
+ transActivity.TransActValue + "," + GloFunc.ToOADate(transActivity.TransActDate) + ",'"
+ transActivity.TransActObserver + "',0,'" + transActivity.TransActRemarks + "'," + transActivity.UniReg + ",0,";
MySql = MySql + "0,'" + transActivity.LoginName + "'," + GenFunc.GloFunc.ToOADate(DateTime.Now);
MySql = MySql + ",'" + transActivity.CTerminal + "'," + transActivity.DBid + ")";
command.CommandType = CommandType.Text;
command.CommandText = MySql;
command.ExecuteNonQuery();
}
}
}
catch (DbUpdateConcurrencyException)
{
if (!TransActivityExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <int> GetSubID([FromBody] SelectMarks selectMarks)
{
if (!ModelState.IsValid)
{
return(-1);
}
string MySql2 = "";
object tmpObj;
var conn = _context.Database.GetDbConnection();
if (conn.State == ConnectionState.Closed)
{
await conn.OpenAsync();
}
using (var command = conn.CreateCommand())
{
MySql2 = " SELECT SubID FROM Subjects WITH (NOLOCK)";
MySql2 = MySql2 + " WHERE SubName = '" + repSplChr(selectMarks.SubName) + "'";
MySql2 = MySql2 + " AND Clss = '" + repSplChr(selectMarks.MClss) + "'";
MySql2 = MySql2 + " AND AcaSession = '" + repSplChr(selectMarks.Sessn) + "'";
MySql2 = MySql2 + " AND Dormant = 0";
MySql2 = MySql2 + " AND dBID = " + selectMarks.DBid;
command.CommandType = CommandType.Text;
tmpObj = command.ExecuteScalarAsync();
if (!((Object)tmpObj == null))
{
if (GloFunc.IsNumeric(tmpObj.ToString()))
{
return(int.Parse(tmpObj.ToString()));
}
else
{
return(-1);
}
}
else
{
return(-1);
}
//conn.Close();
}
//var subjects = await _context.Subjects.SingleOrDefaultAsync(m => m.SubAutoId == id);
//if (subjects == null)
//{
// return NotFound();
//}
//return Ok(subjects);
}
public async Task <IActionResult> PutDynaFee([FromRoute] int id, [FromBody] DynaFee dynaFee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.Entry(dynaFee).State = EntityState.Modified;
try
{
var conn = _context.Database.GetDbConnection();
if (conn.State == ConnectionState.Closed)
{
await conn.OpenAsync();
}
using (var command = conn.CreateCommand())
{
if (dynaFee.ClsFeeId != 0)
{
MySql = " DELETE FROM DynaFee"
+ " WHERE Dormant = 0 "
+ " AND ClsFeeId = " + dynaFee.ClsFeeId
+ " AND ForClass = '" + dynaFee.ForClass + "'"
+ " AND StdCategory = '" + dynaFee.StdCategory + "'"
+ " AND SessionName = '" + dynaFee.SessionName + "'"
+ " AND FeeCaption = '" + dynaFee.FeeCaption + "'"
+ " AND Caption = '" + dynaFee.Caption + "'";
command.CommandType = CommandType.Text;
command.CommandText = MySql;
command.ExecuteNonQuery();
}
MySql = " INSERT INTO DynaFee ( ClsFeeId, FeeNo, Caption, ForMonth, Amount, FeeCaption, PayByDate, ForClass, " +
"StdCategory, SessionName, DueOn,"
+ " Dormant, LoginName, ModTime, cTerminal, dBID) Values ("
+ dynaFee.ClsFeeId + "," + dynaFee.FeeNo + ",'" + dynaFee.Caption + "'," + GloFunc.ToOADate(dynaFee.ForMonth) + ","
+ dynaFee.Amount + ",'" + dynaFee.FeeCaption + "'," + GloFunc.ToOADate(dynaFee.PayByDate) + ",'" + dynaFee.ForClass + "','"
+ dynaFee.StdCategory + "','" + dynaFee.SessionName + "'," + GloFunc.ToOADate(dynaFee.DueOn)
+ ", 0,'" + dynaFee.LoginName + "'," + DateTime.Now.Date.ToOADate()
+ ",'" + dynaFee.CTerminal + "'," + dynaFee.DBid + ")";
command.CommandType = CommandType.Text;
command.CommandText = MySql;
command.ExecuteNonQuery();
}
}
catch (DbUpdateConcurrencyException)
{
throw;
}
return(NoContent());
}
public ActionResult Update(string clss, DateTime stDate, [FromBody] ConveyanceEdit ConveyancesVal)
{
double fStDate = GloFunc.ToOADate(stDate);
if (ConveyancesVal.Value.Commit)
{
ConveyancesVal.Value.Clss = clss;
ConveyancesVal.Value.DateFrom = stDate;
ConveyancesVal.Value.DBid = mdBId;
try
{
using (HttpClient client = new HttpClient())
{
client.BaseAddress = new Uri(iBaseURI);
MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json");
client.DefaultRequestHeaders.Accept.Add(contentType);
string stringData = JsonConvert.SerializeObject(ConveyancesVal.Value);
var contentData = new StringContent(stringData, System.Text.Encoding.UTF8, "application/json");
HttpResponseMessage response = client.PutAsync("/api/Conveyances/" + ConveyancesVal.Key + mdBId, contentData).Result;
ViewBag.Message = response.Content.ReadAsStringAsync().Result;
}
//_context.Update(acaSession);
//await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ConveyanceExists(ConveyancesVal.Value.ConId))
{
return(NotFound());
}
else
{
throw;
}
}
}
//AcaSession acsess = JsonConvert.DeserializeObject<AcaSession>(value);
return(Json(ConveyancesVal.Value));
}
public async Task <IActionResult> PutMarks([FromRoute] int id, [FromBody] Marks marks)
{
string MySql = "";
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 Marks SET ";
MySql = MySql + " Dormant = 1 ";
MySql = MySql + " WHERE SubName ='" + repSplChr(marks.SubName) + "'";
MySql = MySql + " AND ExamName ='" + repSplChr(marks.ExamName) + "'";
MySql = MySql + " AND MClss = '" + repSplChr(marks.MClss) + "'";
MySql = MySql + " AND MSession ='" + repSplChr(marks.MSession) + "'";
MySql = MySql + " AND DBID = " + marks.dBID;
MySql = MySql + " AND UniReg =" + marks.UniReg;
command.CommandType = CommandType.Text;
command.CommandText = MySql;
command.ExecuteNonQuery();
MySql = "INSERT INTO Marks (";
MySql = MySql + " MkID, MClss, SubName, ExamName, TotalMarks, ThMarks, PracMarks, OrMarks, AsgnMarks,";
MySql = MySql + " RegNum, MSession, TotalMarksCalc, Grades, StdGrades, LoginName, ModTime, Dormant, cTerminal, dBID, UniReg) VALUES ( ";
MySql = MySql + marks.MkID + " ,'";
MySql = MySql + repSplChr(marks.MClss) + "','";
MySql = MySql + repSplChr(marks.SubName) + "','";
MySql = MySql + repSplChr(marks.ExamName) + "',";
switch (marks.TotalMarks)
{
case null:
MySql = MySql + " -1 ,";
break;
case "":
MySql = MySql + " -1 ,";
break;
case "ab":
case "Ab":
case "AB":
case "aB":
MySql = MySql + " -2 ,";
break;
case "na":
case "Na":
case "NA":
case "nA":
MySql = MySql + " -5 ,";
break;
default: MySql = MySql + Convert.ToDouble(marks.TotalMarks) + ",";
break;
}
switch (marks.ThMarks)
{
case null:
MySql = MySql + " -1 ,";
break;
case "":
MySql = MySql + " -1 ,";
break;
case "ab":
case "Ab":
case "AB":
case "aB":
MySql = MySql + " -2 ,";
break;
case "na":
case "Na":
case "NA":
case "nA":
MySql = MySql + " -5 ,";
break;
default:
MySql = MySql + Convert.ToDouble(marks.ThMarks) + ",";
break;
}
switch (marks.PracMarks)
{
case null:
MySql = MySql + " -1 ,";
break;
case "":
MySql = MySql + " -1 ,";
break;
case "ab":
case "Ab":
case "AB":
case "aB":
MySql = MySql + " -2 ,";
break;
case "na":
case "Na":
case "NA":
case "nA":
MySql = MySql + " -5 ,";
break;
default:
MySql = MySql + Convert.ToDouble(marks.PracMarks) + ",";
break;
}
switch (marks.OrMarks)
{
case null:
MySql = MySql + " -1 ,";
break;
case "":
MySql = MySql + " -1 ,";
break;
case "ab":
case "Ab":
case "AB":
case "aB":
MySql = MySql + " -2 ,";
break;
case "na":
case "Na":
case "NA":
case "nA":
MySql = MySql + " -5 ,";
break;
default:
MySql = MySql + Convert.ToDouble(marks.OrMarks) + ",";
break;
}
switch (marks.AsgnMarks)
{
case null:
MySql = MySql + " -1 ,";
break;
case "":
MySql = MySql + " -1 ,";
break;
case "ab":
case "Ab":
case "AB":
case "aB":
MySql = MySql + " -2 ,";
break;
case "na":
case "Na":
case "NA":
case "nA":
MySql = MySql + " -5 ,";
break;
default:
MySql = MySql + Convert.ToDouble(marks.AsgnMarks) + ",";
break;
}
MySql = MySql + marks.RegNum + ",'";
MySql = MySql + repSplChr(marks.MSession) + "',";
switch (marks.TotalMarksCalc)
{
case null:
MySql = MySql + " -1 ,";
break;
case "":
MySql = MySql + " -1 ,";
break;
case "ab":
case "Ab":
case "AB":
case "aB":
MySql = MySql + " -2 ,";
break;
case "na":
case "Na":
case "NA":
case "nA":
MySql = MySql + " -5 ,";
break;
default:
MySql = MySql + Convert.ToDouble(marks.TotalMarksCalc) + ",";
break;
}
MySql = MySql + "'" + marks.Grades + "','";
MySql = MySql + repSplChr(marks.StdGrades) + "','";
MySql = MySql + repSplChr(strLoginName) + "'," + GloFunc.ToOADate(DateTime.Now) + ",0,'" + repSplChr(strComputerName) + "'," + marks.dBID + "," + marks.UniReg + ")";
command.CommandType = CommandType.Text;
command.CommandText = MySql;
command.ExecuteNonQuery();
}
//await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MarksExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public IEnumerable <DynaFee> GetDynaFee(string clss, string tSess, string stdFeeCat, string FeeCap, string dSess, int mdBId, int Mode = 0)
{
int tAutoid = 0;
List <DynaFee> dynaFeeList = new List <DynaFee>();
List <string> FeeCaptionList = new List <string>();
var conn = _context.Database.GetDbConnection();
DbDataReader kMyReader;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
using (var command = conn.CreateCommand())
{
if (Mode == 0)
{
MySql = " SELECT DISTINCT FeeCaption ";
MySql = MySql + " FROM FCaption WITH (NOLOCK)";
MySql = MySql + " WHERE Dormant = 0";
MySql = MySql + " AND ShowIt = 0";
MySql = MySql + " AND dBID = " + mdBId;
command.CommandType = CommandType.Text;
command.CommandText = MySql;
kMyReader = command.ExecuteReader();
if (kMyReader.HasRows)
{
while (kMyReader.Read())
{
if (!kMyReader.IsDBNull(0))
{
FeeCaptionList.Add(kMyReader.GetString(0));
}
}
}
kMyReader.Close();
}
MySql = " SELECT ClsFeeId, FeeNo, Caption, ForMonth, Amount, FeeCaption, ";
MySql = MySql + " PayByDate, ForClass, StdCategory, SessionName, DueOn ";
MySql = MySql + " FROM DynaFee WITH (NOLOCK)";
MySql = MySql + " WHERE Dormant = 0";
MySql = MySql + " AND dBID = " + mdBId;
MySql = MySql + " AND ForClass = '" + clss + "'";
MySql = MySql + " AND SessionName = '" + tSess + "'";
MySql = MySql + " AND StdCategory = '" + stdFeeCat + "'";
MySql = MySql + " AND FeeCaption = '" + FeeCap + "'";
command.CommandType = CommandType.Text;
command.CommandText = MySql;
kMyReader = command.ExecuteReader();
if (kMyReader.HasRows)
{
while (kMyReader.Read())
{
DynaFee dynFee = new DynaFee();
dynFee.AutoId = tAutoid + 1;
if (!kMyReader.IsDBNull(0))
{
dynFee.ClsFeeId = kMyReader.GetInt32(0);
}
if (!kMyReader.IsDBNull(1))
{
dynFee.FeeNo = kMyReader.GetInt32(1);
}
if (!kMyReader.IsDBNull(2))
{
dynFee.Caption = kMyReader.GetString(2);
FeeCaptionList.Remove(dynFee.Caption);
}
if (!kMyReader.IsDBNull(3))
{
dynFee.ForMonth = GloFunc.FromOADate(kMyReader.GetInt32(3));
}
if (!kMyReader.IsDBNull(4))
{
dynFee.Amount = kMyReader.GetDouble(4);
}
if (!kMyReader.IsDBNull(5))
{
dynFee.FeeCaption = kMyReader.GetString(5);
}
if (!kMyReader.IsDBNull(6))
{
dynFee.PayByDate = GloFunc.FromOADate(kMyReader.GetDouble(6));
}
if (!kMyReader.IsDBNull(7))
{
dynFee.ForClass = kMyReader.GetString(7);
}
if (!kMyReader.IsDBNull(8))
{
dynFee.StdCategory = kMyReader.GetString(8);
}
if (!kMyReader.IsDBNull(9))
{
dynFee.SessionName = kMyReader.GetString(9);
}
if (!kMyReader.IsDBNull(10))
{
dynFee.DueOn = GloFunc.FromOADate(kMyReader.GetDouble(10));
}
dynaFeeList.Add(dynFee);
tAutoid = tAutoid + 1;
}
}
kMyReader.Close();
}
foreach (var item in FeeCaptionList)
{
DynaFee dynFee = new DynaFee();
dynFee.AutoId = tAutoid + 1;
dynFee.Caption = item;
dynFee.ClsFeeId = 0;
dynFee.FeeNo = 0;
//dynFee.ForMonth = item.ForMonth;
dynFee.Amount = 0;
dynFee.ForClass = clss;
dynFee.StdCategory = stdFeeCat;
dynFee.SessionName = tSess;
dynaFeeList.Add(dynFee);
tAutoid = tAutoid + 1;
}
return(dynaFeeList);
}
