public string InsertAdmitCardForm(EntranceDM.AdmitCardForm objACM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
objDB.CreateParameters(5);
objDB.AddParameters(0, "onlineID", objACM.onlineID, DbType.Int32);
objDB.AddParameters(1, "ExamID", objACM.ExamID, DbType.Int32);
objDB.AddParameters(2, "Srollno", objACM.Srollno, DbType.Int32);
objDB.AddParameters(3, "Dispatchno", objACM.Dispatchno, DbType.Int32);
objDB.AddParameters(4, "Flag", objACM.Flag, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "AdmitCard_insert");
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", "N", DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (objACM.Flag == "N")
{
retv = "Record saved.";
}
else if (objACM.Flag == "U")
{
retv = "Record Updated Successfully.";
}
else
{
retv = "Record deleted Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertEduMetaDataForm(EduMetaDataDM.EduMetaData objEFM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
objDB.CreateParameters(8);
objDB.AddParameters(0, "EduID", objEFM.EduID, DbType.Int32);
objDB.AddParameters(1, "Module", objEFM.Module, DbType.Int32);
objDB.AddParameters(2, "Form", objEFM.Form, DbType.Int32);
objDB.AddParameters(3, "Type1", objEFM.Type1, DbType.String);
objDB.AddParameters(4, "CreateName", objEFM.CreateName, DbType.String);
objDB.AddParameters(5, "Syntax", objEFM.Syntax, DbType.String);
objDB.AddParameters(6, "DefaultValue", objEFM.DefaultValue, DbType.String);
objDB.AddParameters(7, "flag", objEFM.Flag, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Edu_MetaData");
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (objEFM.Flag == "N")
{
retv = "Record saved.";
}
else if (objEFM.Flag == "U")
{
retv = "Record Updated Successfully.";
}
else
{
retv = "Record deleted Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertBulkAssignRole(List <SecurityDM.AssignRoleDM> RoleDM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
int f = 0;
try
{
foreach (SecurityDM.AssignRoleDM tsv in RoleDM)
{
objDB.CreateParameters(6);
objDB.AddParameters(0, "flag", tsv.flag, DbType.String);
objDB.AddParameters(1, "roleID", tsv.roleID, DbType.Int32);
objDB.AddParameters(2, "IndividualId", tsv.IndividualId, DbType.String);
objDB.AddParameters(3, "instId", tsv.instId, DbType.Int32);
objDB.AddParameters(4, "sessionId", tsv.sessionId, DbType.String);
objDB.AddParameters(5, "FormId", tsv.FormId, DbType.String);
retv = tsv.flag;
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Insert_BulkAssignRole");
}
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (retv == "N")
{
retv = "Record saved.";
}
else
{
retv = "Record Updated Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertPeriodMaster(TimeTableDM.PeriodMaster objPM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDBC = new DBManager();
objDBC.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDBC.DBManager(DataAccessLayer.DataProvider.SqlServer, objDBC.ConnectionString);
objDBC.Open();
objDBC.BeginTransaction();
string retv = "";
string f = "";
try
{
objDBC.CreateParameters(6);
objDBC.AddParameters(0, "PeriodID", objPM.PeriodID, DbType.Int32);
objDBC.AddParameters(1, "Period_Type", objPM.Period_Type, DbType.String);
objDBC.AddParameters(2, "Pshort_name", objPM.Pshort_name, DbType.String);
objDBC.AddParameters(3, "Category", "0", DbType.String);
objDBC.AddParameters(4, "Status", objPM.Status, DbType.Int32);
objDBC.AddParameters(5, "Flag", objPM.Flag, DbType.String);
objDBC.ExecuteNonQuery(CommandType.StoredProcedure, "PeriodMaster_insert");
objDBC.CreateParameters(9);
objDBC.AddParameters(0, "ID", 0, DbType.Int32);
objDBC.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDBC.AddParameters(2, "Action", audit.Action, DbType.String);
objDBC.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDBC.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDBC.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDBC.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDBC.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDBC.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDBC.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDBC.Transaction.Commit();
if (objPM.Flag == "N")
{
retv = "Record saved.";
}
else if (objPM.Flag == "U")
{
retv = "Record Updated Successfully.";
}
else
{
retv = "Record deleted Successfully.";
}
}
catch (Exception ex)
{
objDBC.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDBC.Connection.Close();
objDBC.Dispose();
}
return(retv);
}
public string DeletePeriodTemplate(TimeTableDM.PeriodtemplateDM objDl, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
objDB.CreateParameters(4);
objDB.AddParameters(0, "flag", objDl.Flag, DbType.String);
objDB.AddParameters(1, "Inst_Id", objDl.Inst_ID, DbType.String);
objDB.AddParameters(2, "Session", objDl.Session, DbType.String);
objDB.AddParameters(3, "TemplateID", objDl.TemplateID, DbType.Int32);
f = objDl.Flag;
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "PeriodTemp_Insert");
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (f == "N")
{
retv = "Record saved.";
}
else if (f == "U")
{
retv = "Record Updated Successfully.";
}
else
{
retv = "Record Deleted Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to Delete Record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertSeatManagement(List <EntranceDM.EN_SeatManagement> objESM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
foreach (EntranceDM.EN_SeatManagement ESM in objESM)
{
objDB.CreateParameters(5);
objDB.AddParameters(0, "SeatMgmtID", ESM.SeatMgmtID, DbType.Int32);
objDB.AddParameters(1, "RollnoFrom", ESM.RollnoFrom, DbType.String);
objDB.AddParameters(2, "RollnoTo", ESM.RollnoTo, DbType.String);
objDB.AddParameters(3, "SeatCode", ESM.SeatCode, DbType.String);
objDB.AddParameters(4, "Flag", ESM.Flag, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Seat_Management_Insert");
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
}
objDB.Transaction.Commit();
retv = "Record saved.";
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertTemplateMaster(List <TimeTableDM.TemplateDM> objTDM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string flag = "";
try
{
foreach (TimeTableDM.TemplateDM tem in objTDM)
{
objDB.CreateParameters(6);
objDB.AddParameters(0, "Template_ID", tem.Template_ID, DbType.Int32);
objDB.AddParameters(1, "Template_Name", tem.Template_Name, DbType.String);
objDB.AddParameters(2, "TShort_Name", tem.TShort_Name, DbType.String);
objDB.AddParameters(3, "Status", tem.Status, DbType.String);
objDB.AddParameters(4, "InstituteID", tem.InstituteID, DbType.Int32);
objDB.AddParameters(5, "flag", tem.flag, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Template_MasterInsert");
}
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
retv = "Record saved.";
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertVerificationForm(EntranceDM.VerificationForm objVFM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
objDB.CreateParameters(5);
objDB.AddParameters(0, "onlineID", objVFM.onlineID, DbType.Int32);
objDB.AddParameters(1, "status", objVFM.status, DbType.String);
objDB.AddParameters(2, "Paymentstatus", objVFM.Paymentstatus, DbType.String);
objDB.AddParameters(3, "remark", objVFM.remark, DbType.String);
objDB.AddParameters(4, "remarkedby", objVFM.remarkedby, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "VerificationForm_insert");
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", "N", DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
retv = "Record saved.";
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertTestMaster(ExamDM.ExamMasterDM objIFM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
objDB.CreateParameters(16);
objDB.AddParameters(0, "testId", objIFM.testid, DbType.Int32);
objDB.AddParameters(1, "testtypeId", objIFM.testtypeid, DbType.Int32);
objDB.AddParameters(2, "testname", objIFM.testname, DbType.String);
objDB.AddParameters(3, "mMarks", objIFM.maxmark, DbType.Int32);
objDB.AddParameters(4, "isCompulsory", objIFM.iscompul, DbType.Int32);
objDB.AddParameters(5, "fromdate", objIFM.fromdate, DbType.Int32);
objDB.AddParameters(6, "todate", objIFM.todate, DbType.Int32);
objDB.AddParameters(7, "flag", objIFM.Flag, DbType.String);
objDB.AddParameters(8, "Semid", objIFM.Semid, DbType.Int32);
objDB.AddParameters(9, "ExamCategoryid", objIFM.ExamCategoryid, DbType.Int32);
objDB.AddParameters(10, "SpclID", objIFM.SpclID, DbType.Int32);
objDB.AddParameters(11, "facultyID", objIFM.facultyID, DbType.Int32);
objDB.AddParameters(12, "InstID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(13, "sessionID", audit.SessionID, DbType.String);
objDB.AddParameters(14, "testduration", objIFM.testduration, DbType.Int32);
objDB.AddParameters(15, "ratten", objIFM.Ratten, DbType.Int32);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Insert_itestMaster");
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (objIFM.Flag == "N")
{
retv = "Exam Details saved successfully..!!Please Move On Exam Scheduling";
}
else if (objIFM.Flag == "U")
{
retv = "Record Updated Successfully.";
}
else
{
retv = "Record deleted Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string Insertformactivation(SecurityDM.FormActiDM RoleDM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
int f = 0;
try
{
objDB.CreateParameters(14);
objDB.AddParameters(0, "flag", RoleDM.flag, DbType.String);
objDB.AddParameters(1, "id", RoleDM.id, DbType.Int32);
objDB.AddParameters(2, "Inst_Id", RoleDM.Inst_Id, DbType.Int32);
objDB.AddParameters(3, "SessionId", RoleDM.SessionId, DbType.String);
objDB.AddParameters(4, "CourseId", RoleDM.CourseId, DbType.Int32);
objDB.AddParameters(5, "splid", RoleDM.splid, DbType.Int32);
objDB.AddParameters(6, "semid", RoleDM.semid, DbType.Int32);
objDB.AddParameters(7, "FormId", RoleDM.FormId, DbType.Int32);
objDB.AddParameters(8, "MoudleId", RoleDM.MoudleId, DbType.Int32);
objDB.AddParameters(9, "Fromdate", RoleDM.Fromdate, DbType.DateTime);
objDB.AddParameters(10, "Todate", RoleDM.Todate, DbType.DateTime);
objDB.AddParameters(11, "Action", RoleDM.Action, DbType.Int32);
objDB.AddParameters(12, "fromtime", RoleDM.fromtime, DbType.String);
objDB.AddParameters(13, "totime", RoleDM.totime, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "InsertFormActivation");
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (RoleDM.flag == "N")
{
retv = "Record saved.";
}
else
{
retv = "Record Updated Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertRole(SecurityDM.RoleDM RoleDM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
int f = 0;
try
{
objDB.CreateParameters(5);
objDB.AddParameters(0, "RoleID", RoleDM.RoleID, DbType.Int32);
objDB.AddParameters(1, "RoleName", RoleDM.RoleName, DbType.String);
objDB.AddParameters(2, "IsActive", RoleDM.IsActive, DbType.String);
objDB.AddParameters(3, "flag", RoleDM.Flag, DbType.Int32);
objDB.AddParameters(4, "RoleIDreturn", "xxxxxxxxxx", DbType.String, ParameterDirection.Output);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Createrole_Insert");
Int32 Rid = 0; // Int32.Parse(objDB.Parameters[68].Value.ToString());
if (RoleDM.Flag == 1)
{
Rid = RoleDM.RoleID;
}
else
{
Rid = Int32.Parse(objDB.Parameters[4].Value.ToString());
}
List <SecurityDM.FillMenuIDDM> FillMenuID = new List <SecurityDM.FillMenuIDDM>();
FillMenuID = FillMenuIDAll();
foreach (SecurityDM.FillMenuIDDM mID in FillMenuID)
{
objDB.CreateParameters(7);
objDB.AddParameters(0, "RoleID", Rid, DbType.Int32);
objDB.AddParameters(1, "MenuID", mID.MenuID, DbType.Int32);
objDB.AddParameters(2, "permission", 0, DbType.Int32);
objDB.AddParameters(3, "insertOp", 0, DbType.Int32);
objDB.AddParameters(4, "updateOp", 0, DbType.Int32);
objDB.AddParameters(5, "deleteOp", 0, DbType.Int32);
objDB.AddParameters(6, "flag", RoleDM.Flag, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "menuPermissionSP");
}
f = RoleDM.Flag;
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (f == 0)
{
retv = "Record saved.";
}
else if (f == 1)
{
retv = "Record Updated Successfully.";
}
else
{
retv = "Record deleted Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertAssignRole(SecurityDM.AssignRoleDM RoleDM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
int f = 0;
try
{
objDB.CreateParameters(11);
objDB.AddParameters(0, "flag", RoleDM.flag, DbType.String);
objDB.AddParameters(1, "id", RoleDM.id, DbType.Int32);
objDB.AddParameters(2, "ARCID", RoleDM.ARCID, DbType.Int32);
objDB.AddParameters(3, "roleID", RoleDM.roleID, DbType.Int32);
objDB.AddParameters(4, "FieldId", RoleDM.FieldId, DbType.Int32);
objDB.AddParameters(5, "FieldDataId", RoleDM.FieldDataId, DbType.String);
objDB.AddParameters(6, "IndividualId", RoleDM.IndividualId, DbType.String);
objDB.AddParameters(7, "instId", RoleDM.instId, DbType.Int32);
objDB.AddParameters(8, "sessionId", RoleDM.sessionId, DbType.String);
objDB.AddParameters(9, "FormId", RoleDM.FormId, DbType.String);
// objDB.AddParameters(10, "flag_N", RoleDM.flag_N, DbType.String);
objDB.AddParameters(10, "RetSuccess", "xxxxxxxxxx", DbType.String, ParameterDirection.Output);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Insert_AssignRole");
// Rid = Int32.Parse(objDB.Parameters[11].Value.ToString());
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (RoleDM.flag == "N")
{
retv = "Record saved.";
}
else
{
retv = "Record Updated Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertInternalSubjetGrouping(List <ExamDM.FillInternalMarksDM> objPSF, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
foreach (ExamDM.FillInternalMarksDM BDM in objPSF)
{
objDB.CreateParameters(13);
objDB.AddParameters(0, "RecordId", BDM.RecordId, DbType.Int32);
objDB.AddParameters(1, "EgroupId", BDM.EgroupId, DbType.Int32);
objDB.AddParameters(2, "Subjectid", BDM.Subjectid, DbType.Int32);
objDB.AddParameters(3, "StudentID", BDM.StudentID, DbType.Int32);
objDB.AddParameters(4, "SubCategoryID", BDM.SubCategoryID, DbType.Int32);
objDB.AddParameters(5, "flag", BDM.Flag, DbType.String);
objDB.AddParameters(6, "courseid", BDM.courseid, DbType.Int32);
objDB.AddParameters(7, "semid", BDM.semid, DbType.Int32);
objDB.AddParameters(8, "splid", BDM.specid, DbType.Int32);
objDB.AddParameters(9, "instid", BDM.Inst_Id, DbType.Int32);
objDB.AddParameters(10, "sessionid", BDM.sessionid, DbType.String);
objDB.AddParameters(11, "userid", BDM.userid, DbType.Int32);
objDB.AddParameters(12, "Entrydate", BDM.EntryDate, DbType.DateTime);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "InsertElec_SubGroupData");
f = BDM.Flag;
}
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (f == "N")
{
retv = "Record saved.";
}
else if (f == "U")
{
retv = "Record Updated Successfully.";
}
else
{
retv = "Record deleted Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
return(retv);
}
public string InsertTestSchedule1(ExamDM.ExamScheduleDM objDM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
objDB.CreateParameters(15);
objDB.AddParameters(0, "testschId", objDM.testschid, DbType.Int32);
objDB.AddParameters(1, "testId", objDM.testid, DbType.Int32);
objDB.AddParameters(2, "subjectId", objDM.Subjectid, DbType.String);
objDB.AddParameters(3, "testDate", objDM.testdate1, DbType.DateTime);
objDB.AddParameters(4, "Unit_Name", objDM.Unit_Name, DbType.String);
objDB.AddParameters(5, "Unit_Id", objDM.Unit_Id, DbType.String);
objDB.AddParameters(6, "sessionId", objDM.sessionid, DbType.String);
objDB.AddParameters(7, "courseId", objDM.courseid, DbType.Int32);
objDB.AddParameters(8, "specid", objDM.specid, DbType.Int32);
objDB.AddParameters(9, "semid", objDM.semid, DbType.Int32);
objDB.AddParameters(10, "flag", objDM.Flag, DbType.String);
objDB.AddParameters(11, "Remark", objDM.remark, DbType.String);
objDB.AddParameters(12, "Status", objDM.Status, DbType.String);
objDB.AddParameters(13, "TimeFrom", objDM.TimeFrom, DbType.String);
objDB.AddParameters(14, "TimeTo", objDM.TimeTo, DbType.String);
retv = objDM.Flag;
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Insert_itestSchedule_new");
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (retv == "N")
{
retv = "Test Date Scheduled Successfully..!!";
}
else if (retv == "U")
{
retv = "Test Date Updated Successfully..!!";
}
else
{
retv = "Record deleted Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertFacultyAttendence(FacultyDM.FacultyAttendence objFAM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
objDB.CreateParameters(10);
objDB.AddParameters(0, "ID", objFAM.ID, DbType.Int32);
objDB.AddParameters(1, "InstituteID", objFAM.InstituteID, DbType.Int32);
objDB.AddParameters(2, "SessionID", objFAM.SessionID, DbType.String);
objDB.AddParameters(3, "FacultyID", objFAM.FacultyID, DbType.Int32);
objDB.AddParameters(4, "DayID", objFAM.DayID, DbType.Int32);
objDB.AddParameters(5, "AttDate", objFAM.AttDate, DbType.DateTime);
objDB.AddParameters(6, "TimeFrom", objFAM.TimeFrom, DbType.String);
objDB.AddParameters(7, "TimeTo", objFAM.TimeTo, DbType.String);
objDB.AddParameters(8, "Status", objFAM.Status, DbType.String);
objDB.AddParameters(9, "flag", objFAM.Flag, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Faculty_Attendence_A");
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (objFAM.Flag == "N")
{
retv = "Record saved.";
}
else if (objFAM.Flag == "U")
{
retv = "Record Updated Successfully.";
}
else
{
retv = "Record deleted Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertSaleForm(EntranceDM.SaleForm objSFM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
objDB.CreateParameters(12);
objDB.AddParameters(0, "saleID", objSFM.saleID, DbType.Int32);
objDB.AddParameters(1, "formsrno", objSFM.formsrno, DbType.Int32);
objDB.AddParameters(2, "issuedate", objSFM.issuedate, DbType.DateTime);
objDB.AddParameters(3, "fname", objSFM.fname, DbType.String);
objDB.AddParameters(4, "mname", objSFM.mname, DbType.String);
objDB.AddParameters(5, "lname", objSFM.lname, DbType.String);
objDB.AddParameters(6, "contactno", objSFM.contactno, DbType.String);
objDB.AddParameters(7, "amount", objSFM.amount, DbType.String);
objDB.AddParameters(8, "paymentmode", objSFM.paymentmode, DbType.Int32);
objDB.AddParameters(9, "issueto", objSFM.issueto, DbType.String);
objDB.AddParameters(10, "formsquantity", objSFM.formsquantity, DbType.Int32);
objDB.AddParameters(11, "flag", objSFM.Flag, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Saleform_insert");
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (objSFM.Flag == "N")
{
retv = "Record saved.";
}
else if (objSFM.Flag == "U")
{
retv = "Record Updated Successfully.";
}
else
{
retv = "Record deleted Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertExamType1(ExamDM.ExamTypeDM objIFM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
objDB.CreateParameters(19);
objDB.AddParameters(0, "testtypeId", objIFM.itesttypeId, DbType.Int32);
objDB.AddParameters(1, "sessionId", objIFM.sessionId, DbType.String);
objDB.AddParameters(2, "Courseid", objIFM.Courseid, DbType.Int32);
objDB.AddParameters(3, "testtypename", objIFM.testtypename, DbType.String);
objDB.AddParameters(4, "testduration", objIFM.testduration, DbType.Int32);
objDB.AddParameters(5, "weightage", objIFM.weighatge, DbType.Int32);
objDB.AddParameters(6, "status", objIFM.status, DbType.String);
objDB.AddParameters(7, "nooftests", objIFM.nooftest, DbType.Int32);
objDB.AddParameters(8, "bestcount", objIFM.bestcount, DbType.Int32);
objDB.AddParameters(9, "periodno", objIFM.periodno, DbType.String);
objDB.AddParameters(10, "quepapersubBdays", objIFM.Quessubday, DbType.Int32);
objDB.AddParameters(11, "marksubAdays", objIFM.markssubday, DbType.Int32);
objDB.AddParameters(12, "dayNoPriority", objIFM.daynopriority, DbType.String);
objDB.AddParameters(13, "instituteId", objIFM.instituteid, DbType.Int32);
objDB.AddParameters(14, "entryUser", objIFM.userid, DbType.Int32);
objDB.AddParameters(15, "entrydate", objIFM.entrydate, DbType.DateTime);
objDB.AddParameters(16, "ExamCategoryID", objIFM.examCat, DbType.Int32);
objDB.AddParameters(17, "FacultyID", objIFM.FacultyID, DbType.Int32);
objDB.AddParameters(18, "flag", objIFM.Flag, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Insert_ItestType");
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (objIFM.Flag == "N")
{
retv = "Exam Parameter details submitted successfully..!!.";
}
else if (objIFM.Flag == "U")
{
retv = "Exam Parameter details Updated Successfully.";
}
else
{
retv = "Exam Parameter details deleted Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save Exam Parameter details :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertExamForm(EntranceDM.ExamForm objEFM, List <EntranceDM.ExamChild> objEFMC, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
objDB.CreateParameters(10);
objDB.AddParameters(0, "ES_ID", objEFM.ES_ID, DbType.Int32);
objDB.AddParameters(1, "ExamSchdule", objEFM.ExamSchdule, DbType.String);
objDB.AddParameters(2, "ExamID", objEFM.ExamID, DbType.Int32);
objDB.AddParameters(3, "examdate", objEFM.examdate, DbType.DateTime);
objDB.AddParameters(4, "examtimefrom", objEFM.examtimefrom, DbType.String);
objDB.AddParameters(5, "examtimeto", objEFM.examtimeto, DbType.String);
objDB.AddParameters(6, "ExamYear", objEFM.ExamYear, DbType.String);
objDB.AddParameters(7, "Status", objEFM.Status, DbType.Int32);
objDB.AddParameters(8, "Flag", objEFM.Flag, DbType.String);
objDB.AddParameters(9, "ES_IDReturn", "0", DbType.String, ParameterDirection.Output);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "ExamForm_insert");
Int32 ESID = 0;
if (objEFM.Flag == "U")
{
ESID = objEFM.ES_ID;
}
else
{
ESID = Int32.Parse(objDB.Parameters[9].Value.ToString());
}
foreach (EntranceDM.ExamChild std in objEFMC)
{
objDB.CreateParameters(5);
objDB.AddParameters(0, "ES_ID", ESID, DbType.Int32);
objDB.AddParameters(1, "ExamID", std.ExamID, DbType.Int32);
objDB.AddParameters(2, "subID", std.subID, DbType.Int32);
objDB.AddParameters(3, "examdate", std.examdate, DbType.DateTime);
objDB.AddParameters(4, "Flag", std.Flag, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "ExamChild_insert");
}
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (objEFM.Flag == "N")
{
retv = "Record saved.";
}
else if (objEFM.Flag == "U")
{
retv = "Record Updated Successfully.";
}
else
{
retv = "Record deleted Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertSeatingForm(EntranceDM.EntranceSeat objESM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
objDB.CreateParameters(14);
objDB.AddParameters(0, "ID", objESM.ID, DbType.Int32);
objDB.AddParameters(1, "Examname", objESM.Examname, DbType.Int32);
objDB.AddParameters(2, "Examvenue", objESM.Examvenue, DbType.String);
objDB.AddParameters(3, "Venuestr", objESM.Venuestr, DbType.String);
objDB.AddParameters(4, "Roomno", objESM.Roomno, DbType.String);
objDB.AddParameters(5, "Roomstr", objESM.Roomstr, DbType.String);
objDB.AddParameters(6, "Rowsno", objESM.Rowsno, DbType.String);
objDB.AddParameters(7, "ColumnNo", objESM.ColumnNo, DbType.String);
objDB.AddParameters(8, "Date", objESM.Date, DbType.DateTime);
objDB.AddParameters(9, "Timefrom", objESM.Timefrom, DbType.String);
objDB.AddParameters(10, "Timeto", objESM.Timeto, DbType.String);
objDB.AddParameters(11, "seatcode", objESM.seatcode, DbType.String);
objDB.AddParameters(12, "ExamYear", objESM.ExamYear, DbType.String);
objDB.AddParameters(13, "Flag", objESM.Flag, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "EntranceSeat_insert");
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (objESM.Flag == "N")
{
retv = "Record saved.";
}
else if (objESM.Flag == "U")
{
retv = "Record Updated Successfully.";
}
else
{
retv = "Record deleted Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertInternalMarks(List <ExamDM.FillInternalMarksDM> objADM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
foreach (ExamDM.FillInternalMarksDM BDM in objADM)
{
objDB.CreateParameters(17);
objDB.AddParameters(0, "marksId", BDM.marksId, DbType.Int32);
objDB.AddParameters(1, "testtypeid", BDM.testtypeid, DbType.Int32);
objDB.AddParameters(2, "testid", BDM.testid, DbType.Int32);
objDB.AddParameters(3, "sessionId", BDM.sessionid, DbType.String);
objDB.AddParameters(4, "courseid", BDM.courseid, DbType.Int32);
objDB.AddParameters(5, "SplId", BDM.specid, DbType.Int32);
objDB.AddParameters(6, "semId", BDM.semid, DbType.Int32);
objDB.AddParameters(7, "subjectId", BDM.Subjectid, DbType.Int32);
objDB.AddParameters(8, "StudentID", BDM.StudentID, DbType.Int32);
objDB.AddParameters(9, "marksObtained", BDM.marksObtained, DbType.Decimal);
objDB.AddParameters(10, "Batch_ID", BDM.Batchid, DbType.Int32);
objDB.AddParameters(11, "Facultyid", BDM.Facultyid, DbType.Int32);
objDB.AddParameters(12, "userid", BDM.userid, DbType.Int32);
objDB.AddParameters(13, "Status", BDM.Status, DbType.String);
objDB.AddParameters(14, "EntryDate", BDM.EntryDate, DbType.DateTime);
objDB.AddParameters(15, "Flag", BDM.Flag, DbType.String);
objDB.AddParameters(16, "attendance", BDM.attendance, DbType.String);
f = BDM.Flag;
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "InsertInternalMarks");
}
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (f == "N")
{
retv = "Record saved sucessfully.....";
}
else
{
retv = "Record updated sucessfully.....";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertOnlineForm(EntranceDM.OnlineForm objONFM, List <EntranceDM.Online_Q> objONQF, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string f = "";
try
{
objDB.CreateParameters(18);
objDB.AddParameters(0, "onlineID", objONFM.onlineID, DbType.Int32);
objDB.AddParameters(1, "appearexam", objONFM.appearexam, DbType.Int32);
objDB.AddParameters(2, "examdate", objONFM.examdate, DbType.DateTime);
objDB.AddParameters(3, "firstname", objONFM.firstname, DbType.String);
objDB.AddParameters(4, "middlename", objONFM.middlename, DbType.String);
objDB.AddParameters(5, "lastname", objONFM.lastname, DbType.String);
objDB.AddParameters(6, "dateofbirth", objONFM.dateofbirth, DbType.DateTime);
objDB.AddParameters(7, "fathername", objONFM.fathername, DbType.String);
objDB.AddParameters(8, "cantactaddress", objONFM.cantactaddress, DbType.String);
objDB.AddParameters(9, "city", objONFM.city, DbType.Int32);
objDB.AddParameters(10, "phoneno", objONFM.phoneno, DbType.String);
objDB.AddParameters(11, "mobileno", objONFM.mobileno, DbType.String);
objDB.AddParameters(12, "email", objONFM.email, DbType.String);
objDB.AddParameters(13, "BankName", objONFM.BankName, DbType.Int32);
objDB.AddParameters(14, "chequeordraftno", objONFM.chequeordraftno, DbType.String);
objDB.AddParameters(15, "date", objONFM.date, DbType.DateTime);
objDB.AddParameters(16, "amount", objONFM.amount, DbType.String);
objDB.AddParameters(17, "onlineIDreturn", "0", DbType.String, ParameterDirection.Output);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "OnlineForm_insert");
Int32 onID = 0;
onID = Int32.Parse(objDB.Parameters[17].Value.ToString());
foreach (EntranceDM.Online_Q std in objONQF)
{
objDB.CreateParameters(6);
objDB.AddParameters(0, "onlineID", onID, DbType.Int32);
objDB.AddParameters(1, "QID", std.ProfId, DbType.Int32);
objDB.AddParameters(2, "TM", std.TM, DbType.Int32);
objDB.AddParameters(3, "MO", std.MO, DbType.Int32);
objDB.AddParameters(4, "DIV", std.DIV, DbType.String);
objDB.AddParameters(5, "PER", std.PER, DbType.String);
//objDB.AddParameters(7, "flag", std.flag, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Online_Q_insert");
}
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", "N", DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
retv = "Record saved.";
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertPeriodTempChild(List <TimeTableDM.PeriodtempchildDM> objDMC, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDBC = new DBManager();
objDBC.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDBC.DBManager(DataAccessLayer.DataProvider.SqlServer, objDBC.ConnectionString);
objDBC.Open();
objDBC.BeginTransaction();
string retv = "";
string f = "";
try
{
foreach (TimeTableDM.PeriodtempchildDM std in objDMC)
{
objDBC.CreateParameters(10);
objDBC.AddParameters(0, "flag", std.Flag, DbType.String);
objDBC.AddParameters(1, "Inst_Id", std.Inst_ID, DbType.Int32);
objDBC.AddParameters(2, "Session", std.Session, DbType.String);
objDBC.AddParameters(3, "TemplateID", std.TemplateID, DbType.Int32);
objDBC.AddParameters(4, "ID", std.ID, DbType.Int32);
objDBC.AddParameters(5, "Day", std.Day, DbType.String);
objDBC.AddParameters(6, "Date", std.Date, DbType.DateTime);
objDBC.AddParameters(7, "WeekID", std.WeekID, DbType.Int32);
objDBC.AddParameters(8, "Courseid", std.Courseid, DbType.Int32);
objDBC.AddParameters(9, "Semester", std.Semester, DbType.Int32);
f = std.Flag;
objDBC.ExecuteNonQuery(CommandType.StoredProcedure, "PeriodTempChild_Insert");
}
objDBC.CreateParameters(9);
objDBC.AddParameters(0, "ID", 0, DbType.Int32);
objDBC.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDBC.AddParameters(2, "Action", audit.Action, DbType.String);
objDBC.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDBC.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDBC.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDBC.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDBC.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDBC.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDBC.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDBC.Transaction.Commit();
if (f == "N")
{
retv = "Record saved.";
}
else if (f == "U")
{
retv = "Record Updated Successfully.";
}
else
{
retv = "Record deleted Successfully.";
}
}
catch (Exception ex)
{
objDBC.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDBC.Connection.Close();
objDBC.Dispose();
}
return(retv);
}
public string InsertHoliday(TimeTableDM.HolidayDM objTDM, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.BeginTransaction();
string retv = "";
string flag = "";
try
{
TimeSpan ts = Convert.ToDateTime(objTDM.ToDate) - Convert.ToDateTime(objTDM.Date);
int diffindays = ts.Days + 1;
if (diffindays > 0)
{
System.Array smid = objTDM.SemesterID.Split(',');
System.Array specid = objTDM.specID.Split(',');
for (int i = 0; i < smid.Length; i++)
{
for (int s = 0; s < specid.Length; s++)
{
DateTime dt = objTDM.Date;
for (int k = 1; k <= diffindays; k++)
{
objDB.CreateParameters(17);
//LeaveName,Day,Month,Year,Date,Type,Description,instituteID,sessionID,YearID,SemesterID,Aflag
objDB.AddParameters(0, "LeaveID", objTDM.LeaveID, DbType.Int32);
objDB.AddParameters(1, "LeaveName", objTDM.LeaveName, DbType.String);
//objDB.AddParameters(2, "Day", objTDM.Day, DbType.String);
//objDB.AddParameters(3, "Month", objTDM.Month, DbType.String);
//objDB.AddParameters(4, "Year", objTDM.Year, DbType.String);
objDB.AddParameters(2, "Day", Convert.ToDateTime(dt).Day.ToString(), DbType.String);
objDB.AddParameters(3, "Month", Convert.ToDateTime(dt).Month.ToString(), DbType.String);
objDB.AddParameters(4, "Year", Convert.ToDateTime(dt).Year.ToString(), DbType.String);
objDB.AddParameters(5, "Date", dt, DbType.DateTime);
objDB.AddParameters(6, "Type", objTDM.Type, DbType.String);
objDB.AddParameters(7, "Description", objTDM.Description, DbType.String);
objDB.AddParameters(8, "instituteID", objTDM.instituteID, DbType.Int32);
objDB.AddParameters(9, "sessionID", objTDM.sessionID, DbType.String);
objDB.AddParameters(10, "YearID", smid.GetValue(i).ToString(), DbType.String);
objDB.AddParameters(11, "SemesterID", Int32.Parse(smid.GetValue(i).ToString()), DbType.Int32);
objDB.AddParameters(12, "Aflag", objTDM.Aflag, DbType.String);
objDB.AddParameters(13, "flag", objTDM.Flag, DbType.Int32);
//objDB.AddParameters(14, "DayName", objTDM.DayName, DbType.String);
objDB.AddParameters(14, "DayName", Convert.ToDateTime(dt).ToString("ddd"), DbType.String);
objDB.AddParameters(15, "courseID", objTDM.courseID, DbType.Int32);
objDB.AddParameters(16, "specID", Int32.Parse(specid.GetValue(s).ToString()), DbType.Int32);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Holiday_Insert");
dt = dt.AddDays(1);
}//888
}
}
}
else
{
System.Array smid = objTDM.SemesterID.Split(',');
for (int i = 0; i < smid.Length; i++)
{
objDB.CreateParameters(17);
//LeaveName,Day,Month,Year,Date,Type,Description,instituteID,sessionID,YearID,SemesterID,Aflag
objDB.AddParameters(0, "LeaveID", objTDM.LeaveID, DbType.Int32);
objDB.AddParameters(1, "LeaveName", objTDM.LeaveName, DbType.String);
//objDB.AddParameters(2, "Day", objTDM.Day, DbType.String);
//objDB.AddParameters(3, "Month", objTDM.Month, DbType.String);
//objDB.AddParameters(4, "Year", objTDM.Year, DbType.String);
objDB.AddParameters(2, "Day", Convert.ToDateTime(objTDM.Date).Day.ToString(), DbType.String);
objDB.AddParameters(3, "Month", Convert.ToDateTime(objTDM.Date).Month.ToString(), DbType.String);
objDB.AddParameters(4, "Year", Convert.ToDateTime(objTDM.Date).Year.ToString(), DbType.String);
objDB.AddParameters(5, "Date", objTDM.Date, DbType.DateTime);
objDB.AddParameters(6, "Type", objTDM.Type, DbType.String);
objDB.AddParameters(7, "Description", objTDM.Description, DbType.String);
objDB.AddParameters(8, "instituteID", objTDM.instituteID, DbType.Int32);
objDB.AddParameters(9, "sessionID", objTDM.sessionID, DbType.String);
objDB.AddParameters(10, "YearID", smid.GetValue(i).ToString(), DbType.String);
objDB.AddParameters(11, "SemesterID", Int32.Parse(smid.GetValue(i).ToString()), DbType.Int32);
objDB.AddParameters(12, "Aflag", objTDM.Aflag, DbType.String);
objDB.AddParameters(13, "flag", objTDM.Flag, DbType.Int32);
//objDB.AddParameters(14, "DayName", objTDM.DayName, DbType.String);
objDB.AddParameters(14, "DayName", Convert.ToDateTime(objTDM.Date).ToString("ddd"), DbType.String);
objDB.AddParameters(15, "courseID", objTDM.courseID, DbType.Int32);
objDB.AddParameters(16, "specID", objTDM.specID, DbType.Int32);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Holiday_Insert");
}
}
objDB.CreateParameters(9);
objDB.AddParameters(0, "ID", 0, DbType.Int32);
objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDB.AddParameters(2, "Action", audit.Action, DbType.String);
objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDB.Transaction.Commit();
if (objTDM.Flag == 1)
{
retv = "Record saved.";
}
else if (objTDM.Flag == 2)
{
retv = "Record Updated Successfully.";
}
else
{
retv = "Record deleted Successfully.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDB.Connection.Close();
objDB.Dispose();
}
return(retv);
}
public string InsertPeriods(List <TimeTableDM.PeriodsDM> objDMC, Admin.AdministratorData.AuditDM audit)
{
NewDAL.DBManager objDBC = new DBManager();
objDBC.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDBC.DBManager(DataAccessLayer.DataProvider.SqlServer, objDBC.ConnectionString);
objDBC.Open();
objDBC.BeginTransaction();
string retv = "";
string f = "";
try
{
foreach (TimeTableDM.PeriodsDM std in objDMC)
{
objDBC.CreateParameters(24);
objDBC.AddParameters(0, "PeriodID", std.PeriodID, DbType.Int32);
objDBC.AddParameters(1, "WeekID", std.WeekID, DbType.Int32);
objDBC.AddParameters(2, "CourseID", std.CourseID, DbType.Int32);
objDBC.AddParameters(3, "SubjectID", std.SubjectID, DbType.Int32);
objDBC.AddParameters(4, "TopicID", std.TopicID, DbType.Int32);
objDBC.AddParameters(5, "SubTopicID", std.SubTopicID, DbType.Int32);
objDBC.AddParameters(6, "FacultyID", std.FacultyID, DbType.Int32);
objDBC.AddParameters(7, "Semester", std.Semester, DbType.Int32);
objDBC.AddParameters(8, "Hour", std.Hour, DbType.Int32);
objDBC.AddParameters(9, "PeriodTime", std.PeriodTime, DbType.String);
objDBC.AddParameters(10, "PeriodDate", std.PeriodDate, DbType.DateTime);
objDBC.AddParameters(11, "PeriodType", std.PeriodType, DbType.String);
objDBC.AddParameters(12, "Batch", std.Batch, DbType.String);
objDBC.AddParameters(13, "Suspend", std.Suspend, DbType.String);
objDBC.AddParameters(14, "SuspendReason", std.SuspendReason, DbType.String);
objDBC.AddParameters(15, "InstituteID ", std.InstituteID, DbType.Int32);
objDBC.AddParameters(16, "SessionID", std.SessionID, DbType.String);
objDBC.AddParameters(17, "UName", std.UName, DbType.String);
objDBC.AddParameters(18, "UEntDt", std.UEntDt, DbType.DateTime);
objDBC.AddParameters(19, "venue", std.venue, DbType.Int32);
objDBC.AddParameters(20, "Day", std.Day, DbType.String);
objDBC.AddParameters(21, "PeriodName", std.PeriodName, DbType.String);
objDBC.AddParameters(22, "Flag", std.Flag, DbType.Int32);
objDBC.AddParameters(23, "EnteredFrom", std.EnteredFrom, DbType.Int32);
objDBC.ExecuteNonQuery(CommandType.StoredProcedure, "Periods_Insert");
}
objDBC.CreateParameters(9);
objDBC.AddParameters(0, "ID", 0, DbType.Int32);
objDBC.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String);
objDBC.AddParameters(2, "Action", audit.Action, DbType.String);
objDBC.AddParameters(3, "User_ID", audit.User_ID, DbType.String);
objDBC.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String);
objDBC.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String);
objDBC.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String);
objDBC.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32);
objDBC.AddParameters(8, "SessionID", audit.SessionID, DbType.String);
objDBC.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert");
objDBC.Transaction.Commit();
retv = "Record Inserted Successfully.";
}
catch (Exception ex)
{
objDBC.Transaction.Rollback();
retv = "Unable to save record :-" + ex.Message.ToString();
}
finally
{
objDBC.Connection.Close();
objDBC.Dispose();
}
return(retv);
}
