//#endregion
public string topsSave(string dateH, string nameH)
{
string save = "";
string upd = @"INSERT INTO [dbo].[Holidaylist]([FullDate],[HolidayName])VALUES('" + dateH + "','" + nameH + "')";
DBSqlConnection con = new DBSqlConnection();
con.getSqlConnection();
try
{
SqlCommand cmd = new SqlCommand(upd, con.getSqlConnection());
cmd.ExecuteNonQuery();
lblMsg.Text = "Data Save Successfully.";
}
catch (Exception r)
{
save = r.Message;
lblMsg.Text = r.Message;
}
finally
{
con.CloseConnection();
}
return(save);
}
private DataTable getDataFromUserType(string usertyp)
{
DBSqlConnection con = new DBSqlConnection();
string query = @"SELECT * FROM [dbo].[UserType] where [UserType] = '" + usertyp + "' ";
DataTable dt = new DataTable();
try
{
SqlDataAdapter da = new SqlDataAdapter(query, con.getSqlConnection());
da.Fill(dt);
if (dt.Rows.Count > 0)
{
txtUtyp.Text = dt.Rows[0]["UserType"].ToString();
}
}
catch (Exception r)
{
r.Message.ToString();
}
finally
{
con.CloseConnection();
}
return(dt);
}
private int GetcTId(int cTIdPossition)
{
DBSqlConnection con3 = new DBSqlConnection();
SqlCommand cmd3 = new SqlCommand();
cmd3.Connection = con3.getSqlConnection();
cmd3.CommandText = @"SELECT * FROM [dbo].[Course_Topic] where Co_ID=" + cCoId + "";
SqlDataAdapter da = new SqlDataAdapter(cmd3);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
int cout = 0;
foreach (DataRow row in dt.Rows)
{
if (cout == cTIdPossition)
{
return(Convert.ToInt32(row.ItemArray[0]));
}
cout++;
}
}
return(0);
}
private void Course(string coId)
{
DBSqlConnection sl = new DBSqlConnection();
string sql = @"select * from [dbo].[Courses] where [Co_ID]= '" + coId + "'";
SqlConnection con = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(sql, con);
con.Open();
command.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(command);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
txtCCode.Text = dt.Rows[0]["Course_Code"].ToString();
txtCHour.Text = dt.Rows[0]["Credit_Hour"].ToString();
//txtCShedule.Text = dt.Rows[0]["SheduleDay"].ToString();
}
else
{
txtCCode.Text = "";
txtCHour.Text = "";
//txtCShedule.Text = "";
}
con.Close();
}
private string cTopicSave(string cTitle, string cTopic, string cId)
{
string save = "";
string upd = @"INSERT INTO [dbo].[Course_Topic]([Title],[Topic],[Co_ID])VALUES('" + cTitle + "','" + cTopic + "','" + cId + "')";
DBSqlConnection con = new DBSqlConnection();
con.getSqlConnection();
try
{
SqlCommand cmd = new SqlCommand(upd, con.getSqlConnection());
cmd.ExecuteNonQuery();
lblMsg.Text = "Data Save Successfully.";
}
catch (Exception r)
{
save = r.Message;
lblMsg.Text = r.Message;
}
finally
{
con.CloseConnection();
}
return(save);
}
private bool CheckAutehntication(string userId)
{
string path = HttpContext.Current.Request.Url.AbsolutePath;
path = path.Substring(1, path.Length - 1);
string sql = @"select a.ID from UPermission a inner join UMenu b on a.Menu_ID=b.ID where b.Menu_Path Like '%" + path + "%' and a.Role_ID =(select Role_ID from Users where ID='" + userId + "')";
DBSqlConnection con = new DBSqlConnection();
int id = 0;
try
{
SqlCommand cmd = new SqlCommand(sql, con.getSqlConnection());
id = (int)cmd.ExecuteScalar();
}
catch (Exception r)
{
id = 0;
r.Message.ToString();
}
if (id > 0)
{
return(true);
}
else
{
return(false);
}
}
private DataTable GetMenuPathFromTable(string mPath)
{
DataTable dt = new DataTable();
string sql = @"SELECT * FROM [dbo].[UMenu] where [Menu_Name] = '" + mPath + "' ";
DBSqlConnection con = new DBSqlConnection();
SqlDataAdapter da = new SqlDataAdapter(sql, con.getSqlConnection());
da.Fill(dt);
return(dt);
}
private DataTable Checktopic(string nameH)
{
DataTable dt = new DataTable();
string sql = @"select * from [dbo].[Holidaylist] where [HolidayName] = '" + nameH + "' ";
DBSqlConnection con = new DBSqlConnection();
SqlDataAdapter da = new SqlDataAdapter(sql, con.getSqlConnection());
da.Fill(dt);
return(dt);
}
private DataTable GetDataFromTable(string fullname)
{
DataTable dt = new DataTable();
string sql = @"SELECT * FROM [dbo].[Users] where [UserName] = '" + fullname + "' ";
DBSqlConnection con = new DBSqlConnection();
SqlDataAdapter da = new SqlDataAdapter(sql, con.getSqlConnection());
da.Fill(dt);
return(dt);
}
private DataTable GetDatFromTbl(string userN, string pass, string type)
{
DataTable dt = new DataTable();
string sql = @"SELECT * FROM [dbo].[Users] WHERE [EmailAddress]='" + userN + "' AND [Password]='" + pass + "' AND [Role_ID]='" + type + "'";
DBSqlConnection con = new DBSqlConnection();
SqlDataAdapter da = new SqlDataAdapter(sql, con.getSqlConnection());
da.Fill(dt);
return(dt);
}
private DataTable GetRoleFromTable(string rType)
{
DataTable dt = new DataTable();
string sql = @"SELECT * FROM [dbo].[UserType] where [UType] = '" + rType + "' ";
DBSqlConnection con = new DBSqlConnection();
SqlDataAdapter da = new SqlDataAdapter(sql, con.getSqlConnection());
da.Fill(dt);
return(dt);
}
public void showAllHoliDay()
{
DBSqlConnection con = new DBSqlConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.getSqlConnection();
cmd.CommandText = "SELECT * FROM [dbo].[Holidaylist] ";
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
holiDayGridView.DataSource = dt;
holiDayGridView.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string course = txtCourse.Text;
DBSqlConnection con = new DBSqlConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.getSqlConnection();
cmd.CommandText = @"select * from [dbo].[Courses] WHERE [Title]='" + course + "' ";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
courseGridView.DataSource = dt;
courseGridView.DataBind();
}
private void triTopicGridViewLoad()
{
DBSqlConnection con = new DBSqlConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.getSqlConnection();
cmd.CommandText = "SELECT * FROM [dbo].[Course_Topic]";
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
topicGridView.DataSource = dt;
topicGridView.DataBind();
}
protected void btnSear_Click(object sender, EventArgs e)
{
string depN = txtSer.Text;
DBSqlConnection con = new DBSqlConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.getSqlConnection();
cmd.CommandText = @"select * from [dbo].[Departments] WHERE [DepName]='" + depN + "'";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
departmentGridView.DataSource = dt;
departmentGridView.DataBind();
}
protected void btnSear_Click(object sender, EventArgs e)
{
string facSName = txtFSear.Text;
DBSqlConnection con = new DBSqlConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.getSqlConnection();
cmd.CommandText = @"select * from [dbo].[Faculties] WHERE [ShortName]='" + facSName + "' ";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
facultyGridView.DataSource = dt;
facultyGridView.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string holiDSear = txtHDaySear.Text;
DBSqlConnection con = new DBSqlConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.getSqlConnection();
cmd.CommandText = "SELECT * FROM [dbo].[Holidaylist] where [HolidayName]= '" + holiDSear + "'";
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
holiDayGridView.DataSource = dt;
holiDayGridView.DataBind();
}
private void LoadMenuItem(string userId)
{
string sql = @"select b.Menu_Path,b.Menu_Name from UPermission a inner join UMenu b on a.Menu_ID=b.ID where a.Role_ID=
(select Role_ID from Users where ID='" + userId + "')";
DataTable dt = new DataTable();
DBSqlConnection con = new DBSqlConnection();
SqlDataAdapter da = new SqlDataAdapter(sql, con.getSqlConnection());
da.Fill(dt);
string html = "";
foreach (DataRow dr in dt.Rows)
{
html += "<li><a runat='server' href='" + dr["Menu_Path"].ToString() + "'>" + dr["Menu_Name"].ToString() + "</a></li>";
}
Literal1.Text = html;
}
private void LoadUsertype()
{
DBSqlConnection con = new DBSqlConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.getSqlConnection();
cmd.CommandText = @"select * from [dbo].[URole] ";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
DDUtype.DataSource = dt;
DDUtype.DataTextField = "Role_Name";
DDUtype.DataValueField = "Id";
DDUtype.DataBind();
DDUtype.SelectedIndex = -1;
DDUtype.Items.Insert(0, new ListItem("--Select User Role--", "--Select User Role--"));
}
private void LoadCoourseTitle()
{
DBSqlConnection con = new DBSqlConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.getSqlConnection();
cmd.CommandText = @"select * from [dbo].[Courses]";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
ddCtitle.DataSource = dt;
ddCtitle.DataTextField = "Title";
ddCtitle.DataValueField = "Co_ID";
ddCtitle.DataBind();
ddCtitle.SelectedIndex = -1;
ddCtitle.Items.Insert(0, new ListItem("--Select Department--", "--Select Department--"));
}
private void LoadFacultyName()
{
DBSqlConnection con = new DBSqlConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.getSqlConnection();
cmd.CommandText = @"select * from [dbo].[Faculties] ";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
DDUName.DataSource = dt;
DDUName.DataTextField = "ShortName";
DDUName.DataValueField = "FId";
DDUName.DataBind();
DDUName.SelectedIndex = -1;
DDUName.Items.Insert(0, new ListItem("--Select Faculties Name--", "--Select Faculties Name--"));
}
private void GetDataFromTableDID()
{
DBSqlConnection con = new DBSqlConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.getSqlConnection();
cmd.CommandText = @"select * from [dbo].[Departments]";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
ddDepID.DataSource = dt;
ddDepID.DataTextField = "DepName";
ddDepID.DataValueField = "Dep_ID";
ddDepID.DataBind();
ddDepID.SelectedIndex = -1;
ddDepID.Items.Insert(0, new ListItem("--Select Department--", "--Select Department--"));
}
private bool GetHoliday(string date)
{
//var datearray = date.Split('/');
//var searchDate = string.Join("/", datearray);
DBSqlConnection con3 = new DBSqlConnection();
SqlCommand cmd3 = new SqlCommand();
cmd3.Connection = con3.getSqlConnection();
cmd3.CommandText = @"SELECT [FullDate] FROM [Holidaylist] where FullDate='" + date + "'";
SqlDataAdapter da = new SqlDataAdapter(cmd3);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
private DataTable GetDataTopDual(string coId)
{
DataTable dtgridtridual = new DataTable();
string sqldual = @"select * from [dbo].[DualSemCourseTopic] where [Co_ID]='" + coId + "' ";
DBSqlConnection con = new DBSqlConnection();
try
{
SqlDataAdapter dagridual = new SqlDataAdapter(sqldual, con.getSqlConnection());
dagridual.Fill(dtgridtridual);
}
catch (Exception r)
{
r.Message.ToString();
dtgridtridual = null;
}
finally
{
con.CloseConnection();
}
return(dtgridtridual);
}
private DataTable GetDataTopTri(string facId)
{
DataTable dtgridtrid = new DataTable();
string sqltri = @"select * from [dbo].[CourseTriTopic] where [FacName]='" + facId + "'";
DBSqlConnection con = new DBSqlConnection();
try
{
SqlDataAdapter dagrid = new SqlDataAdapter(sqltri, con.getSqlConnection());
dagrid.Fill(dtgridtrid);
}
catch (Exception r)
{
r.Message.ToString();
dtgridtrid = null;
}
finally
{
con.CloseConnection();
}
return(dtgridtrid);
}
private DataTable GetDataFromFaculty(string facId)
{
DBSqlConnection con = new DBSqlConnection();
string sql = @"select * from [dbo].[Faculties] where [ShortName]='" + facId + "'";
DataTable dt = new DataTable();
try
{
SqlDataAdapter da = new SqlDataAdapter(sql, con.getSqlConnection());
da.Fill(dt);
}
catch (Exception r)
{
r.Message.ToString();
dt = null;
}
finally
{
con.CloseConnection();
}
return(dt);
}
private DataTable GetDataFromTriTopic(string title)
{
DBSqlConnection con = new DBSqlConnection();
string sql = @"select * from [dbo].[Course_Topic] where [Title]='" + title + "'";
DataTable dt = new DataTable();
try
{
SqlDataAdapter da = new SqlDataAdapter(sql, con.getSqlConnection());
da.Fill(dt);
}
catch (Exception r)
{
r.Message.ToString();
dt = null;
}
finally
{
con.CloseConnection();
}
return(dt);
}
private DataTable dep()
{
string sql3 = @"select * from [dbo].[Departments]";
DBSqlConnection con = new DBSqlConnection();
DataTable dt = new DataTable();
try
{
SqlDataAdapter da = new SqlDataAdapter(sql3, con.getSqlConnection());
da.Fill(dt);
}
catch (Exception r)
{
r.Message.ToString();
dt = null;
}
finally
{
con.CloseConnection();
}
return(dt);
}
private DataTable getDepIdFromD(int depId)
{
DataTable dtgridtridual = new DataTable();
string sqldual = @"SELECT [Topic] FROM [dbo].[Departments] WHERE [Dep_ID] ='" + depId + "' ";
DBSqlConnection con = new DBSqlConnection();
try
{
SqlDataAdapter dagridual = new SqlDataAdapter(sqldual, con.getSqlConnection());
dagridual.Fill(dtgridtridual);
}
catch (Exception r)
{
r.Message.ToString();
dtgridtridual = null;
}
finally
{
con.CloseConnection();
}
return(dtgridtridual);
}
private DataTable GetDataMarksLab()
{
DataTable dtgridtridual = new DataTable();
string sqldual = @"select * from [dbo].[Marks-Lab-Tri] ";
DBSqlConnection con = new DBSqlConnection();
try
{
SqlDataAdapter dagridual = new SqlDataAdapter(sqldual, con.getSqlConnection());
dagridual.Fill(dtgridtridual);
}
catch (Exception r)
{
r.Message.ToString();
dtgridtridual = null;
}
finally
{
con.CloseConnection();
}
return(dtgridtridual);
}
