protected void Page_Load(object sender, EventArgs e)
{
if (Session["id"] != null)
{
if (Session["id"].Equals("Admin"))
{
historytransactionRepo = new HistoryTrasactionRepository(db);
if (!IsPostBack)
{
BindData();
//gvHistoryTransactionDetails.DataSource = historytransactionRepo.GetAll().ToList();
//gvHistoryTransactionDetails.DataBind();
//ddlbrandid.DataSource = historytransactionRepo.GetAll().ToList();
//ddlbrandid.DataSource=Product;;
//ddlbrandid.DataTextField = "BrandName";
//ddlbrandid.DataValueField = "BrandId";
// ddlbrandid.DataBind();
}
}
else
{
lblMsg.Text = "you don't have permission for this page";
}
}
else
{
Response.Redirect("~/Login/Login.aspx");
}
}
protected void BindData()
{
try
{
historytransactionRepo = new HistoryTrasactionRepository(db);
var data = historytransactionRepo.GetAll().Where(h => h.TenantId == tenantId).ToList();
if (data.Count == 0)
{
data.Add(new Domain.Historytransaction()
{
HistoryTransactionId = 0, ProductId = 0, Count = 0, TotalAmount = 0
});
gvHistoryTransactionDetails.DataSource = data;
gvHistoryTransactionDetails.DataBind();
gvHistoryTransactionDetails.Rows[0].Visible = false;
gvHistoryTransactionDetails.ShowFooter = true;
}
else
{
gvHistoryTransactionDetails.DataSource = data;
gvHistoryTransactionDetails.DataBind();
}
DropDownList ddlAddProduct = (DropDownList)gvHistoryTransactionDetails.FooterRow.FindControl("ddlAddProduct");
Prorepo = new ProductRepository(db);
ddlAddProduct.DataSource = Prorepo.GetAll().Where(p => p.TenantId == tenantId).ToList();
ddlAddProduct.DataTextField = "ProductName";
ddlAddProduct.DataValueField = "ProductId";
ddlAddProduct.DataBind();
////conn.Open();
//string cmdstr = "Select * from EmployeeDetails";
//SqlCommand cmd = new SqlCommand(cmdstr, conn);
//SqlDataAdapter adp = new SqlDataAdapter(cmd);
//adp.Fill(ds);
//cmd.ExecuteNonQuery();
//FromTable = ds.Tables[0];
//if (FromTable.Rows.Count > 0)
//{
// gvHistoryTransactionDetails.DataSource = FromTable;
// gvHistoryTransactionDetails.DataBind();
//}
//else
//{
// FromTable.Rows.Add(FromTable.NewRow());
// gvHistoryTransactionDetails.DataSource = FromTable;
// gvHistoryTransactionDetails.DataBind();
// int TotalColumns = gvHistoryTransactionDetails.Rows[0].Cells.Count;
// gvHistoryTransactionDetails.Rows[0].Cells.Clear();
// gvHistoryTransactionDetails.Rows[0].Cells.Add(new TableCell());
// gvHistoryTransactionDetails.Rows[0].Cells[0].ColumnSpan = TotalColumns;
// gvHistoryTransactionDetails.Rows[0].Cells[0].Text = "No records Found";
//}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
//conn.Close();
}
}
