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); }