protected void ReportGridDtls_RowCommand(object sender, GridViewCommandEventArgs e) { try { switch (e.CommandName) { case ("Select"): { if (Convert.ToInt32(e.CommandArgument) != 0) { ViewState["EditId"] = Convert.ToInt32(e.CommandArgument); DS = Obj_damage.GetRecordForEdit(Convert.ToInt32(e.CommandArgument), out StrError); if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0) { TxtReturnNo.Text = DS.Tables[0].Rows[0]["ReturnNo"].ToString(); lblReturndate.Text = DS.Tables[0].Rows[0]["ReturnDate"].ToString(); lblPreparedBy.Text = DS.Tables[0].Rows[0]["UserName"].ToString(); // Session["UserName"].ToString(); lblInwardNo.Text = DS.Tables[0].Rows[0]["InwardNo"].ToString(); lblInwardDate.Text = DS.Tables[0].Rows[0]["InwardDate"].ToString(); lblSuppName.Text = DS.Tables[0].Rows[0]["SuplierName"].ToString(); lblpono.Text = DS.Tables[0].Rows[0]["PONo"].ToString(); lblPODATE.Text = DS.Tables[0].Rows[0]["PODate"].ToString(); lblQuotationNo.Text = DS.Tables[0].Rows[0]["POQTNO"].ToString(); lblQuotationDate.Text = DS.Tables[0].Rows[0]["POQTDATE"].ToString(); ddlInwardNo.Enabled = false; } else { MakeEmptyForm(); } if (DS.Tables[1].Rows.Count > 0) { FlagForCalculationOperation = true; GrdInward.DataSource = DS.Tables[1]; GrdInward.DataBind(); ViewState["CurrentTable"] = DS.Tables[1]; ViewState["ReturnDtls"] = DS.Tables[1]; } DS = null; Obj_damage = null; BtnUpdate.Visible = true; BtnSave.Visible = false; } break; } } } catch (Exception ex) { throw new Exception(ex.Message); } }
private void SetInitialRow() { DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add("#", typeof(Int32)); dt.Columns.Add("InwardNo", typeof(string)); dt.Columns.Add("ItemId", typeof(Int32)); dt.Columns.Add("ItemCode", typeof(string)); dt.Columns.Add("ItemName", typeof(string)); dt.Columns.Add("ItemDesc", typeof(string)); dt.Columns.Add("UnitId", typeof(Int32)); dt.Columns.Add("Unit", typeof(string)); dt.Columns.Add("InwardQty", typeof(decimal)); dt.Columns.Add("DamageQty", typeof(decimal)); dt.Columns.Add("PrevReturnQty", typeof(decimal)); dt.Columns.Add("GrdtxtReturnQty", typeof(decimal)); dt.Columns.Add("rate", typeof(decimal)); dt.Columns.Add("Amount", typeof(decimal)); dt.Columns.Add("Reason", typeof(string)); dr = dt.NewRow(); dr["#"] = 0; dr["InwardNo"] = ""; dr["ItemId"] = 0; dr["ItemCode"] = ""; dr["ItemName"] = ""; dr["ItemDesc"] = ""; dr["UnitId"] = 0; dr["Unit"] = ""; dr["InwardQty"] = 0.0; dr["DamageQty"] = 0.0; dr["PrevReturnQty"] = 0.0; dr["GrdtxtReturnQty"] = 0.0; dr["rate"] = 0.0; dr["Amount"] = 0.0; dr["Reason"] = ""; dt.Rows.Add(dr); ViewState["CurrentTable"] = dt; ViewState["ReturnDtls"] = dt; GrdInward.DataSource = dt; GrdInward.DataBind(); }
protected void ddlInwardNo_SelectedIndexChanged(object sender, EventArgs e) { try { DS = Obj_damage.GetInwardDtls(Convert.ToInt32(ddlInwardNo.SelectedValue), out StrError); if (DS.Tables.Count > 0) { if (DS.Tables[0].Rows.Count > 0) { lblInwardNo.Text = DS.Tables[0].Rows[0]["InwardNo"].ToString(); lblInwardDate.Text = DS.Tables[0].Rows[0]["InwardDate"].ToString(); lblSuppName.Text = DS.Tables[0].Rows[0]["SuplierName"].ToString(); lblpono.Text = DS.Tables[0].Rows[0]["PONo"].ToString(); lblPODATE.Text = DS.Tables[0].Rows[0]["PODate"].ToString(); lblQuotationNo.Text = DS.Tables[0].Rows[0]["POQTNO"].ToString(); lblQuotationDate.Text = DS.Tables[0].Rows[0]["POQTDATE"].ToString(); } else { lblInwardNo.Text = ""; lblInwardDate.Text = ""; lblSuppName.Text = ""; } if (DS.Tables[1].Rows.Count > 0) { FlagForCalculationOperation = false; GrdInward.DataSource = DS.Tables[1]; GrdInward.DataBind(); BlockTextBox(); ((TextBox)GrdInward.Rows[0].FindControl("GrdtxtReturnQty")).Focus(); } else { SetInitialRow(); } } } catch (Exception ex) { throw new Exception(ex.Message); } }