public static async System.Threading.Tasks.Task <int> CreateStdFAsync(SchContext _context, Students stdnts)
{
string MySql = "";
try
{
var conn = _context.Database.GetDbConnection();
if (conn.State == ConnectionState.Closed)
{
await conn.OpenAsync();
}
using (var command = conn.CreateCommand())
{
MySql = "INSERT INTO Students (";
MySql = MySql + " RegNumber, FirstName, Sex, DOB, ParentsNamesF, PresentClass, StdCategory, StdSession, StdStatus, EmailAddress,";
MySql = MySql + " UniReg, DateOfAdmission, ConPhone, StdGenCategory,";
MySql = MySql + " LoginName, ModTime, Dormant, cTerminal, dBID ) VALUES ( ";
MySql = MySql + " 0,'" + stdnts.StdName + "',";
if (stdnts.Sex == "Boy")
{
MySql = MySql + "1,";
}
else
{
MySql = MySql + "0,";
}
MySql = MySql + GloFunc.ToOADate(stdnts.Dob) + ",'" + stdnts.ParentsNamesF + "','" + stdnts.PresentClass + "','";
MySql = MySql + stdnts.StdCategory + "','" + stdnts.StdSession + "', 0,'" + stdnts.EmailAddress + "',0,";
MySql = MySql + GloFunc.ToOADate(DateTime.Now) + ",'" + stdnts.ConPhone + "','" + stdnts.StdGenCategory + "','";
MySql = MySql + repSplChr(strLoginName) + "'," + GloFunc.ToOADate(DateTime.Now) + ",0,'" + repSplChr(strComputerName) + "'," + stdnts.DBid + ")";
command.CommandType = CommandType.Text;
command.CommandText = MySql;
command.ExecuteNonQuery();
}
conn.Close();
return(0);
}
catch (DbUpdateConcurrencyException)
{
return(1);
}
}
public static int GetExamFullMarks(SchContext _context, string gClss, string gSubName, string tExamName, string dSess, int mdBId)
{
string MySql = "";
object tmpObj;
MySql = " SELECT FullMarks ";
MySql = MySql + " From ExamSub WITH (NOLOCK) ";
MySql = MySql + " WHERE SubName ='" + repSplChr(gSubName) + "'";
MySql = MySql + " AND ExamName ='" + repSplChr(tExamName) + "'";
MySql = MySql + " AND Clss = '" + repSplChr(gClss) + "'";
MySql = MySql + " AND SSession ='" + repSplChr(dSess) + "'";
MySql = MySql + " AND Dormant = 0";
MySql = MySql + " AND DBID = " + mdBId;
var conn = _context.Database.GetDbConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
using (var command = conn.CreateCommand())
{
command.CommandText = MySql;
command.CommandType = CommandType.Text;
tmpObj = command.ExecuteScalar();
if (!((Object)tmpObj == null))
{
if (GloFunc.IsNumeric(tmpObj.ToString()))
{
return(int.Parse(tmpObj.ToString()));
}
else
{
return(-1);
}
}
else
{
return(-1);
}
}
}
public static int GetSubName(SchContext _context, string tSubID, string tClass, string dSess, int mdBId)
{
string MySql2 = "";
object tmpObj;
var conn = _context.Database.GetDbConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
using (var command = conn.CreateCommand())
{
MySql2 = " SELECT SubName FROM Subjects WITH (NOLOCK)";
MySql2 = MySql2 + " WHERE SubID = " + tSubID;
MySql2 = MySql2 + " AND Clss = '" + repSplChr(tClass) + "'";
MySql2 = MySql2 + " AND AcaSession = '" + dSess + "'";
MySql2 = MySql2 + " AND Dormant = 0";
MySql2 = MySql2 + " AND dBID = " + mdBId;
command.CommandText = MySql2;
command.CommandType = CommandType.Text;
tmpObj = command.ExecuteScalar();
if (!((Object)tmpObj == null))
{
if (GloFunc.IsNumeric(tmpObj.ToString()))
{
return(int.Parse(tmpObj.ToString()));
}
else
{
return(-1);
}
}
else
{
return(-1);
}
//conn.Close();
}
}
public static DateTime GetStdFeeDateF(SchContext _context, string clss, string tSess, string stdFeeCat, string stdFeeCap, string dSess, int mdBId)
{
feeDate = DateTime.Now;
string kMySql = "";
var conn = _context.Database.GetDbConnection();
if (conn.State != ConnectionState.Open)
{
conn.Close();
conn.Open();
}
using (var command = conn.CreateCommand())
{
kMySql = " SELECT ForMonth ";
kMySql = kMySql + " FROM DynaFee";
kMySql = kMySql + " WHERE dBID = " + mdBId;
kMySql = kMySql + " AND Dormant = 0";
kMySql = kMySql + " AND SessionName = '" + tSess + "'";
kMySql = kMySql + " AND ForClass = '" + clss + "'";
kMySql = kMySql + " AND FeeCaption = '" + stdFeeCap + "'";
kMySql = kMySql + " AND StdCategory = '" + stdFeeCat + "'";
command.CommandText = kMySql;
command.CommandType = CommandType.Text;
DbDataReader kMyReader = command.ExecuteReader();
if (kMyReader.HasRows)
{
while (kMyReader.Read())
{
if (!kMyReader.IsDBNull(0))
{
feeDate = GloFunc.FromOADate(kMyReader.GetInt32(0));
}
}
}
}
conn.Close();
return(feeDate);
}
