public void getcourses()
{
var services = new DAL.DAL();
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string studentid = Session["CurrentStudent"].ToString();
DataTable dt = services.GetCoursesbyStudentId(studentid, connstr.Conn_string, iYear, iSem);
if (dt.Rows.Count > 0)
{
RepterDetails.DataSource = dt;
RepterDetails.DataBind();
//drp_Course.DataSource = dt;
//drp_Course.DataTextField = "Course";
//drp_Course.DataValueField = "Code";
//drp_Course.DataBind();
//drp_Course.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Course---", "---Select a Course---"));
}
//else
//{
// drp_Course.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Course---", "---Select a Course---"));
//}
}
private void GetCompany()
{
try
{
Hashtable ht = new Hashtable();
ht.Add("OCode", Session["OCode"]);
DataTable dt = objCmp_BL.GetCompanyList(ht);
if (dt.Rows.Count > 0)
{
RepterDetails.DataSource = dt;
RepterDetails.DataBind();
}
else
{
mpeAjax.Show();
//HttpContext.Current.Response.Redirect("..\\UI_Setup\\ProjectSetup.aspx?action=new");
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message.ToString();
lblMessage.ForeColor = Color.Maroon;
}
}
//buttons
private void cargar_asientoContable()
{
try
{
string sql = "select from registro_contable;";
MySqlConnection conn = new MySqlConnection(connStr);
conn.Open();
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
DataTable tab = new DataTable();
tab.Columns.Add("codigo", typeof(string));
tab.Columns.Add("cuentas", typeof(string));
tab.Columns.Add("glosa", typeof(string));
tab.Columns.Add("debe", typeof(string));
tab.Columns.Add("haber", typeof(string));
while (rdr.Read())
{
tab.Rows.Add(rdr[2], rdr[2], rdr[3], rdr[4], rdr[5]);
}
rdr.Close();
RepterDetails.DataSource = tab;
RepterDetails.DataBind();
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + (ex.Message) + "');", true);
}
}
/// <summary>
/// This method will get all the users and bind it to repeater
/// </summary>
/// <param name="pageIndex"></param>
private void BindUsers(int pageIndex)
{
List <AllocateProduct> lstAllocatedProd = new List <AllocateProduct>();
string customTableClassName = "KDA.UserAllocatedProducts";
var users = UserInfoProvider.GetUsers().Columns("Email", "UserID", "FullName").OnSite(CurrentSite.SiteID).OrderBy("FullName")
.Skip(PageSize * (pageIndex - 1))
.Take(PageSize);
foreach (UserInfo user in users)
{
AllocateProduct objProduct = new AllocateProduct();
objProduct.EmailID = user.Email;
objProduct.UserID = user.UserID;
objProduct.UserName = user.FullName;
objProduct.Quantity = CustomTableItemProvider.GetItems(customTableClassName)
.WhereEquals("ProductID", productId).WhereEquals("UserID", user.UserID).FirstOrDefault()?.GetValue("Quantity", default(int)) ?? 0;
if (lstUsers.FindIndex(item => item.UserID == user.UserID) > -1)
{
objProduct.Selected = true;
}
lstAllocatedProd.Add(objProduct);
}
RepterDetails.DataSource = lstAllocatedProd;
RepterDetails.DataBind();
PopulatePager(UserInfoProvider.GetUsers().OnSite(CurrentSite.SiteID).Count(), pageIndex);
}
protected void BindGridview()
{
DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
SqlCommand cmd = new SqlCommand(@"
select PostPk as PostID,u.Username,Datename(dw,c.CreatedtDate) +', '+ convert(varchar(20),
c.CreatedtDate,113) as PostDateTime ,
PostTitle ,PostDescription,
(select count(*) from tblCommentDescription where c.isactive=1) as CommentsCOunt
from tblPostDetails c LEFT JOIN tblRegistration u on U.UserID = c.UserFK
where c.isactive=1 order by CreatedtDate desc", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
con.Close();
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
RepterDetails.DataSource = ds.Tables[0];
RepterDetails.DataBind();
}
}
}
protected void ejemplo_btnGuardar_Click(object sender, EventArgs e)
{
//try
//{
// if (!RepterDetails == 0)
// RepterDetails.Rows.Remove(RepterDetails.Rows(RepterDetails.RowCount - 1));
// int in1 = ComboBox6.Text.IndexOf("[") + 1;
// int in2 = ComboBox6.Text.IndexOf("]");
// DataGridView1.Rows.Add(ComboBox6.Text.Substring(in1, in2 - in1), ComboBox6.Text.Substring(0, in1 - 1), RichTextBox1.Text, double.Parse(cambiarpc(TextBox4.Text)), double.Parse(cambiarpc(TextBox5.Text)), "---");
// sumatoria();
// ac_comboCuentas.Text = "Seleccione";
// ac_debe.Text = "0";
// ac_haber.Text = "0";
//}
//catch (Exception ex)
//{
// MsgBox("Seleccione un elemento valido", MsgBoxStyle.Exclamation);
//}
ejemplo = (DataTable)(Session["Tabla"]);
ejemplo.Rows.Add(ac_codigo.Text, ac_comboCuentas.Text, ac_glosa.Text, ac_debe.Text, ac_haber.Text);
RepterDetails.DataSource = ejemplo;
RepterDetails.DataBind();
}
public void getstudentservices()
{
var services = new DAL.DAL();
DataTable dtStudentServices = services.GetStudentServices();
RepterDetails.DataSource = dtStudentServices;
RepterDetails.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
double lasRes = Convert.ToDouble(Request.QueryString["Result"]);
lasRes = Math.Round(lasRes);
if (Request.QueryString["msg"] == "add")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertMessege", "alert('Your Feedback is Submited Successfully & Your Trust Score of Product=" + lasRes + "')", true);
}
else if (Request.QueryString["msg"] == "notadd")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertMessege", "alert('Your Feedback is Not Submited & Your Trust Score is =" + GlobalValue._UserTrustDegree + "')", true);
}
else if (Request.QueryString["msg"] == "notbuy")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertMessege", "alert('you cant submit review of this product')", true);
}
else if (Request.QueryString["msg"] == "AlreadySubmit")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertMessege", "alert('you had already submited the review of this product')", true);
}
P_id = Convert.ToInt32(Request.QueryString["P_id"].ToString());
SqlDataAdapter da = new SqlDataAdapter(new SqlCommand("select * from Product where P_id=@P_id", DBConnection.objConn));
da.SelectCommand.Parameters.Add("@P_id", SqlDbType.Int, 10).Value = P_id;
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
Image1.ImageUrl = dt.Rows[0]["photo"].ToString();
PName = dt.Rows[0]["ProductName"].ToString();
Price = dt.Rows[0]["Price"].ToString();
}
SqlDataAdapter da1 = new SqlDataAdapter(new SqlCommand("select (First_name+' '+Last_name)as Name,Email from Muser where User_id=@User_id", DBConnection.objConn));
da1.SelectCommand.Parameters.AddWithValue("@User_id", Session["User_id"].ToString());
DataTable dt1 = new DataTable();
da1.Fill(dt1);
if (dt1.Rows.Count > 0)
{
txtName.Text = dt1.Rows[0]["Name"].ToString();
txtEmail.Text = dt1.Rows[0]["Email"].ToString();
}
SqlDataAdapter da2 = new SqlDataAdapter(new SqlCommand("select top(5) f.*,(u.First_name+' '+u.Last_name)as Name from Feedback f join Muser u on(f.User_id=u.User_id)where f.P_id=@p_id order by f_id desc", DBConnection.objConn));
da2.SelectCommand.Parameters.AddWithValue("@P_id", P_id);
DataTable dt3 = new DataTable();
da2.Fill(dt3);
RepterDetails.DataSource = dt3;
RepterDetails.DataBind();
}
//SqlDataAdapter da1 = new SqlDataAdapter(new SqlCommand("select * from TempData", DBConnection.objConn));
//DataTable dt1 = new DataTable();
//da1.Fill(dt1);
//TextBox3.Text = dt1.Rows[0]["Feedback"].ToString();
}
protected void Last8DaysSales()
{
DataTable dt = new DataTable();
dt = CommonClasses.Execute("select ROW_NUMBER() OVER (ORDER BY INM_DATE) AS RowNum,Cast(INM_DATE as date) as INM_DATE,FORMAT(SUM(INM_G_AMT),'C', 'en-IN') AS GrandAmt from INVOICE_MASTER where INM_TYPE='TAXINV' and ES_DELETE=0 and INM_DATE between DATEADD(DAY, -10, getdate()) and GETDATE() group by INM_DATE");
DataSet ds = new DataSet();
ds.Tables.Add(dt);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
}
public void RepeterData()
{
con.Open();
cmd = new SqlCommand("Select * from Comment Order By Post_Date desc", con);
DataSet ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
con.Open();
cmd = new SqlCommand("Select top " + DropDownList1.SelectedItem.Text + "* from [Products T] order by date desc", con);
DataSet ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
con.Close();
}
public void RepeterData()
{
con.Open();
cmd = new SqlCommand("Select top 15 * from [Products T] order by date desc", con);
DataSet ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
con.Close();
}
public void RepeterData()
{
con.Open();
cmd = new SqlCommand("select * from tbstory s , tbimages m where s.storyid = m.storyid and m.defaultValue='Yes' and m.imageType ='After'", con);
DataSet ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Brandcheckboxlist();
Catagorycheckboxlist();
try
{
catagory = Session["catagory"].ToString();
}
catch (Exception)
{
}
try
{
brand = Session["Brand"].ToString();
}
catch (Exception)
{
}
if (catagory != "")
{
con.Open();
cmd = new SqlCommand("Select * from [Products T] where Catagory='" + Session["catagory"].ToString() + "'order by date desc", con);
DataSet ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
con.Close();
}
if (brand != "")
{
con.Open();
cmd = new SqlCommand("Select * from [Products T] where Brand='" + Session["Brand"].ToString() + "'order by date desc", con);
DataSet ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
con.Close();
}
if (brand == "" && catagory == "")
{
RepeterData();
}
}
}
protected void CheckBoxList2_SelectedIndexChanged(object sender, EventArgs e)
{
con.Open();
cmd = new SqlCommand("Select * from [Products T] where Catagory='" + CheckBoxList2.SelectedItem.Text + "'order by date desc", con);
DataSet ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
con.Close();
CheckBoxList2.SelectedItem.Selected = false;
}
public void LessItmData()
{
con.Open();
SqlCommand cmd = new SqlCommand(" select tbl_Dstk.ProductID,ProductName,Dstk_Qty from tbl_Mstk inner join tbl_Dstk on tbl_Mstk.Mstk_id = tbl_Dstk.Mstk_id inner join Products on tbl_Dstk.ProductID = Products.ProductID where Dstk_Qty < 5 and tbl_Mstk.CompanyId='" + Session["CompanyID"] + "' and tbl_Mstk.BranchId='" + Session["BranchID"] + "'", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
con.Close();
}
private void BindGraph()
{
try
{
string strSql = "SELECT * FROM smartcontracts order by sno desc;SELECT sum(notionalvalue) as totalnotionalvalue FROM smartcontracts order by sno desc;";
DataSet ds = MySQLHelper.ExecuteDataset(connectionString, strSql);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
lblNoofContracts.Text = ds.Tables[0].Rows.Count.ToString();
lblTotalNotionalValue.Text = Convert.ToDouble(ds.Tables[1].Rows[0]["totalnotionalvalue"]).ToString("#,###.##");// + " (" + (Convert.ToDouble(ds.Tables[1].Rows[0]["totalnotionalvalue"]) / 1000000.00).ToString("#.##") + " m)";
}
catch (Exception ex)
{
}
}
public void BindData()
{
SqlConnection con = new SqlConnection(@"server=192.168.1.40;uid=DEMOUSER;pwd=demo1234;database=DEMODB;");
SqlCommand cmd = new SqlCommand("select * from Employee", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
DataList1.DataSource = ds;
DataList1.DataBind();
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
}
public void RepeterData()
{
var strConnString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (SqlConnection conn = new SqlConnection(strConnString))
{
conn.Open();
var sqlSyntax = "SELECT CAST(Accounts.AccountNumber AS VARCHAR(50)) as ACC,AccountTypes.AccountName as Atype, Customers.FirstName +' '+ Customers.LastName as fullname, Accounts.Balance as balance FROM AccountTypes INNER JOIN Accounts ON AccountTypes.AccountTID = Accounts.AccountType_AccountTID INNER JOIN Customers ON Accounts.CustomerCustomerID = Customers.CustomerID";
sqlCommand = new SqlCommand(sqlSyntax, conn);
DataSet data = new DataSet();
dataAdapter = new SqlDataAdapter(sqlCommand);
dataAdapter.Fill(data);
RepterDetails.DataSource = data;
RepterDetails.DataBind();
}
}
public void RepeterData()
{
con.Open();
cmd = new SqlCommand("Select * from tbcategory order by rank asc", con);
DataSet ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
con.Close();
}
public void RepeterData()
{
var strConnString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (SqlConnection conn = new SqlConnection(strConnString))
{
conn.Open();
var sqlSyntax = "Select Customers.FirstName +' '+ Customers.LastName as fullname, Accounts.AccountNumber as accnum, Transactions.Amount as amount, Transactions.Details as details, Transactions.Date as date FROM Transactions INNER JOIN Accounts ON Transactions.AccountAccountNumber = Accounts.AccountNumber INNER JOIN Customers ON Accounts.CustomerCustomerID = Customers.CustomerID";
sqlCommand = new SqlCommand(sqlSyntax, conn);
DataSet data = new DataSet();
dataAdapter = new SqlDataAdapter(sqlCommand);
dataAdapter.Fill(data);
RepterDetails.DataSource = data;
RepterDetails.DataBind();
}
}
protected void Last8DaysSales()
{
DataTable dt = new DataTable();
dt = CommonClasses.Execute("declare @sumvalue table (RowNum int identity(1,1),INM_DATE varchar(500),GrandAmt nvarchar(1000),Total nvarchar(1000),GrandAmtwithoutformat float,Totalsaletilldate nvarchar(1000))insert into @sumvalue select CONVERT(varchar, Cast(INM_DATE as date), 103) as INM_DATE ,FORMAT(SUM(INM_G_AMT),'C', 'en-IN') AS GrandAmt,0,SUM(INM_G_AMT),(select FORMAT(SUM(INM_G_AMT),'C', 'en-IN') from INVOICE_MASTER where INM_CM_CODE in (select top 1 CM_CODE from COMPANY_MASTER order by CM_CODE desc)) from INVOICE_MASTER where INM_TYPE='TAXINV' and ES_DELETE=0 and INM_DATE between DATEADD(DAY, -9, getdate()) and GETDATE() group by INM_DATE order by INM_DATE desc declare @Totalvalue float select @Totalvalue=sum(GrandAmtwithoutformat) from @sumvalue update @sumvalue set total= FORMAT(@Totalvalue,'C', 'en-IN') select * from @sumvalue");
DataSet ds = new DataSet();
ds.Tables.Add(dt);
if (dt.Rows.Count > 0)
{
lbltotal8dayssale.Text = dt.Rows[0]["Total"].ToString();
lbltilldateSale.Text = dt.Rows[0]["Totalsaletilldate"].ToString();
}
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
}
public void RepeterData()
{
SqlConnection con = new SqlConnection(connectionString);
Console.WriteLine("the connection is", con);
con.Open();
cmd = new SqlCommand("Select * from tbcategory order by rank asc", con);
DataSet ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
con.Close();
}
protected void BindGridview()
{
DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
SqlCommand cmd = new SqlCommand(@"select * from tblQuestionMaster where isActive=1", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
con.Close();
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
RepterDetails.DataSource = ds.Tables[0];
RepterDetails.DataBind();
}
}
}
protected void btn_Search_Click(object sender, EventArgs e)
{
String constr = ConfigurationManager.ConnectionStrings["ECTDataNew"].ConnectionString;
SqlConnection sc = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("SELECT * FROM ECT_Doc_Reference WHERE sReference = @sReference", sc);
cmd.Parameters.AddWithValue("@sReference", txt_Search.Text.Trim());
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
sc.Open();
da.Fill(dt);
sc.Close();
if (dt.Rows.Count > 0)
{
lbl_Msg.Visible = false;
Results.Visible = true;
RepterDetails.DataSource = dt;
RepterDetails.DataBind();
}
else
{
lbl_Msg.Visible = true;
Results.Visible = false;
}
}
catch (Exception ex)
{
sc.Close();
//throw ex;
lbl_Msg.Text = ex.Message;
}
finally
{
sc.Close();
}
}
public void RepeterData()
{
ApplicationDbContext context = new ApplicationDbContext();
var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
ApplicationUser currentUser = UserManager.FindById(User.Identity.GetUserId());
String strConnString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
if (currentUser != null)
{
string id = Convert.ToString(currentUser.Id);
using (SqlConnection conn = new SqlConnection(strConnString))
{
conn.Open();
sqlCommand = new SqlCommand("SELECT Accounts.AccountNumber AS acc, Accounts.Balance as balance, AccountTypes.AccountName as actype, Accounts.CustomerCustomerID FROM Accounts INNER JOIN Customers ON Accounts.CustomerCustomerID = Customers.CustomerID INNER JOIN AccountTypes ON Accounts.AccountType_AccountTID = AccountTypes.AccountTID WHERE(Customers.CustomerID = '" + id + "')", conn);
DataSet ds = new DataSet();
sqlDataAdapter = new SqlDataAdapter(sqlCommand);
sqlDataAdapter.Fill(ds);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
}
}
}
public void RepeterData()
{
SqlDataAdapter da;
string strcon = ConfigurationManager.ConnectionStrings["CARESconnection"].ConnectionString;
SqlConnection con = new SqlConnection(strcon);
con.Open();
SqlCommand cmd = new SqlCommand("Select C.CommentID as CommentID, C.CommentContent as CommentContent, (Select SX.FirstName + ' ' + SX.LastName as StaffName from Staff SX where StaffID = C.StaffID) as StaffName from Comments C " +
" inner join StaffComments SC on SC.CommentID = C.CommentID " +
" inner join Staff S on S.StaffID = SC.StaffID " +
" where S.StaffID = @CommenteeID", con);
//MessageBox.Show("CommenteeID", CommenteeID.ToString());
cmd.Parameters.Add("@CommenteeID", SqlDbType.Int).Value = CommenteeID;
DataSet ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepterDetails.DataSource = ds;
RepterDetails.DataBind();
//MessageBox.Show("CommentsPopulated");
}
protected void Page_Load(object sender, EventArgs e)
{
RepterDetails.DataSource = db.Manufacturers.Select(p => p).Where(p => p.Active.Equals(1));
RepterDetails.DataBind();
}
private DataSet Prepare_TimeTable_Report(List <TimeTable> myTimeTable)
{
DataTable dt = new DataTable();
DataRow dr;
DataSet ds = new DataSet();
try
{
DataColumn dc;
dc = new DataColumn("iSerial", Type.GetType("System.Int32"));
dt.Columns.Add(dc);
dc = new DataColumn("iPeriod", Type.GetType("System.Int32"));
dt.Columns.Add(dc);
dc = new DataColumn("sPeriod", Type.GetType("System.String"));
dt.Columns.Add(dc);
dc = new DataColumn("sCourse", Type.GetType("System.String"));
dt.Columns.Add(dc);
dc = new DataColumn("sDesc", Type.GetType("System.String"));
dt.Columns.Add(dc);
dc = new DataColumn("iClass", Type.GetType("System.Int32"));
dt.Columns.Add(dc);
dc = new DataColumn("dFrom", Type.GetType("System.String"));
dt.Columns.Add(dc);
dc = new DataColumn("dTo", Type.GetType("System.String"));
dt.Columns.Add(dc);
dc = new DataColumn("iLecturer", Type.GetType("System.Int32"));
dt.Columns.Add(dc);
dc = new DataColumn("sLecturer", Type.GetType("System.String"));
dt.Columns.Add(dc);
dc = new DataColumn("iDays", Type.GetType("System.Int32"));
dt.Columns.Add(dc);
dc = new DataColumn("sDay", Type.GetType("System.String"));
dt.Columns.Add(dc);
dc = new DataColumn("sHall", Type.GetType("System.String"));
dt.Columns.Add(dc);
dc = new DataColumn("seBookCode", Type.GetType("System.String"));
dt.Columns.Add(dc);
int Serial = 0;
for (int i = 0; i < myTimeTable.Count; i++)
{
dr = dt.NewRow();
Serial += 1;
dr["iSerial"] = Serial;
dr["sPeriod"] = myTimeTable[i].SPeriod;
dr["sCourse"] = myTimeTable[i].SCourse;
dr["sDesc"] = myTimeTable[i].SDesc;
dr["iClass"] = myTimeTable[i].IClass;
//add Times
dr["sLecturer"] = myTimeTable[i].ClassTimes[0]._sLecturer;
dr["dFrom"] = myTimeTable[i].ClassTimes[0]._dFrom.ToShortTimeString();
dr["dTo"] = myTimeTable[i].ClassTimes[0]._dTo.ToShortTimeString();
dr["iDays"] = myTimeTable[i].ClassTimes[0]._iDays;
dr["sDay"] = myTimeTable[i].ClassTimes[0]._sDays + " " + myTimeTable[i].ClassTimes[0]._sNotes;
dr["sHall"] = myTimeTable[i].ClassTimes[0]._sHall + " | " + myTimeTable[i].ClassTimes[0]._sCampus;
dr["seBookCode"] = myTimeTable[i].ClassTimes[0]._seBookCode;
dt.Rows.Add(dr);
//Collect Additional Times
for (int j = 1; j < myTimeTable[i].ClassTimes.Count; j++)
{
dr = dt.NewRow();
Serial += 1;
dr["iSerial"] = Serial;
dr["sPeriod"] = myTimeTable[i].SPeriod;
dr["sCourse"] = myTimeTable[i].SCourse;
dr["sDesc"] = myTimeTable[i].SDesc;
dr["iClass"] = myTimeTable[i].IClass;
dr["sLecturer"] = myTimeTable[i].ClassTimes[j]._sLecturer;
dr["dFrom"] = myTimeTable[i].ClassTimes[j]._dFrom.ToShortTimeString();
dr["dTo"] = myTimeTable[i].ClassTimes[j]._dTo.ToShortTimeString();
dr["iDays"] = myTimeTable[i].ClassTimes[j]._iDays;
dr["sDay"] = myTimeTable[i].ClassTimes[j]._sDays + " " + myTimeTable[i].ClassTimes[j]._sNotes;
dr["sHall"] = myTimeTable[i].ClassTimes[j]._sHall + " | " + myTimeTable[i].ClassTimes[0]._sCampus;
dt.Rows.Add(dr);
}
}
dt.TableName = "StudentTimeTable";
dt.AcceptChanges();
ds.Tables.Add(dt);
RepterDetails.DataSource = dt;
RepterDetails.DataBind();
}
catch (Exception exp)
{
Console.WriteLine("{0} Exception caught.", exp);
}
finally
{
}
return(ds);
}
private void showBooks(List <Book> myBooks, bool HeaderOnly)
{
try
{
//string sLink = "";
string myTable = "";
//int iStatus = 0;
//myTable += "<thead><tr class='headings'><th>#</th><th>Add?</th><th >Accesstion No</th><th>Title</th><th>Author</th><th >Publisher</th><th >Subject</th><th>Edition</th><th >Published</th><th>Library</th ><th>Status</th></tr></thead>";
if (!HeaderOnly)
{
//string cssClass = "even pointer";
//for (int i = 0; i < myBooks.Count; i++)
//{
// if (i % 2 == 0)
// {
// cssClass = "R_NormalWhite";
// }
// else
// {
// cssClass = "R_NormalGray";
// }
// myTable += "<tr class='" + cssClass + "'>";
// myTable += "<td>" + (i + 1).ToString() + "</td>";
// iStatus = 0;
// if (myBooks[i].Status == "Available")
// {
// iStatus = 1;
// }
// myTable += "<td ><input id='btn" + (i + 1).ToString() + "' type='button' value='Add to basket' onclick='addtobasket(" + myBooks[i].AccNo + "," + iStatus + ");'></input></td>";
// myTable += "<td style='font-size: small'>" + myBooks[i].AccNo + "</td>";
// myTable += "<td style='font-size: small'>" + myBooks[i].Title + "</td>";
// myTable += "<td style='font-size: small'>" + myBooks[i].Author + "</td>";
// myTable += "<td style='font-size: small'>" + myBooks[i].Publisher + "</td>";
// myTable += "<td style='font-size: small'>" + myBooks[i].Subject + "</td>";
// myTable += "<td style='font-size: small'>" + myBooks[i].Edition + "</td>";
// myTable += "<td style='font-size: small'>" + myBooks[i].Published + "</td>";
// myTable += "<td style='font-size: small'>" + myBooks[i].Library + "</td>";
// myTable += "<td style='font-size: small'>" + myBooks[i].Status + "</td>";
// myTable += "</tr>";
//}
//myTable += "</table>";
////Literal1.Text = myTable;
if (myBooks.Count > 0)
{
divResult.Visible = true;
RepterDetails.Visible = true;
RepterDetails.DataSource = myBooks;
RepterDetails.DataBind();
}
else
{
divResult.Visible = true;
RepterDetails.Visible = false;
RepterDetails.DataSource = myBooks;
RepterDetails.DataBind();
}
}
else
{
//myTable = "No Results found...";
//Literal1.Text = myTable;
// divResult.InnerHtml = myTable;
DataTable dt = new DataTable();
RepterDetails.DataSource = dt;
RepterDetails.DataBind();
RepterDetails.Visible = false;
}
//myTable += "</table>";
////Literal1.Text = myTable;
//divResult.InnerHtml = myTable;
}
catch (Exception ex)
{
Console.WriteLine("{0} Exception caught.", ex.Message);
}
finally
{
}
}
