private void AddNewRowToGrid()
{
if (ViewState["CurrentTable"] != null)
{
DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
DataRow drCurrentRow = null;
if (dtCurrentTable.Rows.Count > 0)
{
drCurrentRow = dtCurrentTable.NewRow();
drCurrentRow["RowNumber"] = dtCurrentTable.Rows.Count + 1;
//add new row to DataTable
dtCurrentTable.Rows.Add(drCurrentRow);
//Store the current data to ViewState for future reference
ViewState["CurrentTable"] = dtCurrentTable;
for (int i = 0; i < dtCurrentTable.Rows.Count - 1; i++)
{
//extract the TextBox values
TextBox box1 = (TextBox)Gridview1.Rows[i].Cells[2].FindControl("TextBox1");
TextBox box2 = (TextBox)Gridview1.Rows[i].Cells[3].FindControl("txtrate");
TextBox box3 = (TextBox)Gridview1.Rows[i].Cells[4].FindControl("txtqty");
TextBox box4 = (TextBox)Gridview1.Rows[i].Cells[5].FindControl("txtamount");
// TextBox box5 = (TextBox)GridV1.Rows[i].Cells[6].FindControl("TextBox5");
dtCurrentTable.Rows[i]["Column2"] = box1.Text;
dtCurrentTable.Rows[i]["Column3"] = box2.Text;
dtCurrentTable.Rows[i]["Column4"] = box3.Text;
dtCurrentTable.Rows[i]["Column5"] = box4.Text;
// dtCurrentTable.Rows[i]["Column6"] = box5.Text;
//extract the DropDownList Selected Items
DropDownList ddl1 = (DropDownList)Gridview1.Rows[i].Cells[1].FindControl("DropDownList1");
// Label lbl1 = (Label)Gridview1.Rows[i].Cells[3].FindControl("Label1");
//DropDownList ddl2 = (DropDownList)Gridview1.Rows[i].Cells[2].FindControl("DropDownList2");
// Update the DataRow with the DDL Selected Items
dtCurrentTable.Rows[i]["Column1"] = ddl1.SelectedItem.Text;
//dtCurrentTable.Rows[i]["Column3"] = lbl1.Text;
//dtCurrentTable.Rows[i]["Column2"] = ddl2.SelectedItem.Text;
}
//Rebind the Grid with the current data to reflect changes
Gridview1.DataSource = dtCurrentTable;
Gridview1.DataBind();
}
}
else
{
Response.Write("ViewState is null");
}
//Set Previous Data on Postbacks
SetPreviousData();
}
protected void Gridview1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView theGrid = sender as GridView; // refer to the GridView
int newPageIndex = 0;
if (-2 == e.NewPageIndex)
{
TextBox txtNewPageIndex = null;
GridViewRow pagerRow = Gridview1.BottomPagerRow;
if (null != pagerRow)
{
txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox"); // refer to the TextBox with the NewPageIndex value
}
if (null != txtNewPageIndex && txtNewPageIndex.Text != "")
{
newPageIndex = int.Parse(txtNewPageIndex.Text) - 1; // get the NewPageIndex
}
}
else
{
newPageIndex = e.NewPageIndex;
}
PMPurchaseOrderinfo.PMPO_PurchaseOrderID = new Guid(labelPurchaseOrderID.Text);
BindGridview1(PMPurchaseOrderinfo);
Gridview1.DataBind();
newPageIndex = newPageIndex < 0 ? 0 : newPageIndex;
newPageIndex = newPageIndex >= Gridview1.PageCount ? Gridview1.PageCount - 1 : newPageIndex;
Gridview1.PageIndex = newPageIndex;
Gridview1.DataBind();
}
private void gvbind()
{
SqlConnection con = new SqlConnection(strCon);
con.Open();
SqlCommand cmd = new SqlCommand("select Grn_id,date,purchase_order,suplier_name,material_name,quantity,damage from Damage", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
Gridview1.DataSource = ds;
Gridview1.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
Gridview1.DataSource = ds;
Gridview1.DataBind();
int columncount = Gridview1.Rows[0].Cells.Count;
Gridview1.Rows[0].Cells.Clear();
Gridview1.Rows[0].Cells.Add(new TableCell());
Gridview1.Rows[0].Cells[0].ColumnSpan = columncount;
Gridview1.Rows[0].Cells[0].Text = "No Records Found";
}
}
/// <summary>
/// Method populate gridview datasource
/// </summary>
public void PopulateGridView()
{
//update gridview datasource
using (SqlConnection sqlConn = new SqlConnection(this.GetConnectionString()))
{
sqlConn.Open();
using (SqlCommand sqlCmd = new SqlCommand("Proc_BasicQuery", sqlConn))
{
DataSet dt = new DataSet();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new SqlParameter("@DegreeLevelID", Convert.ToInt32(level_DropDownList.SelectedValue)));
sqlCmd.Parameters.Add(new SqlParameter("@DegreeID", Convert.ToInt32(degree_DropDownList.SelectedValue)));
sqlCmd.Parameters.Add(new SqlParameter("@TutorID", Convert.ToInt32(Tutor_DropDownList.SelectedValue)));
sqlCmd.Parameters.Add(new SqlParameter("@CourseID", Convert.ToInt32(programe_dropdownlist.SelectedValue)));
sqlCmd.Parameters.Add(new SqlParameter("@FacultyID", Convert.ToInt32(faculty_dropdownlist.SelectedValue)));
sqlCmd.Parameters.Add(new SqlParameter("@YearID", Convert.ToInt32(year_ddl.SelectedValue)));
sqlCmd.Parameters.Add(new SqlParameter("@ModuleID", Convert.ToInt32("-1")));
SqlDataAdapter da = new SqlDataAdapter(sqlCmd);
da.Fill(dt);
sqlConn.Close();
Gridview1.DataSource = null;
Gridview1.DataSource = dt;
Gridview1.DataSourceID = String.Empty;
Gridview1.DataBind();
}
}
}
private void gvbind()
{
SqlConnection con = new SqlConnection(cs);
con.Open();
SqlCommand cmd = new SqlCommand("SELECT mid, mmaterialcode,mspecifications,mcategory,msubcategory,mmaterial,msize,mminimum,mtotalqty,cft,cum FROM mwood", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
Gridview1.DataSource = ds;
Gridview1.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
Gridview1.DataSource = ds;
Gridview1.DataBind();
int columncount = Gridview1.Rows[0].Cells.Count;
Gridview1.Rows[0].Cells.Clear();
Gridview1.Rows[0].Cells.Add(new TableCell());
Gridview1.Rows[0].Cells[0].ColumnSpan = columncount;
Gridview1.Rows[0].Cells[0].Text = "No Records Found";
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
GridViewRow gvRow = (GridViewRow)lb.NamingContainer;
int rowID = gvRow.RowIndex;
if (ViewState["CurrentTable"] != null)
{
DataTable dt = (DataTable)ViewState["CurrentTable"];
if (dt.Rows.Count > 1)
{
if (gvRow.RowIndex < dt.Rows.Count - 1)
{
//Remove the Selected Row data and reset row number
dt.Rows.Remove(dt.Rows[rowID]);
ResetRowID(dt);
}
}
//Store the current data in ViewState for future reference
ViewState["CurrentTable"] = dt;
//Re bind the GridView for the updated data
Gridview1.DataSource = dt;
Gridview1.DataBind();
}
//Set Previous Data on Postbacks
SetPreviousData();
}
protected void company_list_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList ddl = sender as DropDownList;
Gridview1.DataSource = projects.Where(x => x.CompanyId == Int32.Parse(ddl.SelectedValue));
Gridview1.DataBind();
}
protected void bind11()
{
dbcon();
string query = "";
query = "SELECT LabourDescr, HoursRequired ,AmountRequired FROM dWorkorderDetails where RefNo='WKO_004'";
// string constr = Session["Cnn"].ToString();
cmd = new SqlCommand(query, con);
adp = new SqlDataAdapter(cmd);
ds = new DataSet();
adp.Fill(ds);
rd = cmd.ExecuteReader();
if (ds.Tables[0].Rows.Count > 0)
{
Gridview1.DataSource = ds;
Gridview1.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
Gridview1.DataSource = ds;
Gridview1.DataBind();
int columncount = Gridview1.Rows[0].Cells.Count;
Gridview1.Rows[0].Cells.Clear();
// GridView1.FooterRow.Cells.Clear();
Gridview1.Rows[0].Cells.Add(new TableCell());
Gridview1.Rows[0].Cells[0].ColumnSpan
= columncount;
Gridview1.Rows[0].Cells[0].Text = "No Records Found";
}
}
protected void BindGrid()
{
DataTable dt = (DataTable)ViewState["datagrid"];
Gridview1.DataSource = dt;
Gridview1.DataBind();
}
protected void Gridview_Project_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView theGrid = sender as GridView; // refer to the GridView
int newPageIndex = 0;
if (-2 == e.NewPageIndex)
{
TextBox txtNewPageIndex = null;
GridViewRow pagerRow = Gridview1.BottomPagerRow;
if (null != pagerRow)
{
txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox"); // refer to the TextBox with the NewPageIndex value
}
if (null != txtNewPageIndex && txtNewPageIndex.Text != "")
{
newPageIndex = int.Parse(txtNewPageIndex.Text) - 1; // get the NewPageIndex
}
}
else
{
newPageIndex = e.NewPageIndex;
}
string Condition = GetCondition();
BindGridview1(Condition);
Gridview1.DataBind();
newPageIndex = newPageIndex < 0 ? 0 : newPageIndex;
newPageIndex = newPageIndex >= Gridview1.PageCount ? Gridview1.PageCount - 1 : newPageIndex;
Gridview1.PageIndex = newPageIndex;
Gridview1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["user"] != null)
{
if (!Page.IsPostBack)
{
string query = "select * from passengerinfo;";
using (SqlConnection con = new SqlConnection(conn))
{
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
Gridview1.DataSource = cmd.ExecuteReader();
Gridview1.DataBind();
}
}
}
else
{
Response.Redirect("index.aspx");
}
}
catch (NullReferenceException ex)
{
Response.Redirect("SessionExpired.html");
}
}
private void gridView1_CustomDrawRowIndicator(object sender, RowIndicatorCustomDrawEventArgs e)
{
if (!Gridview1.IsGroupRow(e.RowHandle)) //Nếu không phải là Group
{
if (e.Info.IsRowIndicator) //Nếu là dòng Indicator
{
if (e.RowHandle < 0)
{
e.Info.ImageIndex = 0;
e.Info.DisplayText = string.Empty;
}
else
{
e.Info.ImageIndex = -1; //Không hiển thị hình
e.Info.DisplayText = (e.RowHandle + 1).ToString(); //Số thứ tự tăng dần
}
SizeF _Size = e.Graphics.MeasureString(e.Info.DisplayText, e.Appearance.Font); //Lấy kích thước của vùng hiển thị Text
Int32 _Width = Convert.ToInt32(_Size.Width) + 20;
BeginInvoke(new MethodInvoker(delegate { cal(_Width, Gridview1); })); //Tăng kích thước nếu Text vượt quá
}
}
else
{
e.Info.ImageIndex = -1;
e.Info.DisplayText = string.Format("[{0}]", (e.RowHandle * -1)); //Nhân -1 để đánh lại số thứ tự tăng dần
SizeF _Size = e.Graphics.MeasureString(e.Info.DisplayText, e.Appearance.Font);
Int32 _Width = Convert.ToInt32(_Size.Width) + 20;
BeginInvoke(new MethodInvoker(delegate { cal(_Width, Gridview1); }));
}
}
private void SetInitialRow()
{
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));
dt.Columns.Add(new DataColumn("ItemCode", typeof(string)));
dt.Columns.Add(new DataColumn("ItemName", typeof(string)));
dt.Columns.Add(new DataColumn("Quantity", typeof(string)));
dt.Columns.Add(new DataColumn("Price", typeof(string)));
dt.Columns.Add(new DataColumn("Total", typeof(string)));
dr = dt.NewRow();
dr["RowNumber"] = 1;
dr["ItemCode"] = string.Empty;
dr["ItemName"] = string.Empty;
dr["Quantity"] = string.Empty;
dr["Price"] = string.Empty;
dr["Total"] = string.Empty;
dt.Rows.Add(dr);
//Store the DataTable in ViewState
ViewState["CurrentTable"] = dt;
Gridview1.DataSource = dt;
Gridview1.DataBind();
}
protected void btncalculate_Click(object sender, EventArgs e)
{
tamt = 0;
foreach (GridViewRow row in Gridview1.Rows)
{
TextBox trate = (TextBox)row.Cells[2].FindControl("txtrate");
Double rate = Convert.ToDouble(trate.Text);
TextBox tqty = (TextBox)row.Cells[3].FindControl("txtqty");
Double qty = Convert.ToDouble(tqty.Text);
TextBox txtamount = (TextBox)row.Cells[4].FindControl("txtamount");
TextBox tnet = (TextBox)row.Cells[5].FindControl("txtnetamt");
con.Open();
SqlCommand sql = new SqlCommand("select value from settings where name='cgst'", con);
SqlDataAdapter da = new SqlDataAdapter(sql);
DataTable dt = new DataTable();
da.Fill(dt);
cgst = Convert.ToDouble(dt.Rows[0][0].ToString());
sgst = Convert.ToDouble(dt.Rows[0][0].ToString());
Double total = Convert.ToDouble(dt.Rows[0][0].ToString());
Double amt = rate * qty;
txtamount.Text = amt.ToString();
tamt = tamt + amt;
//ttamount = ttamount + amt;
TextBox txtItemDescrCode = (TextBox)Gridview1.FindControl("TextBox1");
SqlCommand cmd = new SqlCommand("insert into BillDetails (Rate,Qty) values ('" + rate + "','" + qty + "')");
con.Close();
}
txtnetamt.Text = Convert.ToString(tamt);
txtcgst.Text = Convert.ToString(cgst * tamt);
txtsgst.Text = Convert.ToString(sgst * tamt);
txttotal.Text = Convert.ToString((tamt + (sgst * tamt) + (cgst * tamt)));
}
void BindPurchaseOrderItem(int id)
{
oblPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessLogic.PurchaseOrderItem();
try
{
objPurchaseOrderItemList = oblPurchaseOrderItem.GetAllPurchaseOrderItemList(id, 0, "");
if (objPurchaseOrderItemList != null)
{
Gridview1.DataSource = objPurchaseOrderItemList;
Gridview1.DataBind();
}
else
{
Gridview1.DataSource = null;
Gridview1.DataBind();
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PReceived).FullName, 1);
}
finally
{
oblPurchaseOrderItem = null;
objPurchaseOrderItemList = null;
}
}
//protected void txtSearch_TextChanged(object sender, EventArgs e)
//{
// SearchText();
//}
//protected void btn_search_Click(object sender, EventArgs e)
//{
// Bindbecut();
//}
//public string Highlight(string InputTxt)
//{
// string Search_Str = txtSearch.Text.ToString();
// // Setup the regular expression and add the Or operator.
// Regex RegExp = new Regex(Search_Str.Replace(" ", "|").Trim(),
// RegexOptions.IgnoreCase);
// // Highlight keywords by calling the
// //delegate each time a keyword is found.
// return RegExp.Replace(InputTxt,
// new MatchEvaluator(ReplaceKeyWords));
// // Set the RegExp to null.
// RegExp = null;
//}
//public string ReplaceKeyWords(Match m)
//{
// return "<span class=highlight>" + m.Value + "</span>";
//}
//private void SearchText()
//{
// Bindbecut();
//}
protected void Bindbecut()
{
string sqry = string.Empty;
//if (txtSearch.Text == "")
//{
// sqry = "";
//}
//else
//{
// sqry = "where no_baucer LIKE'%" + txtSearch.Text + "%'";
//}
qry1 = "select no_baucer, FORMAT(tarkih_mula,'dd/MM/yyyy') tarkih_mula,FORMAT(tarkih_akhir,'dd/MM/yyyy') tarkih_akhir,nama_sebut, jumlah_amt as jumlah_amt from KW_Sebut_harga " + sqry + "";
SqlCommand cmd2 = new SqlCommand("" + qry1 + "", con);
SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
DataSet ds2 = new DataSet();
da2.Fill(ds2);
if (ds2.Tables[0].Rows.Count == 0)
{
ds2.Tables[0].Rows.Add(ds2.Tables[0].NewRow());
Gridview1.DataSource = ds2;
Gridview1.DataBind();
int columncount = Gridview1.Rows[0].Cells.Count;
Gridview1.Rows[0].Cells.Clear();
Gridview1.Rows[0].Cells.Add(new TableCell());
Gridview1.Rows[0].Cells[0].ColumnSpan = columncount;
Gridview1.Rows[0].Cells[0].Text = "<center><strong>Maklumat Carian Tidak Dijumpai</strong></center>";
}
else
{
Gridview1.DataSource = ds2;
Gridview1.DataBind();
}
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
Gridview1.PageIndex = e.NewPageIndex;
dt = GlobalAnnounce.overview.get_dcr();
Gridview1.DataSource = dt;
Gridview1.DataBind();
}
private void AddNewRowToGrid2(int index, string 交易方卡号, string 交易方姓名, string 交易方银行, string 交易金额, string 备注)
{
if (ViewState["CurrentTable"] != null)
{
DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
DataRow drCurrentRow = null;
if (index > dtCurrentTable.Rows.Count - 1)
{
drCurrentRow = dtCurrentTable.NewRow();
dtCurrentTable.Rows.Add(drCurrentRow);
}
else
{
drCurrentRow = dtCurrentTable.Rows[index];
}
drCurrentRow["Column1"] = 交易方卡号;
drCurrentRow["Column2"] = 交易方姓名;
drCurrentRow["Column3"] = 交易方银行;
drCurrentRow["Column4"] = 交易金额;
drCurrentRow["Column5"] = 备注;
ViewState["CurrentTable"] = dtCurrentTable;
Gridview1.DataSource = dtCurrentTable;
Gridview1.DataBind();
}
else
{
Response.Write("ViewState is null");
}
SetPreviousData();
}
private void SetInitialRow()
{
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));
dt.Columns.Add(new DataColumn("Column1", typeof(string))); //for DropDownList selected item
dt.Columns.Add(new DataColumn("Column2", typeof(string))); //for TextBox value
dr = dt.NewRow();
dr["RowNumber"] = 1;
dr["Column2"] = string.Empty;
dt.Rows.Add(dr);
//Store the DataTable in ViewState for future reference
ViewState["CurrentTable"] = dt;
//Bind the Gridview
Gridview1.DataSource = dt;
Gridview1.DataBind();
//After binding the gridview, we can then extract and fill the DropDownList with Data
DropDownList ddl1 = (DropDownList)Gridview1.Rows[0].Cells[3].FindControl("DropDownList1");
// DropDownList ddl2 = (DropDownList)Gridview1.Rows[0].Cells[4].FindControl("DropDownList2");
FillDropDownList(ddl1);
Button button_txt = (Button)Gridview1.Rows[0].Cells[4].FindControl("InActive");
//FillDropDownList1(ddl2);
}
protected void Gridview_ProjectSchedule_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView theGrid = sender as GridView; // refer to the GridView
int newPageIndex = 0;
if (-2 == e.NewPageIndex)
{
TextBox txtNewPageIndex = null;
GridViewRow pagerRow = Gridview1.BottomPagerRow;
if (null != pagerRow)
{
txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox"); // refer to the TextBox with the NewPageIndex value
}
if (null != txtNewPageIndex && txtNewPageIndex.Text != "")
{
newPageIndex = int.Parse(txtNewPageIndex.Text) - 1; // get the NewPageIndex
}
}
else
{
newPageIndex = e.NewPageIndex;
}
Guid pd = new Guid(label_supplytypeid.Text.ToString());
BindGridView_ProjectSchedule(pd);
newPageIndex = newPageIndex < 0 ? 0 : newPageIndex;
newPageIndex = newPageIndex >= Gridview1.PageCount ? Gridview1.PageCount - 1 : newPageIndex;
Gridview1.PageIndex = newPageIndex;
Gridview1.DataBind();
}
protected void DeleteRowHandler(object sender, CommandEventArgs e)
{
GridViewRow row = ((GridViewRow)((LinkButton)sender).Parent.Parent);
//DataTable dt = new DataTable();
DataTable dt = (DataTable)ViewState["CurrentTable"];
dt.Rows.RemoveAt(row);
ViewState["CurrentTable"] = dt;
Gridview1.DataSource = dt;
Gridview1.DataBind();
//DataRow dr=null;
//dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));
//dt.Columns.Add(new DataColumn("Column1", typeof(string)));
//dt.Columns.Add(new DataColumn("Column2", typeof(string)));
//dt.Columns.Add(new DataColumn("Column3", typeof(string)));
//for (int i = 1; i <Gridview1.Rows.Count; i++)
//{
// dr=dt.NewRow();
// dr[1] = ((TextBox)Gridview1.Rows[i].Cells[1].FindControl("TextBox1")).Text;
// dr[2] = ((TextBox)Gridview1.Rows[i].Cells[2].FindControl("TextBox2")).Text;
// dr[3] = ((TextBox)Gridview1.Rows[i].Cells[3].FindControl("TextBox3")).Text;
// dt.Rows.Add(dr);
//}
//dt.Rows.RemoveAt(row.RowIndex);
//ViewState["CurrentTable"]=dt;
//Gridview1.DataSource=dt;
//Gridview1.DataBind();
}
protected void ButtonAdd_Click(object sender, EventArgs e)
{
int rowIndex = 0;
if (ViewState["CurrentTable"] != null)
{
DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
DataRow drCurrentRow = null;
if (dtCurrentTable.Rows.Count > 0)
{
for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
{
DropDownList box1 = (DropDownList)Gridview1.Rows[rowIndex].Cells[0].FindControl("DropDownListIngredient");
TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("TextBoxWeight");
drCurrentRow = dtCurrentTable.NewRow();
drCurrentRow["RowNumber"] = i + 1;
dtCurrentTable.Rows[i - 1]["Column1"] = box1.SelectedItem.Text;
dtCurrentTable.Rows[i - 1]["Column2"] = box2.Text;
rowIndex++;
}
dtCurrentTable.Rows.Add(drCurrentRow);
ViewState["CurrentTable"] = dtCurrentTable;
Gridview1.DataSource = dtCurrentTable;
Gridview1.DataBind();
}
}
else
{
Response.Write("ViewState is null");
}
SetPreviousData();
}
private void AddNewRowToGrid()
{
int num = 0;
if (ViewState["CurrentTable"] != null)
{
DataTable table = (DataTable)ViewState["CurrentTable"];
DataRow row = null;
if (table.Rows.Count > 0)
{
for (int i = 1; i <= table.Rows.Count; i++)
{
TextBox box = (TextBox)Gridview1.Rows[num].Cells[1].FindControl("TextBox1");
TextBox box2 = (TextBox)Gridview1.Rows[num].Cells[2].FindControl("TextBox2");
TextBox box3 = (TextBox)Gridview1.Rows[num].Cells[3].FindControl("TextBox3");
row = table.NewRow();
row["RowNumber"] = i + 1;
table.Rows[i - 1]["Column1"] = box.Text;
table.Rows[i - 1]["Column2"] = box2.Text;
table.Rows[i - 1]["Column3"] = box3.Text;
num++;
}
table.Rows.Add(row);
ViewState["CurrentTable"] = table;
Gridview1.DataSource = table;
Gridview1.DataBind();
}
}
else
{
Response.Write("ViewState is null");
}
SetPreviousData();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
int rows = Gridview1.Rows.Count;
if (rows == 0)
{
dt.Columns.Add("ID_Row", typeof(System.Int64));
dt.Columns.Add("Name", typeof(String));
dt.Columns.Add("Gender", typeof(String));
dt.Columns.Add("Country", typeof(String));
}
else
{
dt = (DataTable)ViewState["viewstate"];
}
DataRow datarow = dt.NewRow();
datarow["ID_Row"] = (rows + 1);
datarow["Name"] = txtName.Text.ToString();
datarow["Gender"] = txtGender.Text.ToString();
datarow["Country"] = txtCountry.Text.ToString();
dt.Rows.Add(datarow);
ViewState["viewstate"] = dt;
Gridview1.DataSource = dt;
Gridview1.DataBind();
}
private void reset()
{
txtDic.Text = string.Empty;
txtDicPre.Text = string.Empty;
txtMiscCost.Text = string.Empty;
txtSHC.Text = string.Empty;
txtTax.Text = string.Empty;
txttotal.Text = string.Empty;
txtSubTotal.Text = string.Empty;
Gridview1.DataSource = null;
Gridview1.DataBind();
SetInitialRow();
ViewState["CurrentTable"] = null;
hfVendor.Value = "";
txtVendor.Text = "";
txtAddress.Text ="";
txtCountry.Text = "";
txtState.Text = "";
txtCity.Text = "";
txtPin.Text = "";
txtMobile.Text ="";
txtEmail.Text = "";
this.mpopSummary.Hide();
upForm.Update();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataTable dt = new DataTable();
dt = (DataTable)ViewState["viewstate"];
String id = (Gridview1.Rows[e.RowIndex].Cells[0].Text.ToString());
for (int i = 0; i < dt.Rows.Count; i++)
{
if (id == (dt.Rows[i][0].ToString()))
{
dt.Rows.RemoveAt(i);
break;
}
}
ViewState["viewstate"] = dt;
Gridview1.DataSource = dt;
Gridview1.DataBind();
// int ID = Int32.Parse(Gridview1.Rows); //''
//' dtgDetail.Rows[RowIndex].Cells[BoundFieldIndex].Text;
//if(e.c)
//int ID = Int32.Parse(Gridview1.
}
private void SetInitialRow()
{
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));
dt.Columns.Add(new DataColumn("Column1", typeof(string)));
dt.Columns.Add(new DataColumn("Column2", typeof(string)));
dt.Columns.Add(new DataColumn("Column3", typeof(string)));
dt.Columns.Add(new DataColumn("Column4", typeof(string)));
dt.Columns.Add(new DataColumn("Column5", typeof(string)));
dt.Columns.Add(new DataColumn("Column6", typeof(string)));
dt.Columns.Add(new DataColumn("Column7", typeof(string)));
dr = dt.NewRow();
dr["RowNumber"] = 1;
dr["Column1"] = string.Empty;
dr["Column2"] = string.Empty;
dr["Column3"] = string.Empty;
dr["Column4"] = string.Empty;
dr["Column5"] = string.Empty;
dr["Column6"] = string.Empty;
dr["Column7"] = string.Empty;
dt.Rows.Add(dr);
//Store the DataTable in ViewState
ViewState["CurrentTable"] = dt;
Gridview1.DataSource = dt;
Gridview1.DataBind();
}
void BindSaleOrderItem(int id)
{
oblsalesRtnItem = new Store.SaleReturnItem.BusinessLogic.SaleReturnItem();
try
{
objsalesRtnItemList = oblsalesRtnItem.GetAllSaleReturnItemList(id, 0, "");
if (objsalesRtnItemList != null)
{
Gridview1.DataSource = objsalesRtnItemList;
Gridview1.DataBind();
}
else
{
Gridview1.DataSource = null;
Gridview1.DataBind();
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SalesReturn).FullName, 1);
}
finally
{
oblsalesRtnItem = null;
objsalesRtnItemList = null;
}
}
private void gvbind()
{
con.Open();
SqlCommand cmd = new SqlCommand("Select * from customeranalysis1", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
Gridview1.DataSource = ds;
Gridview1.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
Gridview1.DataSource = ds;
Gridview1.DataBind();
int columncount = Gridview1.Rows[0].Cells.Count;
Gridview1.Rows[0].Cells.Clear();
Gridview1.Rows[0].Cells.Add(new TableCell());
Gridview1.Rows[0].Cells[0].ColumnSpan = columncount;
Gridview1.Rows[0].Cells[0].Text = "No Records Found";
}
}
private void SetInitialRow()
{
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("ItemCode", typeof(string))); //for TextBox value
dt.Columns.Add(new DataColumn("Quantity", typeof(string))); //for TextBox value
dr = dt.NewRow();
dr["ItemCode"] = string.Empty;
dr["Quantity"] = string.Empty;
dt.Rows.Add(dr);
//Store the DataTable in ViewState for future reference
ViewState["Saleitems"] = dt;
//Bind the Gridview
Gridview1.DataSource = dt;
Gridview1.DataBind();
//After binding the gridview, we can then extract and fill the DropDownList with Data
DropDownList ddl1 = (DropDownList)Gridview1.Rows[0].Cells[0].FindControl("ddlItemCode");
FillDropDownList(ddl1);
}
