//#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 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 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 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 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 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); }
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 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); }
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 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 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 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 GetDataFromFaculy(string depId) { DBSqlConnection con = new DBSqlConnection(); string sql = @"select * from [dbo].[Departments] where [Dep_ID]='" + depId + "'; "; 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 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); }