private void Populate(Int64 stckid) { OpenTyreDAL objMast = new OpenTyreDAL(); StckMast objStckMast = objMast.SelectById(stckid); if (objStckMast != null) { var VarStckDetl = objMast.SelectDetlById(Convert.ToInt64(objStckMast.Item_Idno), Convert.ToInt64(objStckMast.Loc_Idno)); if (VarStckDetl != null && VarStckDetl.Count > 0) { for (int i = 0; i < VarStckDetl.Count; i++) { ApplicationFunction.DatatableAddRow(dtTemp, i + 1, Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Item_Name")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Item_Idno")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Loc_Name")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Loc_Idno")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "SerialNo"))); } ViewState["dt"] = dtTemp; dtTemp = (DataTable)ViewState["dt"]; if (dtTemp != null && dtTemp.Rows.Count > 0) { ddlItemName.Enabled = false; ddlLocation.Enabled = false; ddlItemName.SelectedValue = Convert.ToString(DataBinder.Eval(VarStckDetl[0], "Item_Idno")); ddlLocation.SelectedValue = Convert.ToString(DataBinder.Eval(VarStckDetl[0], "Loc_Idno")); } else { ddlItemName.Enabled = true; ddlLocation.Enabled = true; } this.BindGridT(); } } objMast = null; }
private void FetchRecords() { Int64 YearIdno = Convert.ToInt64(ddlDateRange.SelectedValue); Int64 LocIdno = ddlLocation.SelectedIndex == 0 ? 0 : Convert.ToInt64(ddlLocation.SelectedValue); Int64 ItemIdno = ddlItemName.SelectedIndex == 0 ? 0 : Convert.ToInt64(ddlItemName.SelectedValue); OpenAccDAL objMast = new OpenAccDAL(); var Mast = objMast.SelectStckMast(YearIdno, LocIdno, ItemIdno); if (Mast != null && Mast.Count > 0) { dtTemp = (DataTable)ViewState["dt"]; if (dtTemp.Rows.Count > 0) { dtTemp = null; dtTemp = CreateDt(); ViewState["dt"] = dtTemp; } for (int i = 0; i < Mast.Count; i++) { ApplicationFunction.DatatableAddRow(dtTemp, i + 1, Convert.ToString(DataBinder.Eval(Mast[i], "YearIdno")), Convert.ToString(DataBinder.Eval(Mast[i], "LocIdno")), Convert.ToString(DataBinder.Eval(Mast[i], "LocName")), Convert.ToString(DataBinder.Eval(Mast[i], "ItemIdno")), Convert.ToString(DataBinder.Eval(Mast[i], "ItemName")), string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(Mast[i], "Qty"))) == true ? "0" : Convert.ToString(DataBinder.Eval(Mast[i], "Qty")), string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(Mast[i], "Rate"))) == true ? "0.00" : Convert.ToString(DataBinder.Eval(Mast[i], "Rate"))); } ViewState["dt"] = dtTemp; dtTemp = (DataTable)ViewState["dt"]; this.BindGridT(); } else { dtTemp = null; dtTemp = CreateDt(); ViewState["dt"] = dtTemp; grdMain.DataSource = dtTemp; grdMain.DataBind(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { DtTemp = (DataTable)ViewState["dt"]; string msg = string.Empty; if (txtReceivedAmount.Text == string.Empty) { this.ShowMessage("Please enter Received Amount!"); return; } else if (txtSummaryNo.Text == string.Empty) { this.ShowMessage("Please enter Summary No!"); return; } else { if (txtReceivedAmount.Text == string.Empty || txtReceivedAmount.Text == "0") { this.ShowMessage("Received Amount must be greater than 0!"); return; } else if (txtSummaryNo.Text == string.Empty || txtSummaryNo.Text == "0") { this.ShowMessage(" Summary No must be greater than 0!"); return; } } if (Hidrowid.Value != string.Empty) { DtTemp = (DataTable)ViewState["dt"]; foreach (DataRow dtrow in DtTemp.Rows) { if (Convert.ToString(dtrow["id"]) == Convert.ToString(Hidrowid.Value)) { dtrow["Sumry_No"] = txtSummaryNo.Text; dtrow["Recvng_Date"] = txtRecDate.Text; dtrow["Recvng_Amnt"] = txtReceivedAmount.Text; dtrow["Remark"] = txtRemark.Text; } } } else { if (DtTemp == null) { DtTemp = CreateDt(); } int id = DtTemp.Rows.Count == 0 ? 1 : DtTemp.Rows.Count + 1; ApplicationFunction.DatatableAddRow(DtTemp, id, txtSummaryNo.Text, txtRecDate.Text, txtReceivedAmount.Text, txtRemark.Text); ViewState["dt"] = DtTemp; } this.BindGrid(); this.ClearItems(); }
public DataTable ReadExcelFile(string fileName) { string msg = string.Empty; DataTable dt = new DataTable(); string filepath = Server.MapPath(fileName); string constring = string.Empty; if (System.IO.Path.GetExtension(filepath) == ".xls") { constring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + filepath + "';Extended Properties='Excel 8.0;HDR=Yes;'"; } else if (System.IO.Path.GetExtension(filepath) == ".xlsx") { constring = "Provider= Microsoft.ACE.OLEDB.12.0;OLE DB Services=-4;Data Source='" + filepath + "'; Extended Properties=\"Excel 12.0;HDR=YES;\""; } if (string.IsNullOrEmpty(constring) == false) { OleDbConnection con = new OleDbConnection(constring); con.Open(); DataTable ExcelTable = new DataTable(); ExcelTable = con.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" }); string SheetName = Convert.ToString(ExcelTable.Rows[0][2]); OleDbDataAdapter da = new OleDbDataAdapter("select * from [" + SheetName + "]", con); DataSet ds = new DataSet(); da.Fill(ds); dt = ApplicationFunction.CreateTable("tblOpngStckAccessoriesFromExcel", "Item", "String", "Qty", "String", "Rate", "String"); if (ds.Tables.Count > 0) { if (ds.Tables[0].Columns[0].Caption == "Item" && ds.Tables[0].Columns[1].Caption == "Qty" && ds.Tables[0].Columns[2].Caption == "Rate") { if (ds.Tables[0].Rows.Count > 0) { for (int count = 0; count < ds.Tables[0].Rows.Count; count++) { ApplicationFunction.DatatableAddRow(dt, Convert.ToString(ds.Tables[0].Rows[count]["Item"]), Convert.ToString(ds.Tables[0].Rows[count]["Qty"]), Convert.ToString(ds.Tables[0].Rows[count]["Rate"]) ); } } else { ShowMessageErr("Excel Is Blank.Please Upload With Data."); } } else { this.ShowMessageErr("Excel Header Not In Correct Format."); } } else { ShowMessageErr("Please Check Excel File Columns!"); } } return(dt); }
protected void lnkbtnSearch_OnClick(object sender, EventArgs e) { if (txtCalimNo.Text == "" && ddlDivPrtyName.SelectedValue == "0") { DivErrorMsg.Visible = true; lblDivErrorMsg.InnerText = "* Please Select Claim Number or Party."; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); return; } else { grdSearchRecords.Visible = true; MaterialIssueAgnClaimDAL objMaterialIssueAgnClaimDAL = new MaterialIssueAgnClaimDAL(); DataTable dt = CreateDivDt(); Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue); DateTime? DateFrom = null; DateTime?DateTo = null; DateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateFrom.Text)); DateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateTo.Text)); Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue); Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue); string ClaimNo = (string.IsNullOrEmpty(Convert.ToString(txtCalimNo.Text.Trim())) ? "" : Convert.ToString(txtCalimNo.Text.Trim())) + "" + (string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim())); var lst = objMaterialIssueAgnClaimDAL.SelectForSearch(DateFrom, DateTo, ClaimNo, PartyIdno, Location, intyearid); objMaterialIssueAgnClaimDAL = null; if (lst != null && lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { string HeadIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "HeadIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "HeadIdno"))); string HeadDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "HeadDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "HeadDate")).ToString("dd-MM-yyyy")); string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo")); string ClaimNumber = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo")); string PrtyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrtyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrtyName")); string FromCityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "FromCityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "FromCityName")); string CompName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CompName"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "CompName")); //string CompIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CompIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "CompIdno")); //string FromCityIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "FromCityIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "FromCityIdno")); ApplicationFunction.DatatableAddRow(dt, i + 1, HeadIdno, ApplicationFunction.mmddyyyy(HeadDate), (PrefNo + "" + ClaimNumber), PrtyName, FromCityName, CompName); } HidHeadIdno.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "HeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[0], "HeadIdno")); ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PrtyIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[0], "PrtyIdno")); ViewState["dtDivGrid"] = dt; dt.Dispose(); this.BindDivGrid(); DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } else { DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); } }
public void FetchRec() { OpenTyreDAL objMast = new OpenTyreDAL(); Int64 YearIdno = Convert.ToInt64(ddlDateRange.SelectedValue); Int64 LocIdno = ddlLocation.SelectedIndex == 0 ? 0 : Convert.ToInt64(ddlLocation.SelectedValue); Int64 ItemIdno = ddlItemName.SelectedIndex == 0 ? 0 : Convert.ToInt64(ddlItemName.SelectedValue); Int64 tyresizeIdno = ddltyresize.SelectedIndex == 0 ? 0 : Convert.ToInt64(ddltyresize.SelectedValue); //hidstckidno.Value = Convert.ToString(Mast.SerlDetl_id); var VarStckDetl = objMast.SelectDetlByItemIdno(YearIdno, LocIdno, ItemIdno, tyresizeIdno); if (VarStckDetl != null && VarStckDetl.Count > 0) { dtTemp = (DataTable)ViewState["dt"]; if (dtTemp.Rows.Count > 0) { dtTemp = null; dtTemp = CreateDt(); ViewState["dt"] = dtTemp; } for (int i = 0; i < VarStckDetl.Count; i++) { int type = Convert.ToInt32(DataBinder.Eval(VarStckDetl[i], "ItemType")) - 1; ApplicationFunction.DatatableAddRow(dtTemp, i + 1, Convert.ToString(DataBinder.Eval(VarStckDetl[i], "SerialNo")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "CompName")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "ItemType")), Convert.ToString(ddltype.Items[type].Text), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "PurFrom")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "OpenRate")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Item_Name")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Item_Idno")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "SerialIdno")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "TyreSize")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "TyreSizeIdno"))); } ViewState["dt"] = dtTemp; dtTemp = (DataTable)ViewState["dt"]; if (dtTemp != null && dtTemp.Rows.Count > 0) { ddlItemName.Enabled = true; ddlLocation.Enabled = true; // ddlItemName.SelectedValue = Convert.ToString(DataBinder.Eval(VarStckDetl[0], "Item_Idno")); //ddlLocation.SelectedValue = Convert.ToString(DataBinder.Eval(VarStckDetl[0], "Loc_Idno")); } else { ddlItemName.Enabled = true; ddlLocation.Enabled = true; } this.BindGridT(); } else { dtTemp = null; dtTemp = CreateDt(); ViewState["dt"] = dtTemp; grdMain.DataSource = dtTemp; grdMain.DataBind(); } }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { int id = Convert.ToInt32(e.CommandArgument); dtTemp = (DataTable)ViewState["dt"]; GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).Parent.Parent; if (e.CommandName == "cmdedit") { dtTemp = (DataTable)ViewState["dt"]; DataRow[] drs = dtTemp.Select("Id='" + id + "'"); if (drs.Length > 0) { txtSerialNo.Text = Convert.ToString(drs[0]["SerialNo"]); txtCompName.Text = Convert.ToString(drs[0]["CompName"]); ddltype.SelectedValue = Convert.ToString(drs[0]["TypeId"]); ddltyresize.SelectedValue = string.IsNullOrEmpty(Convert.ToString(drs[0]["tyresizeidno"]))? "0" : Convert.ToString(drs[0]["tyresizeidno"]); txtPurchaseFrom.Text = Convert.ToString(drs[0]["PurFrom"]); txtOpenRate.Text = Convert.ToString(drs[0]["OpenRate"]); //ddlItemName.SelectedValue = Convert.ToString(drs[0]["ItemIdno"]); ViewState["ID"] = Convert.ToString(drs[0]["id"]); ddlItemName.Enabled = false; rfvPartno.Enabled = false; } } else if (e.CommandName == "cmddelete") { //DataTable dtInnerDelete = CreateDt(); DataTable objDataTable = CreateDt(); // dtTemp = (DataTable)ViewState["dt"]; dtDelete = (DataTable)ViewState["dtDelete"]; foreach (DataRow rw in dtTemp.Rows) { int ridd = Convert.ToInt32(Convert.ToString(rw["id"])); if (id != ridd) { ApplicationFunction.DatatableAddRow(objDataTable, rw["id"], rw["SerialNo"], rw["CompName"], rw["TypeId"], rw["Type"], rw["PurFrom"], rw["OpenRate"], rw["TyreName"], rw["TyreIdno"], rw["TyreSize"], rw["TyreSizeIdno"]); } else { ApplicationFunction.DatatableAddRow(dtDelete, rw["id"], rw["SerialNo"], rw["CompName"], rw["TypeId"], rw["Type"], rw["PurFrom"], rw["OpenRate"], rw["TyreName"], rw["TyreIdno"], rw["TyreSize"], rw["TyreSizeIdno"]); } } ViewState["dtDelete"] = dtDelete; ViewState["dt"] = objDataTable; objDataTable.Dispose(); this.BindGridT(); } }
//protected void lnkbtnNew_OnClick(object sender, EventArgs e) //{ // ClearItems(); //} protected void btnSubmit_Click(object sender, EventArgs e) { if (txtCommsision.Text == "") { txtCommsision.Text = "0.00"; } int Id = 1; txtCommsision.Text = Convert.ToDouble(txtCommsision.Text).ToString("N2"); if (Convert.ToDouble(txtCommsision.Text) > 0) { if (grdMain.Rows.Count > 0) { DtTemp = CreateDt(); int a = grdMain.PageIndex; for (int i = 0; i < grdMain.PageCount; i++) { grdMain.SetPageIndex(i); foreach (GridViewRow dr in grdMain.Rows) { HiddenField hidTocity_Idno = (HiddenField)dr.FindControl("hidTocity_Idno"); TextBox txtCommissionAmnt = (TextBox)dr.FindControl("txtCommissionAmnt"); Label lblCityName = (Label)dr.FindControl("lblCityName"); txtCommissionAmnt.Text = Convert.ToDouble(txtCommsision.Text).ToString("N2"); ApplicationFunction.DatatableAddRow(DtTemp, Id, hidTocity_Idno.Value, lblCityName.Text, txtCommissionAmnt.Text); Id++; } } grdMain.SetPageIndex(a); ViewState["dt"] = DtTemp; grdMain.DataSource = DtTemp; grdMain.DataBind(); } else { ShowMessageErr("Please enter details for Save Data"); ddlState.Focus(); txtCommsision.Text = "0.00"; return; } } else { ShowMessage("Please enter Amount Greater Than Zero"); txtCommsision.Focus(); } }
public void Populate(Int32 intMatIdNo) { TyreIssueDAL obj = new TyreIssueDAL(); TyreIssHead objMatHead = obj.SelectMatHead(intMatIdNo); var objMatDetl = obj.SelectMatDetail(intMatIdNo); hidGRHeadIdno.Value = Convert.ToString(intMatIdNo); if (objMatHead != null) { ddlDateRange.SelectedValue = Convert.ToString(objMatHead.Year_Idno); txtGRDate.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.MatIss_Date)) ? "" : Convert.ToDateTime(objMatHead.MatIss_Date).ToString("dd-MM-yyyy"); iGrAgainst = Convert.ToInt32(objMatHead.MatIss_Typ); // RDbDirect.Enabled = false; RDbRecpt.Enabled = false; //new txtRemarkhead.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.ReMark)) ? "" : Convert.ToString(objMatHead.ReMark); txtGRNo.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.MatIss_No)) ? "" : Convert.ToString(objMatHead.MatIss_No); ddlTruckNo.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Truck_Idno)) ? "0" : Convert.ToString(objMatHead.Truck_Idno); ddlTruckNo_SelectedIndexChanged(null, null); ddlDriver.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Driver_Idno)) ? "0" : Convert.ToString(objMatHead.Driver_Idno); ddlReciver.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Driver_Idno)) ? "0" : Convert.ToString(objMatHead.Driver_Idno); ddlLocation.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Loc_Idno)) ? "0" : Convert.ToString(objMatHead.Loc_Idno); dtTemp = CreateDt(); for (int counter = 0; counter < objMatDetl.Count; counter++) { string strItemName = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Name")); string strItemNameId = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Iteam_Idno")); string strQty = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Qty")); string strWeight = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Weght")); string strRate = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Rate")); string strAmount = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Amnt")); string strDetail = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Remark")); string strStckdetlNO = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "SerialNo")); string strStckdetl_Idno = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "SerlDetl_id")); ApplicationFunction.DatatableAddRow(dtTemp, counter + 1, strItemName, strItemNameId, strQty, strWeight, strRate, strAmount, strDetail, strStckdetlNO, strStckdetl_Idno); } ViewState["dt"] = dtTemp; BindGridT(); txtNetAmnt.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.Net_Amnt)) ? "0" : String.Format("{0:0,0.00}", objMatHead.Net_Amnt); PrintMaterial(objMatHead, objMatDetl); } obj = null; }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { int id = Convert.ToInt32(e.CommandArgument); dtTemp = (DataTable)ViewState["dt"]; GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).Parent.Parent; if (e.CommandName == "cmdedit") { dtTemp = (DataTable)ViewState["dt"]; DataRow[] drs = dtTemp.Select("Id='" + id + "'"); if (drs.Length > 0) { ddlDateRange.SelectedValue = Convert.ToString(drs[0]["YearIdno"]); ddlLocation.SelectedValue = Convert.ToString(drs[0]["LocIdno"]); ddlItemName.SelectedValue = Convert.ToString(drs[0]["ItemIdno"]); txtQty.Text = string.IsNullOrEmpty(Convert.ToString(drs[0]["Qty"])) == true ? "0" : Convert.ToString(drs[0]["Qty"]); txtOpenRate.Text = string.IsNullOrEmpty(Convert.ToString(drs[0]["Rate"])) == true ? "0.00" : Convert.ToDouble(drs[0]["Rate"]).ToString("N2"); ViewState["ID"] = Convert.ToString(drs[0]["id"]); } } else if (e.CommandName == "cmddelete") { DataTable dtInnerDelete = CreateDt(); DataTable objDataTable = CreateDt(); foreach (DataRow rw in dtTemp.Rows) { int ridd = Convert.ToInt32(Convert.ToString(rw["id"])); if (id != ridd) { ApplicationFunction.DatatableAddRow(objDataTable, rw["id"], rw["YearIdno"], rw["LocIdno"], rw["LocName"], rw["ItemIdno"], rw["ItemName"], rw["Qty"], rw["Rate"]); } else { ApplicationFunction.DatatableAddRow(dtInnerDelete, rw["id"], rw["YearIdno"], rw["LocIdno"], rw["LocName"], rw["ItemIdno"], rw["ItemName"], rw["Qty"], rw["Rate"]); } } ViewState["dt"] = objDataTable; ViewState["dtDelete"] = dtInnerDelete; this.AccDelete(); objDataTable.Dispose(); this.BindGridT(); } }
private void BindGridDB() { OpenAccDAL objOpeningStock = new OpenAccDAL(); DataTable dtItem = objOpeningStock.SelectPartFromExcel(ApplicationFunction.ConnectionString()); if (dtItem.Rows.Count > 0) { for (int i = 0; i < dtItem.Rows.Count; i++) { dtTemp = (DataTable)ViewState["dt"]; if ((dtTemp != null) && (dtTemp.Rows.Count > 0)) { foreach (DataRow row in dtTemp.Rows) { if (Convert.ToString(row["ItemIdno"]) == dtItem.Rows[i]["Item_Idno"].ToString() && Convert.ToString(row["LocIdno"]) == Convert.ToString(ddlLocation.SelectedValue)) { string msg = "Item Already Exist For Same Location"; ddlItemName.Focus(); ShowMessageErr(msg); return; } } } Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1; int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1; string strYearIdno = string.IsNullOrEmpty(ddlDateRange.SelectedValue) ? "0" : (ddlDateRange.SelectedValue); string strItemName = dtItem.Rows[i]["Item_Name"].ToString(); string strItemIdno = string.IsNullOrEmpty(dtItem.Rows[i]["Item_Idno"].ToString()) ? "0" : (dtItem.Rows[i]["Item_Idno"].ToString()); string strLocName = ddlLocation.SelectedItem.Text.Trim(); string strLocIdno = string.IsNullOrEmpty(ddlLocation.SelectedValue) ? "0" : (ddlLocation.SelectedValue); string strQty = string.IsNullOrEmpty(dtItem.Rows[i]["Item_Qty"].ToString()) ? "0" : (dtItem.Rows[i]["Item_Qty"].ToString()); string strRate = string.IsNullOrEmpty(dtItem.Rows[i]["Item_Rate"].ToString()) ? "0" : (dtItem.Rows[i]["Item_Rate"].ToString()); ApplicationFunction.DatatableAddRow(dtTemp, id, strYearIdno, strLocIdno, strLocName, strItemIdno, strItemName, strQty, strRate); } } ViewState["dt"] = dtTemp; this.BindGridT(); txtQty.Text = ""; txtOpenRate.Text = ""; ddlItemName.SelectedValue = "0"; ddlLocation.SelectedValue = "0"; }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { int id = Convert.ToInt32(e.CommandArgument); dtTemp = (DataTable)ViewState["dt"]; GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).Parent.Parent; if (e.CommandName == "cmdedit") { dtTemp = (DataTable)ViewState["dt"]; DataRow[] drs = dtTemp.Select("Id='" + id + "'"); if (drs.Length > 0) { DdlFromCty.SelectedItem.Text = Convert.ToString(drs[0]["FromCity"]); DdlToCty.SelectedItem.Text = Convert.ToString(drs[0]["ToCity"]); txtLeg.Text = Convert.ToString(drs[0]["Leg"]); txtETA.Text = Convert.ToString(drs[0]["ETA"]); txtATA.Text = Convert.ToString(drs[0]["ATA"]); txtETD.Text = Convert.ToString(drs[0]["ETD"]); txtATD.Text = Convert.ToString(drs[0]["ATD"]); txtTAThrs.Text = Convert.ToString(drs[0]["TAT_in_hrs"]); Txtdelayhrs.Text = Convert.ToString(drs[0]["Delay_in_hrs"]); txtremark.Text = Convert.ToString(drs[0]["Remarks"]); Hidrowid.Value = Convert.ToString(drs[0]["id"]); DdlFromCty.SelectedValue = Convert.ToString(drs[0]["FromCityIdno"]); DdlToCty.SelectedValue = Convert.ToString(drs[0]["ToCityIdno"]); } } else if (e.CommandName == "cmddelete") { DataTable objDataTable = CreateDt(); foreach (DataRow rw in dtTemp.Rows) { int ridd = Convert.ToInt32(Convert.ToString(rw["id"])); if (id != ridd) { ApplicationFunction.DatatableAddRow(objDataTable, rw["id"], rw["FromCity"], rw["ToCity"], rw["Leg"], rw["ETA"], rw["ATA"], rw["ETD"], rw["ATD"], rw["TAT_in_hrs"], rw["Delay_in_hrs"], rw["Remarks"], rw["FromCityIdno"], rw["ToCityIdno"]); } } ViewState["dt"] = objDataTable; objDataTable.Dispose(); this.BindGridT(); } }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { int id = Convert.ToInt32(e.CommandArgument); dtTemp = (DataTable)ViewState["dt"]; GridViewRow row = (GridViewRow)((ImageButton)e.CommandSource).Parent.Parent; if (e.CommandName == "cmdedit") { dtTemp = (DataTable)ViewState["dt"]; DataRow[] drs = dtTemp.Select("Id='" + id + "'"); if (drs.Length > 0) { txtGrNo.Text = Convert.ToString(drs[0]["GR_No"]); txtGRDate.Text = Convert.ToDateTime(drs[0]["GR_Date"]).ToString("dd-MM-yyyy"); ddlGrType.SelectedValue = Convert.ToString(Convert.ToString(drs[0]["Gr_TypeIdno"]) == "" ? 0 : drs[0]["Gr_TypeIdno"]); ddlfromCity.SelectedValue = Convert.ToString(Convert.ToString(drs[0]["FromCityIdno"]) == "" ? 1 : Convert.ToInt64(drs[0]["FromCityIdno"])); ddltoCity.SelectedValue = Convert.ToString(Convert.ToString(drs[0]["ToCityIdno"]) == "" ? 1 : Convert.ToInt64(drs[0]["ToCityIdno"])); ddlSenderName.SelectedValue = Convert.ToString(Convert.ToString(drs[0]["SenderNameIdno"]) == "" ? 1 : Convert.ToInt64(drs[0]["SenderNameIdno"])); ddlReciverName.SelectedValue = Convert.ToString(Convert.ToString(drs[0]["ReciverNameIdno"]) == "" ? 1 : Convert.ToInt64(drs[0]["ReciverNameIdno"])); txtQuantity.Text = Convert.ToString(drs[0]["Qty"]); txtweight.Text = Convert.ToString(drs[0]["Weight"]); txtAmount.Text = String.Format("{0:0,0.00}", Convert.ToDouble(drs[0]["Amount"])); txtdetail.Text = Convert.ToString(drs[0]["Detail"]); Hidrowid.Value = Convert.ToString(drs[0]["id"]); } } else if (e.CommandName == "cmddelete") { DataTable objDataTable = CreateDt(); foreach (DataRow rw in dtTemp.Rows) { int ridd = Convert.ToInt32(Convert.ToString(rw["id"])); if (id != ridd) { ApplicationFunction.DatatableAddRow(objDataTable, rw["id"], rw["GR_No"], rw["Gr_Date"], rw["Gr_Type"], rw["Gr_TypeIdno"], rw["FromCity"], rw["FromCityIdno"], rw["ToCity"], rw["ToCityIdno"], rw["SenderName"], rw["SenderNameIdno"], rw["ReciverName"], rw["ReciverNameIdno"], rw["Qty"], rw["Weight"], rw["Amount"], rw["Detail"]); } } ViewState["dt"] = objDataTable; objDataTable.Dispose(); this.BindGridT(); } }
private void BindGridDB() { OpenTyreDAL objOpeningStock = new OpenTyreDAL(); DataTable dtItem = objOpeningStock.SelectPartFromExcel(ApplicationFunction.ConnectionString()); if (dtItem.Rows.Count > 0) { for (int i = 0; i < dtItem.Rows.Count; i++) { dtTemp = (DataTable)ViewState["dt"]; if ((dtTemp != null) && (dtTemp.Rows.Count > 0)) { foreach (DataRow row in dtTemp.Rows) { if (Convert.ToString(row["SerialNo"]) == Convert.ToString(dtItem.Rows[i]["SerialNo"].ToString())) { string msg = "Serial No. Already Exist For Same Item"; ddlItemName.Focus(); ShowMessageErr(msg); return; } } } Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1; int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1; string compName = dtItem.Rows[i]["CompanyName"].ToString(); string strSerialNo = dtItem.Rows[i]["SerialNo"].ToString(); string TypeID = dtItem.Rows[i]["Type_Idno"].ToString(); string strType = dtItem.Rows[i]["Type"].ToString(); string strPur = dtItem.Rows[i]["PurchaseFrom"].ToString(); string strItemName = dtItem.Rows[i]["Item_Name"].ToString(); string strItemIdno = dtItem.Rows[i]["Item_Idno"].ToString(); string openRate = Convert.ToDouble(dtItem.Rows[i]["Item_Rate"].ToString()).ToString("N2"); ApplicationFunction.DatatableAddRow(dtTemp, id, strSerialNo, compName, TypeID, strType, strPur, openRate, strItemName, strItemIdno); } } ViewState["dt"] = dtTemp; this.BindGridT(); }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "GetExcel") { DataTable DtCsv = CreateDt(); Int32 RowId = Convert.ToInt32(e.CommandArgument); GridViewRow CurRow = (GridViewRow)grdMain.Rows[RowId]; HiddenField hidLocId = (HiddenField)CurRow.FindControl("hidLocId"); HiddenField hidYearId = (HiddenField)CurRow.FindControl("hidYearId"); OpenTyreDAL objItemMastDAL = new OpenTyreDAL(); var lst = objItemMastDAL.GetExcel(Convert.ToInt64(hidLocId.Value), Convert.ToInt64(hidYearId.Value)); if (lst != null && lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { ApplicationFunction.DatatableAddRow(DtCsv, Convert.ToString(DataBinder.Eval(lst[i], "SerialNo")), Convert.ToString(DataBinder.Eval(lst[i], "CompanyName")), Convert.ToString(DataBinder.Eval(lst[i], "LoctionName")), Convert.ToString(DataBinder.Eval(lst[i], "ItemName")), "", Convert.ToString(DataBinder.Eval(lst[i], "Rate")), ""); } if ((DtCsv != null) && (DtCsv.Rows.Count != 0)) { DtCsv.Columns["LoctionName"].Caption = "Location"; DtCsv.Columns["ItemName"].ColumnName = "TyreName"; DtCsv.Columns["Rate"].Caption = "Rate"; DtCsv.Columns["SerialNo"].SetOrdinal(0); DtCsv.Columns["CompanyName"].SetOrdinal(1); DtCsv.Columns["LoctionName"].SetOrdinal(2); DtCsv.Columns["TyreName"].SetOrdinal(3); DtCsv.Columns["Rate"].SetOrdinal(4); DtCsv.Columns.Remove("Qty"); DtCsv.Columns.Remove("Amount"); DtCsv.AcceptChanges(); ExportDataTableToCSV(DtCsv, Convert.ToString("OpeningItemDetails")); Response.Redirect("ManageOpenStock.aspx"); } } } }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { int id = Convert.ToInt32(e.CommandArgument); DtTemp = (DataTable)ViewState["dt"]; GridViewRow row = (GridViewRow)((ImageButton)e.CommandSource).Parent.Parent; if (e.CommandName == "cmdedit") { DtTemp = (DataTable)ViewState["dt"]; DataRow[] drs = DtTemp.Select("Id='" + id + "'"); if (drs.Length > 0) { Hidrowid.Value = Convert.ToString(drs[0]["Id"]); txtSummaryNo.Text = Convert.ToString(drs[0]["Sumry_No"]); txtRecDate.Text = Convert.ToDateTime((drs[0]["Recvng_Date"])).ToString("dd-MM-yyyy"); txtReceivedAmount.Text = Convert.ToString(drs[0]["Recvng_Amnt"]); txtRemark.Text = Convert.ToString(drs[0]["Remark"]); Hidrowid.Value = Convert.ToString(drs[0]["id"]); } drpChallanDetail.Focus(); } else if (e.CommandName == "cmddelete") { DataTable dt = CreateDt(); foreach (DataRow rw in DtTemp.Rows) { int ridd = Convert.ToInt32(Convert.ToString(rw["id"])); if (id != ridd) { ApplicationFunction.DatatableAddRow(dt, rw["id"], rw["Sumry_No"], rw["Recvng_Date"], rw["Recvng_Amnt"], rw["Remark"]); } } ViewState["dt"] = dt; dt.Dispose(); this.BindGrid(); } }
protected void lnkBtnSave_Click(object sender, EventArgs e) { UpdateGrDetailDAL obj = new UpdateGrDetailDAL(); int count = 0; Int64 GrDetail = 0; Int64 qty = 0, GrNumber = 0; double Weight = 0; if (grdMain.Rows.Count <= 0) { ShowMessageErr("Please Enter Grid Details"); } else { CreateDt(); foreach (GridViewRow row in grdMain.Rows) { HiddenField hidGrIdno = (HiddenField)row.FindControl("hidGridno"); HiddenField hidItemidno = (HiddenField)row.FindControl("hidItemidno"); HiddenField hidUnitidno = (HiddenField)row.FindControl("hidUnitidno"); HiddenField hidGrdetlidno = (HiddenField)row.FindControl("hidGrdetlidno"); Label lblrateType = (Label)row.FindControl("lblrateType"); TextBox txtQty = (TextBox)row.FindControl("txtQty"); qty = Convert.ToInt64(txtQty.Text); TextBox txtWeight = (TextBox)row.FindControl("txtWeight"); Weight = Convert.ToDouble(txtWeight.Text); Label GRno = (Label)row.FindControl("lblGrNo"); GrNumber = Convert.ToInt64(GRno.Text); ApplicationFunction.DatatableAddRow(DtTemp, hidGrdetlidno.Value, hidGrIdno.Value, hidItemidno.Value, hidUnitidno.Value, ((lblrateType.Text) == "Rate") ? "1" : "2", qty, Weight); } if (qty > 0 && Weight > 0) { bool value = obj.UpdateGrDetl(DtTemp, Convert.ToInt64(ddlLocation.SelectedValue)); ShowMessage("Update Successfully"); } else { ShowMessageErr("Quanity and Weight Must Be Greater then Zero"); } } }
protected void lnkbtnSearch_OnClick(object sender, EventArgs e) { ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL(); if (RDbSaleBill.Checked == true) { if (txtSBillNo.Text == "" && ddlDivPrtyName.SelectedValue == "0") { DivErrorMsg.Visible = true; lblDivErrorMsg.InnerText = "* Please Select Sale Bill Number or Party."; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); return; } else { grdSearchRecords.Visible = true; DataTable dt = CreateDivDt(); Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue); DateTime? DateFrom = null; DateTime?DateTo = null; DateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateFrom.Text)); DateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateTo.Text)); Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue); Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue); string SbillNo = (string.IsNullOrEmpty(Convert.ToString(txtSBillNo.Text.Trim())) ? "" : Convert.ToString(txtSBillNo.Text.Trim())); var lst = objClaimFrmDAL.SelectForSearch(DateFrom, DateTo, SbillNo, PartyIdno, Location, intyearid); if (lst != null && lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno"))); string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo"))); string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo")); string BillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "SbillNo")); string SbillIdNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillHeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "SbillHeadIdno")); string SBillDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SBillDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "SBillDate")).ToString("dd-MM-yyyy")); string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName")); string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName")); string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno")); ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId); } ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno"))); ViewState["dtDivGrid"] = dt; dt.Dispose(); this.BindDivGrid(); DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } else { DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); } } else { grdSearchRecords.Visible = true; DataTable dt = CreateDivDt(); Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue); Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue); Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue); var lst = objClaimFrmDAL.SearchByParty(PartyIdno, Location, intyearid); if (lst != null && lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno"))); string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo"))); string PrefNo = ""; string BillNo = "0"; string SbillIdNo = "0"; string SBillDate = ""; string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName")); string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName")); string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno")); ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId); } ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno"))); ViewState["dtDivGrid"] = dt; dt.Dispose(); this.BindDivGrid(); DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } else { DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } objClaimFrmDAL = null; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); } }
protected void lnkbtnSave_Click(object sender, EventArgs e) { string msg = ""; DateTime?ClaimDate = null; ClaimDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text)); objClaimFrmDAL = new ClaimToDAL(); DateTime CurrentDate = System.DateTime.Now; if (grdMain.Rows.Count > 0) { DTMain = CreateDt(); if (rdoAgnReceived.Checked) { foreach (GridViewRow row in grdMain.Rows) { Label lblGridSerialNo = (Label)row.FindControl("lblGridSerialNo"); TextBox txtNewSerialNo = (TextBox)row.FindControl("txtNewSerialNo"); DropDownList ddlStatus = (DropDownList)row.FindControl("ddlStatus"); if (txtNewSerialNo.Text.Trim() == "") { ShowMessageErr("Please Fill Serial Number."); txtNewSerialNo.Focus(); return; } if (lblGridSerialNo.Text.Trim() == txtNewSerialNo.Text.Trim()) { ShowMessageErr("New Serial Not same as old Serial,Check New Serial No." + txtNewSerialNo.Text.Trim() + ""); txtNewSerialNo.Focus(); return; } if (ddlStatus.SelectedValue == "1") { ShowMessageErr("Please Check Status should not be submitted."); ddlStatus.Focus(); return; } BindDropdownDAL obj = new BindDropdownDAL(); if (Request.QueryString["ClaimHeadIdno"] == null) { if (txtNewSerialNo.Text.Trim() != "") { Int64 Count = obj.CheckSerialNo(txtNewSerialNo.Text.Trim()); if (Count != 0) { ShowMessageErr("Serial Number :" + txtNewSerialNo.Text.Trim() + " already exists in stock."); txtNewSerialNo.Focus(); return; } } } } } foreach (GridViewRow row in grdMain.Rows) { HiddenField hidSerialIdno = (HiddenField)row.FindControl("hidSerialIdno"); HiddenField hidClaimIdno = (HiddenField)row.FindControl("hidClaimIdno"); Label txtDefRemark = (Label)row.FindControl("lblGridDefectNo"); Label txtVchAppDetl = (Label)row.FindControl("lblGridVehDetlNo"); DropDownList ddlStatus = (DropDownList)row.FindControl("ddlStatus"); TextBox txtRemarks = (TextBox)row.FindControl("txtRemarks"); TextBox txtNewSerialNo = (TextBox)row.FindControl("txtNewSerialNo"); HiddenField HidClaimDetailsIdno = (HiddenField)row.FindControl("HidClaimDetailsIdno"); ApplicationFunction.DatatableAddRow(DTMain, row.RowIndex + 1, hidSerialIdno.Value, hidClaimIdno.Value, txtDefRemark.Text.Trim(), txtVchAppDetl.Text.Trim(), ddlStatus.SelectedValue, txtRemarks.Text.Trim(), txtNewSerialNo.Text.Trim(), HidClaimDetailsIdno.Value); } if (rdoAgnReceived.Checked) { foreach (GridViewRow rows in grdMain.Rows) { TextBox txtNewSerialNo1 = (TextBox)rows.FindControl("txtNewSerialNo"); DataRow[] drs = DTMain.Select("NewSerialNo='" + txtNewSerialNo1.Text.Trim() + "'"); if (drs.Length > 1) { ShowMessageErr("Serial Number :" + txtNewSerialNo1.Text.Trim() + " already exists in list."); txtNewSerialNo1.Focus(); return; } } } tblClaimToComHead objClaimHead = new tblClaimToComHead(); if (rdoAgnReceived.Checked) { if (txtClaimDate.Text == "") { objClaimHead.ClaimToComRec_Date = null; } else { objClaimHead.ClaimToComRec_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text)); } } else { if (txtClaimDate.Text == "") { objClaimHead.ClaimToComHead_Date = null; } else { objClaimHead.ClaimToComHead_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text)); } } objClaimHead.ClaimToCom_No = string.IsNullOrEmpty(Convert.ToString(txtClaimNo.Text.Trim())) ? 0 : Convert.ToInt64(txtClaimNo.Text.Trim()); objClaimHead.ClaimHead_Idno = string.IsNullOrEmpty(Convert.ToString(HidClaimHeadIdno.Value)) ? 0 : Convert.ToInt64(HidClaimHeadIdno.Value); objClaimHead.Prefix_No = string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim()); objClaimHead.FromLoc_Idno = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue); objClaimHead.Year_Idno = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue); objClaimHead.Prty_Idno = string.IsNullOrEmpty(Convert.ToString(ddlParty.SelectedValue)) ? 0 : Convert.ToInt64(ddlParty.SelectedValue); objClaimHead.Comp_Idno = string.IsNullOrEmpty(Convert.ToString(ddlCompanyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlCompanyName.SelectedValue); Int64 Against = 0; if (rdoAgnSend.Checked) { Against = 1; } else { Against = 2; } objClaimHead.Against = Against; Int64 value = 0; using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) { if (string.IsNullOrEmpty(hidid.Value) == true) { objClaimHead.Date_Added = System.DateTime.Now; value = objClaimFrmDAL.Insert(objClaimHead, DTMain); objClaimFrmDAL = null; } else { objClaimHead.Date_Modified = System.DateTime.Now; lnkbtnNew.Visible = false; if (rdoAgnReceived.Checked) { value = objClaimFrmDAL.UpdateForRecvd(objClaimHead, Convert.ToInt32(hidid.Value), DTMain); } else { value = objClaimFrmDAL.Update(objClaimHead, Convert.ToInt32(hidid.Value), DTMain); } objClaimFrmDAL = null; } if (string.IsNullOrEmpty(hidid.Value) == false) { if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false)) { ShowMessage("Record Update successfully"); Clear(); tScope.Complete(); } else if (value == -1) { ShowMessageErr("Claim Number Already Exist"); tScope.Dispose(); } else { ShowMessageErr("Record Not Update"); tScope.Dispose(); } } else { if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == true)) { ShowMessage("Record saved Successfully "); Clear(); tScope.Complete(); } else if (value == -1) { ShowMessageErr("Claim Number Already Exist"); tScope.Dispose(); } else { ShowMessageErr("Record Not saved Successfully "); tScope.Dispose(); } } } } else { ShowMessageErr("Please Search and Select Serial Number."); return; } }
protected void lnkbtnSearch_Click(object sender, EventArgs e) { grdSearchRecords.Visible = true; objClaimFrmDAL = new ClaimToDAL(); DataTable dt = CreateDivDt(); Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue); DateTime? DateFrom = null; DateTime?DateTo = null; DateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateFrom.Text)); DateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateTo.Text)); Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue); Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue); string ClaimNo = (string.IsNullOrEmpty(Convert.ToString(txtSBillNo.Text.Trim())) ? "" : Convert.ToString(txtSBillNo.Text.Trim())) + "" + (string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim())); Int64 Value = 1; if (rdoAgnReceived.Checked) { Value = 2; } else { Value = 1; } if (Value == 2) { var lst = objClaimFrmDAL.SelectForSearchRecvd(DateFrom, DateTo, ClaimNo, PartyIdno, Location, intyearid); objClaimFrmDAL = null; if (lst != null && lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno"))); string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo"))); string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo")); string BillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo")); string SbillIdNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno")); string SBillDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CBillDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "CBillDate")).ToString("dd-MM-yyyy")); string SbillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"))) ? "N/A" : Convert.ToString(DataBinder.Eval(lst[i], "SbillNo")); string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName")); string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName")); string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno")); hidid.Value = SbillIdNo; ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId, SbillNo); } ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno"))); ddlCompanyName.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "CompIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "CompIdno"))); ViewState["dtDivGrid"] = dt; dt.Dispose(); this.BindDivGrid(); DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } else { DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); } else { var lst = objClaimFrmDAL.SelectForSearch(DateFrom, DateTo, ClaimNo, PartyIdno, Location, intyearid); objClaimFrmDAL = null; if (lst != null && lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno"))); string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo"))); string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo")); string ClaimNumber = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo")); string ClaimHeadIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno")); string CBillDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CBillDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "CBillDate")).ToString("dd-MM-yyyy")); string SbillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"))) ? "N/A" : Convert.ToString(DataBinder.Eval(lst[i], "SbillNo")); string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName")); string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName")); string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno")); ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, ClaimHeadIdno, PrefNo + "" + ClaimNumber, ApplicationFunction.mmddyyyy(CBillDate), CityName, PartyName, PartyId, SbillNo); } ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno"))); ddlCompanyName.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "CompIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "CompIdno"))); HidClaimHeadIdno.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "ClaimHeadIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "ClaimHeadIdno"))); ViewState["dtDivGrid"] = dt; dt.Dispose(); this.BindDivGrid(); DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } else { DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (ddlItemName.SelectedIndex == 0) { ShowMessageErr("Please select Item."); ddlItemName.Focus(); return; } { if (txtweight.Text == "" || Convert.ToDouble(txtweight.Text) <= 0) { ShowMessageErr("Weight should be greater than zero."); txtweight.Focus(); return; } } // if (txtQuantity.Text == "" || Convert.ToDouble(txtQuantity.Text) <= 0) { ShowMessageErr("Quantity should be greater than zero."); txtQuantity.Focus(); return; } if (txtrate.Text == "" || Convert.ToDouble(txtrate.Text) <= 0) { ShowMessageErr("Rate should be greater than zero."); txtrate.Focus(); return; } else if (txtrate.Text == "" || Convert.ToDouble(txtrate.Text) <= 0) { ShowMessageErr("Rate should be greater than zero."); txtrate.Focus(); return; } //else //{ // txtrate.Text = "0.00"; //} CalculateEdit(); string strAmount = ""; if (hidrowid.Value != string.Empty) { dtTemp = (DataTable)ViewState["dt"]; foreach (DataRow dtrow in dtTemp.Rows) { if (Convert.ToString(dtrow["id"]) == Convert.ToString(hidrowid.Value)) { dtrow["Item_Name"] = ddlItemName.SelectedItem.Text; dtrow["Item_Idno"] = ddlItemName.SelectedValue; dtrow["Quantity"] = Convert.ToString(1); iqty += Convert.ToDouble(1); dtrow["Weight"] = txtweight.Text.Trim(); dtrow["Rate"] = txtrate.Text.Trim(); dtrow["Amount"] = dtotalAmount.ToString("N2"); dtrow["Serial_No"] = ddlSerialNo.SelectedItem.Text; dtrow["Serial_Idno"] = ddlSerialNo.SelectedValue; //kapil //dtrow["Detail"] = string.Empty; //dtrow["Detail"] = txtremark.Text.Trim(); } } } else { dtTemp = (DataTable)ViewState["dt"]; Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1; int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1; string strItemName = ddlItemName.SelectedItem.Text.Trim(); string strItemNameId = string.IsNullOrEmpty(ddlItemName.SelectedValue) ? "0" : (ddlItemName.SelectedValue); //string strQty = string.IsNullOrEmpty(txtQuantity.Text.Trim()) ? "0" : (txtQuantity.Text.Trim()); string strQty = Convert.ToString(1); string strWeight = string.IsNullOrEmpty(txtweight.Text.Trim()) ? "0" : (txtweight.Text.Trim()); string strRate = string.IsNullOrEmpty(txtrate.Text.Trim()) ? "0.00" : (txtrate.Text.Trim()); string strSerialNo = string.IsNullOrEmpty(ddlSerialNo.SelectedItem.Text) ? "0" : (ddlSerialNo.SelectedItem.Text); string strSerialIdno = string.IsNullOrEmpty(ddlSerialNo.SelectedValue) ? "0" : (ddlSerialNo.SelectedValue); strAmount = dtotalAmount.ToString("N2"); //kapil //string strDetail = string.IsNullOrEmpty(txtremark.Text.Trim()) ? "" : (txtremark.Text.Trim());\ ApplicationFunction.DatatableAddRow(dtTemp, id, strItemName, strItemNameId, strQty, strWeight, strRate, strAmount, string.Empty, strSerialNo, strSerialIdno); //ApplicationFunction.DatatableAddRow(dtTemp, id, strItemName, strItemNameId, strQty, strWeight, strRate, strAmount, strDetail); ViewState["dt"] = dtTemp; } this.BindGridT(); ddlItemName.Focus(); ClearItems(); ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "filltxtthrough()", true); }
protected void lnkbtnSubmit_OnClick(object sender, EventArgs e) { if (ViewState["ID"] == null) { if (ddlItemName.SelectedIndex == 0) { ShowMessageErr("Please select Tyre."); ddlItemName.Focus(); return; } } if (ddlLocation.SelectedIndex == 0) { ShowMessageErr("Please select Location."); ddlLocation.Focus(); return; } if (ddltyresize.SelectedIndex == 0) { ShowMessageErr("Please select Tyre Size."); ddltyresize.Focus(); return; } if (txtSerialNo.Text == "") { ShowMessageErr("Enter Serial No."); txtSerialNo.Focus(); return; } if (IsExist(txtSerialNo.Text.Trim()) == true) { ShowMessageErr("Serial No:" + txtSerialNo.Text.Trim() + " already in stock"); txtSerialNo.Focus(); return; } string TotalAmount = string.Empty; dtTemp = (DataTable)ViewState["dt"]; if (dtTemp != null && dtTemp.Rows.Count > 0) { ddlItemName.Enabled = false; } else { ddlItemName.Enabled = false; } if (ViewState["ID"] != null) { foreach (DataRow dtrow in dtTemp.Rows) { if (Convert.ToString(dtrow["id"]) == Convert.ToString(ViewState["ID"].ToString())) { dtrow["SerialNo"] = txtSerialNo.Text.Trim(); dtrow["CompName"] = txtCompName.Text.Trim(); dtrow["TypeId"] = ddltype.SelectedValue; dtrow["Type"] = ddltype.SelectedItem.Text; dtrow["TyreSizeIdno"] = ddltyresize.SelectedValue; dtrow["TyreSize"] = ddltyresize.SelectedItem.Text; dtrow["PurFrom"] = txtPurchaseFrom.Text.Trim(); dtrow["OpenRate"] = Convert.ToDouble(txtOpenRate.Text.Trim()).ToString("N2"); lnkbtnSubmit.Focus(); } } ViewState["ID"] = null; } else { dtTemp = (DataTable)ViewState["dt"]; if ((dtTemp != null) && (dtTemp.Rows.Count > 0)) { foreach (DataRow row in dtTemp.Rows) { if (Convert.ToString(row["SerialNo"]) == Convert.ToString(txtSerialNo.Text.Trim())) { string msg = "Serial No Already Entered!"; ddlItemName.Focus(); ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "PassMessage('" + msg + "')", true); return; } } } Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1; int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1; string compName = string.IsNullOrEmpty(txtCompName.Text.Trim()) ? "" : txtCompName.Text.Trim(); string strSerialNo = txtSerialNo.Text.Trim(); string TypeID = string.IsNullOrEmpty(ddltype.SelectedValue) ? "0" : (ddltype.SelectedValue); string strType = ddltype.SelectedItem.Text.Trim(); string strPur = txtPurchaseFrom.Text.Trim(); string openRate = Convert.ToDouble(txtOpenRate.Text.Trim()).ToString("N2"); string ItemName = ddlItemName.SelectedItem.Text; string ItemItem = ddlItemName.SelectedValue; string tyresize = ddltyresize.SelectedItem.Text; string tyresizeidno = ddltyresize.SelectedValue; ApplicationFunction.DatatableAddRow(dtTemp, id, strSerialNo, compName, TypeID, strType, strPur, openRate, ItemName, ItemItem, "", tyresize, tyresizeidno); } ViewState["dt"] = dtTemp; this.BindGridT(); txtSerialNo.Text = ""; txtCompName.Text = ""; txtPurchaseFrom.Text = ""; txtOpenRate.Text = ""; ddlItemName.Enabled = true; rfvPartno.Enabled = true; lnkbtnNew.Visible = true; txtSerialNo.Focus(); }
protected void lnkbtnSubmit_OnClick(object sender, EventArgs e) { if (DdlVehicleNo.SelectedValue == "0") { ShowMessage("Please Select Vehicle No."); DdlVehicleNo.Focus(); return; } if (DdlLane.SelectedValue == "0") { ShowMessage("Please Select Lane."); DdlLane.Focus(); return; } if (DdlFromCity.SelectedValue == "0") { ShowMessage("Please Enter from City."); DdlFromCity.Focus(); return; } if (DdlToCity.SelectedValue == "0") { ShowMessage("Please Enter To City."); DdlToCity.Focus(); return; } if (DdlFromLoc.SelectedValue == "0") { ShowMessage("Please Enter From Location."); DdlFromLoc.Focus(); return; } if (DdlCompName.SelectedValue == "0") { ShowMessage("Please Enter Company Name."); DdlCompName.Focus(); return; } if (DdlFromCty.SelectedValue == "0") { ShowMessage("Please Enter from City."); DdlFromCty.Focus(); return; } if (DdlToCty.SelectedValue == "0") { ShowMessage("Please Enter To City."); DdlToCty.Focus(); return; } if (txtLeg.Text == "") { ShowMessage("Leg should be greater than zero."); txtLeg.Focus(); return; } if (txtETA.Text == "" || txtETA.Text == "0:00") { ShowMessage("ETA should be greater than zero."); txtETA.Focus(); return; } if (txtATA.Text == "" || txtATA.Text == "0:00") { ShowMessage("ATA should be greater than zero."); txtATA.Focus(); return; } if (txtETD.Text == "" || txtETD.Text == "0:00") { ShowMessage("ETD should be greater than zero."); txtETD.Focus(); return; } if (txtATD.Text == "" || txtATD.Text == "0:00") { ShowMessage("ATD should be greater than zero."); txtATD.Focus(); return; } if (txtTAThrs.Text == "" || txtTAThrs.Text == "0:00") { ShowMessage("TAT In Hrs should be greater than zero."); txtTAThrs.Focus(); return; } if (Txtdelayhrs.Text == "" || Txtdelayhrs.Text == "0:00") { ShowMessage("Delay In Hrs should be greater than zero."); Txtdelayhrs.Focus(); return; } if (Hidrowid.Value != string.Empty) { dtTemp = (DataTable)ViewState["dt"]; foreach (DataRow dtrow in dtTemp.Rows) { if (Convert.ToString(dtrow["Id"]) == Convert.ToString(Hidrowid.Value)) { dtrow["FromCity"] = DdlFromCty.SelectedItem.Text; dtrow["ToCity"] = DdlToCty.SelectedItem.Text; dtrow["Leg"] = string.IsNullOrEmpty(txtLeg.Text.Trim()) ? "0" : (txtLeg.Text.Trim()); dtrow["ETA"] = string.IsNullOrEmpty(txtETA.Text.Trim()) ? "0" : (txtETA.Text.Trim()); dtrow["ATA"] = string.IsNullOrEmpty(txtATA.Text.Trim()) ? "0" : (txtATA.Text.Trim()); dtrow["ETD"] = string.IsNullOrEmpty(txtETD.Text.Trim()) ? "0" : (txtETD.Text.Trim()); dtrow["ATD"] = string.IsNullOrEmpty(txtATD.Text.Trim()) ? "0" : (txtATD.Text.Trim()); dtrow["TAT_in_hrs"] = string.IsNullOrEmpty(txtTAThrs.Text.Trim()) ? "0" : (txtTAThrs.Text.Trim()); dtrow["Delay_in_hrs"] = string.IsNullOrEmpty(Txtdelayhrs.Text.Trim()) ? "0" : (Txtdelayhrs.Text.Trim()); dtrow["Remarks"] = txtremark.Text; dtrow["FromCityIdno"] = string.IsNullOrEmpty(DdlFromCty.SelectedValue.ToString()) ? "0" : (DdlFromCty.SelectedValue.ToString()); dtrow["ToCityIdno"] = string.IsNullOrEmpty(DdlToCty.SelectedValue.ToString()) ? "0" : (DdlToCty.SelectedValue.ToString()); } } } else { dtTemp = (DataTable)ViewState["dt"]; if (dtTemp == null) { dtTemp = CreateDt(); ViewState["dt"] = dtTemp; } Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1; int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["Id"])) + 1; string strFromCity = DdlFromCty.SelectedItem.Text; string strToCity = DdlToCty.SelectedItem.Text; string strLeg = string.IsNullOrEmpty(txtLeg.Text.Trim()) ? "0" : (txtLeg.Text.Trim()); string strETA = string.IsNullOrEmpty(txtETA.Text.Trim()) ? "0" : (txtETA.Text.Trim()); string strATA = string.IsNullOrEmpty(txtATA.Text.Trim()) ? "0" : (txtATA.Text.Trim()); string strETD = string.IsNullOrEmpty(txtETD.Text.Trim()) ? "0" : (txtETD.Text.Trim()); string strATD = string.IsNullOrEmpty(txtATD.Text.Trim()) ? "0" : (txtATD.Text.Trim()); string strTAThrs = string.IsNullOrEmpty(txtTAThrs.Text.Trim()) ? "0" : (txtTAThrs.Text.Trim()); string strdelayhrs = string.IsNullOrEmpty(Txtdelayhrs.Text.Trim()) ? "0" : (Txtdelayhrs.Text.Trim()); string strReamrks = txtremark.Text.Trim(); string strFromCityIdno = DdlFromCty.SelectedValue; string strToCityIdno = DdlToCty.SelectedValue; ApplicationFunction.DatatableAddRow(dtTemp, id, strFromCity, strToCity, strLeg, strETA, strATA, strETD, strATD, strTAThrs, strdelayhrs, strReamrks, strFromCityIdno, strToCityIdno); ViewState["dt"] = dtTemp; } this.BindGridT(); ClearItems(); BindCityDropDown(); }
protected void lnkbtnSubmit_OnClick(object sender, EventArgs e) { string msg = string.Empty; if (drpItemType.SelectedIndex == 0) { this.ShowMessage("Please select Item Type"); drpItemType.Focus(); return; } if (drpItemType.SelectedIndex == 1) { if (ddlTyreType.SelectedIndex == 0) { this.ShowMessage("Please Select Tyre Type"); ddlTyreType.Focus(); return; } if (drpSerialNo.SelectedIndex == 0) { this.ShowMessage("Please Select Serial No or Part No."); drpSerialNo.Focus(); return; } if (txtQty.Text == string.Empty || Convert.ToDouble(txtQty.Text) <= 0) { this.ShowMessage("Qty must be greater than 0."); txtQty.Focus(); return; } if (txtRate.Text == string.Empty || Convert.ToDouble(txtRate.Text) <= 0) { this.ShowMessage("Rate must be greater than 0."); txtRate.Focus(); return; } rfvSerialNo.Enabled = true; } else { if (txtQty.Text == string.Empty || Convert.ToDouble(txtQty.Text) <= 0) { this.ShowMessage("Qty must be greater than 0."); txtQty.Focus(); return; } if (txtRate.Text == string.Empty || Convert.ToDouble(txtRate.Text) <= 0) { this.ShowMessage("Rate must be greater than 0."); txtRate.Focus(); return; } rfvSerialNo.Enabled = false; } if (hidrowid.Value != string.Empty) { DtTemp = (DataTable)ViewState["dt"]; if (DtTemp != null && DtTemp.Rows.Count > 0) { foreach (DataRow dtrow in DtTemp.Rows) { if (Convert.ToString(dtrow["id"]) == Convert.ToString(hidrowid.Value)) { dtrow["ITEM_TYPE"] = drpItemType.SelectedItem.Text; dtrow["ITEM_TYPEID"] = drpItemType.SelectedValue; if (Convert.ToInt32(dtrow["ITEM_TYPEID"]) == 1) { dtrow["ITEM_SERIAL"] = string.IsNullOrEmpty(drpSerialNo.SelectedItem.Text) ? "" : Convert.ToString(drpSerialNo.SelectedItem.Text); dtrow["TYRE_TYPE"] = ddlTyreType.SelectedItem.Text; } else { dtrow["ITEM_SERIAL"] = ""; dtrow["TYRE_TYPE"] = ""; } dtrow["ITEM_SERIALID"] = string.IsNullOrEmpty(drpSerialNo.SelectedValue) ? 0 : Convert.ToInt32(drpSerialNo.SelectedValue); dtrow["TYRE_TYPEID"] = ddlTyreType.SelectedValue; dtrow["ITEM_QTY"] = txtQty.Text; dtrow["ITEM_RATE"] = txtRate.Text; dtrow["ITEM_AMOUNT"] = Convert.ToString(Convert.ToDouble(txtQty.Text) * Convert.ToDouble(txtRate.Text)); dtrow["ITEM_NAME"] = drpItemName.SelectedItem.Text; dtrow["ITEM_ID"] = drpItemName.SelectedValue; // dtrow["UOM_ID"] = hiduomid.Value; } } } } else { DtTemp = (DataTable)ViewState["dt"]; if ((DtTemp != null) && (DtTemp.Rows.Count > 0)) { foreach (DataRow row in DtTemp.Rows) { if (Convert.ToInt32(row["ITEM_TYPEID"]) == 1) { if (Convert.ToInt32(row["ITEM_SERIALID"]) == Convert.ToInt32(string.IsNullOrEmpty(drpSerialNo.SelectedValue) ? 0 : Convert.ToInt32(drpSerialNo.SelectedValue)) && (Convert.ToInt32(row["ITEM_TYPEID"]) == Convert.ToInt32(drpItemType.SelectedValue))) { msg = "Item Already Selected!"; drpSerialNo.Focus(); drpSerialNo.SelectedIndex = 0; this.ShowMessage(msg); return; } } else { if (Convert.ToInt32(row["ITEM_ID"]) == Convert.ToInt32(string.IsNullOrEmpty(drpItemName.SelectedValue) ? 0 : Convert.ToInt32(drpItemName.SelectedValue)) && (Convert.ToInt32(row["ITEM_TYPEID"]) == Convert.ToInt32(drpItemType.SelectedValue))) { msg = "Item Already Selected!"; drpItemName.Focus(); drpItemName.SelectedIndex = 0; this.ShowMessage(msg); return; } } } } else { DtTemp = CreateDt(); } int id = DtTemp.Rows.Count == 0 ? 1 : DtTemp.Rows.Count + 1; if (drpItemType.SelectedValue == "1") { ApplicationFunction.DatatableAddRow(DtTemp, id, drpItemType.SelectedItem.Text, drpItemType.SelectedValue, drpSerialNo.SelectedItem.Text, drpSerialNo.SelectedValue, ddlTyreType.SelectedItem.Text, ddlTyreType.SelectedValue, txtQty.Text, txtRate.Text, Convert.ToString(Convert.ToDouble(txtQty.Text) * Convert.ToDouble(txtRate.Text)), drpItemName.SelectedItem.Text, drpItemName.SelectedValue); } else { ApplicationFunction.DatatableAddRow(DtTemp, id, drpItemType.SelectedItem.Text, drpItemType.SelectedValue, "", "", "", "", txtQty.Text, txtRate.Text, Convert.ToString(Convert.ToDouble(txtQty.Text) * Convert.ToDouble(txtRate.Text)), string.IsNullOrEmpty(drpItemName.SelectedValue) ? "" : Convert.ToString(drpItemName.SelectedItem.Text), string.IsNullOrEmpty(drpItemName.SelectedValue) ? "" : Convert.ToString(drpItemName.SelectedValue)); } ViewState["dt"] = DtTemp; } this.BindGrid(); this.ClearItems(); }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { StockTransferDAL objStck = new StockTransferDAL(); int id = Convert.ToInt32(e.CommandArgument); DtTemp = (DataTable)ViewState["dt"]; //GridViewRow row = (GridViewRow)((ImageButton)e.CommandSource).Parent.Parent; if (e.CommandName == "cmdedit") { DtTemp = (DataTable)ViewState["dt"]; DataRow[] drs = DtTemp.Select("Id='" + id + "'"); if (drs.Length > 0) { drpItemType.SelectedValue = Convert.ToString(drs[0]["ITEM_TYPEID"]); if (Convert.ToInt32(hidStckid.Value) > 0) { BindItemName(); if ((drpItemType.SelectedValue == "1")) { drpItemName.SelectedValue = string.IsNullOrEmpty(drpItemName.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_ID"]); BindItem(); ddlTyreType.SelectedValue = string.IsNullOrEmpty(ddlTyreType.SelectedValue) ? "0" : Convert.ToString(drs[0]["TYRE_TYPEID"]); ddlTyreType.Enabled = true; txtQty.Text = "1"; ddlTyreType.Enabled = true; txtQty.Enabled = false; rfvddlTyreType.Enabled = true; drpSerialNo.Enabled = true; rfvSerialNo.Enabled = true; } else { drpItemName.SelectedValue = string.IsNullOrEmpty(drpItemName.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_ID"]); ddlTyreType.Enabled = false; txtQty.Enabled = true; rfvddlTyreType.Enabled = false; txtQty.Text = "1"; drpSerialNo.Enabled = false; rfvSerialNo.Enabled = false; ddlTyreType.Enabled = false; } } else { if (drpItemType.SelectedValue == "1") { BindItemName(); drpItemName.SelectedValue = string.IsNullOrEmpty(drpItemName.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_ID"]); BindItem(); drpSerialNo.SelectedValue = string.IsNullOrEmpty(drpSerialNo.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_SERIALID"]); ddlTyreType.SelectedValue = Convert.ToString(drs[0]["TYRE_TYPEID"]); ddlTyreType.Enabled = true; txtQty.Text = "1"; ddlTyreType.Enabled = true; txtQty.Enabled = false; rfvddlTyreType.Enabled = true; drpSerialNo.Enabled = true; rfvSerialNo.Enabled = true; } else { BindItemName(); drpItemName.SelectedValue = string.IsNullOrEmpty(drpItemName.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_ID"]); //drpSerialNo.SelectedValue = string.IsNullOrEmpty(drpSerialNo.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_SERIALID"]); ddlTyreType.Enabled = false; txtQty.Enabled = true; rfvddlTyreType.Enabled = false; txtQty.Text = "1"; drpSerialNo.Enabled = false; rfvSerialNo.Enabled = false; ddlTyreType.Enabled = false; } } txtQty.Text = Convert.ToString(drs[0]["ITEM_QTY"]); txtRate.Text = Convert.ToString(drs[0]["ITEM_RATE"]); hidrowid.Value = Convert.ToString(drs[0]["id"]); } drpItemType.Focus(); } else if (e.CommandName == "cmddelete") { DataTable dt = CreateDt(); foreach (DataRow rw in DtTemp.Rows) { int ridd = Convert.ToInt32(Convert.ToString(rw["id"])); if (id != ridd) { ApplicationFunction.DatatableAddRow(dt, rw["id"], rw["ITEM_TYPE"], rw["ITEM_TYPEID"], rw["ITEM_SERIAL"], rw["ITEM_SERIALID"], rw["TYRE_TYPE"], rw["TYRE_TYPEID"], rw["ITEM_QTY"], rw["ITEM_RATE"], rw["ITEM_AMOUNT"], rw["ITEM_NAME"], rw["ITEM_ID"]); } } ViewState["dt"] = dt; dt.Dispose(); this.BindGrid(); } }
private void Populate(int AcntIdno) { LedgerAccountDAL objAcntMaster = new LedgerAccountDAL(); var objAcntMast = objAcntMaster.SelectById(AcntIdno); var lst = objAcntMaster.CheckInvGen(AcntIdno); var objDocHolder = objAcntMaster.SelectDocHolder(AcntIdno); objAcntMaster = null; if (objAcntMast != null) { hiddriverPopulate.Value = Convert.ToString(lst); txtAccountPrtyName.Text = Convert.ToString(objAcntMast.Acnt_Name); txtAccountPrtyNameHindi.Text = Convert.ToString(objAcntMast.AcntName_Hindi); txtAddress1.Text = Convert.ToString(objAcntMast.Address1); txtAddress2.Text = Convert.ToString(objAcntMast.Address2); txtAccount.Text = Convert.ToString(objAcntMast.Account_No); txtBankName.Text = Convert.ToString(objAcntMast.Bank_Name); txtBranchName.Text = Convert.ToString(objAcntMast.Branch_Name); txtIfscNo.Text = Convert.ToString(objAcntMast.Ifsc_Code); txtagntCommision.Text = Convert.ToString(objAcntMast.Agnt_Commson); ddlAccountType.SelectedValue = Convert.ToString(objAcntMast.Acnt_Type); txtContEmail.Text = Convert.ToString(objAcntMast.Cont_Email); if ((Convert.ToInt32(ddlAccountType.SelectedValue) == 3) || (Convert.ToInt32(ddlAccountType.SelectedValue) == 1)) { txtcontPrsn.Enabled = false; txtContMob.Enabled = false; txtContEmail.Enabled = false; txtAddress1.Enabled = false; txtAddress2.Enabled = false; ddlState.Enabled = false; ddlCity.Enabled = false; chkStatus.Enabled = false; txtPinCode.Enabled = false; txtTin.Enabled = false; txtFax.Enabled = false; ddlCategory.Enabled = false; rfvState.Enabled = false; rfvCity.Enabled = false; rfvpetroCompany.Enabled = false; rfvpetroCompany.Visible = false; rfvCity.Visible = false; rfvState.Visible = false; SpanCityRefresh.Visible = false; ddlState.SelectedIndex = 0; ddlCity.SelectedIndex = 0; ddlDistrict.SelectedIndex = 0; } else { ddlState.SelectedValue = Convert.ToString(objAcntMast.State_Idno); this.BindCitywithStateId(Convert.ToInt32(objAcntMast.State_Idno)); if ((Convert.ToString(objAcntMast.City_Idno) != "") && (Convert.ToInt64(objAcntMast.City_Idno) > 0)) { ddlCity.SelectedValue = Convert.ToString(objAcntMast.City_Idno); } } ddlTitle.SelectedValue = Convert.ToString(objAcntMast.Titl_Idno); if (Convert.ToInt32(ddlAccountType.SelectedValue) != 12) { DivlnkClaimDetails.Visible = false; } else { DivbtnDriver.Visible = false; DivlnkClaimDetails.Visible = true; } if (Convert.ToString(objAcntMast.Acnt_Type) == "9") { txtlicense.Text = Convert.ToString(objAcntMast.DrvLicnc_NO); if (objAcntMast.DrvLNo_ExpDate != null) { txtExpiryDate.Text = Convert.ToDateTime(objAcntMast.DrvLNo_ExpDate).ToString("dd-MM-yyyy"); } txtauthority.Text = Convert.ToString(objAcntMast.DrvAuthrty_Plc); txtaccountno.Text = Convert.ToString(objAcntMast.DrvAcnt_No); Drpgurenter.SelectedValue = Convert.ToString(objAcntMast.DrvGurntr_Idno); chkVarified.Checked = Convert.ToBoolean(objAcntMast.DrvLNo_Verfd); txtDriverSOF.Text = Convert.ToString(objAcntMast.DrvFather_Nm); txtDriverAddress.Text = Convert.ToString(objAcntMast.Drv_Adres); txtDriverMobileNo1.Text = Convert.ToString(objAcntMast.Drv_MobNo1); txtDriverMobileNo2.Text = Convert.ToString(objAcntMast.Drv_MobNo2); txtDriverBankName.Text = Convert.ToString(objAcntMast.DrvBankAc_Nm); txtDriverBankAddrs.Text = Convert.ToString(objAcntMast.DrvBankAc_Adres); txtDriverRTGC.Text = Convert.ToString(objAcntMast.DrvAc_RtgsCode); txtDriverHazardousL.Text = Convert.ToString(objAcntMast.DrvHazardLic_No); if (objAcntMast.DrvHazardLic_NoExpDt != null) { txtHazardousExpiryDate.Text = Convert.ToDateTime(objAcntMast.DrvHazardLic_NoExpDt).ToString("dd-MM-yyyy"); } ViewState["LincenceNo"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvLicnc_NO)) ? "" : Convert.ToString(objAcntMast.DrvLicnc_NO); ViewState["ExpiryDate"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvLNo_ExpDate)) ? "" : Convert.ToDateTime(objAcntMast.DrvLNo_ExpDate).ToString("dd-MM-yyyy"); ViewState["Authority"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvAuthrty_Plc)) ? "" : Convert.ToString(objAcntMast.DrvAuthrty_Plc); ViewState["Account"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvAcnt_No)) ? "" : Convert.ToString(objAcntMast.DrvAcnt_No); ViewState["Guarantor"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvGurntr_Idno)) ? "0" : Convert.ToString(objAcntMast.DrvGurntr_Idno); ViewState["varified"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvLNo_Verfd)) ? "0" : Convert.ToString(objAcntMast.DrvLNo_Verfd); ViewState["FatherName"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvFather_Nm)) ? "" : Convert.ToString(objAcntMast.DrvFather_Nm); ViewState["Address"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Drv_Adres)) ? "" : Convert.ToString(objAcntMast.Drv_Adres); ViewState["Mobile1"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Drv_MobNo1)) ? "" : Convert.ToString(objAcntMast.Drv_MobNo1); ViewState["Mobile2"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Drv_MobNo2)) ? "" : Convert.ToString(objAcntMast.Drv_MobNo2); ViewState["BankName"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvBankAc_Nm)) ? "" : Convert.ToString(objAcntMast.DrvBankAc_Nm); ViewState["BankAddress"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvBankAc_Adres)) ? "" : Convert.ToString(objAcntMast.DrvBankAc_Adres); ViewState["RTGScode"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvAc_RtgsCode)) ? "" : Convert.ToString(objAcntMast.DrvAc_RtgsCode); ViewState["HazardousLicence"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvHazardLic_No)) ? "" : Convert.ToString(objAcntMast.DrvHazardLic_No); ViewState["HazardousExpiryDate"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvHazardLic_NoExpDt)) ? "" : Convert.ToDateTime(objAcntMast.DrvHazardLic_NoExpDt).ToString("dd-MM-yyyy"); } //Other Charge......... txtdetenPlantchrg.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.detenPlant_charg)) ? "0.00" :Convert.ToString(objAcntMast.detenPlant_charg); txtdetenPortchrg.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.detenPort_charg)) ? "0.00" : Convert.ToString(objAcntMast.detenPort_charg); txtcontainerchrg.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Container_charg)) ? "0.00" : Convert.ToString(objAcntMast.Container_charg); // //ddlAccountType.Enabled = false; ddlAccountSubGroup.SelectedValue = Convert.ToString(objAcntMast.ASubGrp_Idno); ddlBalanceType.SelectedValue = Convert.ToString(objAcntMast.Bal_Type); txtOpBal.Text = Convert.ToString(objAcntMast.Open_Bal); chkServExmpt.Checked = Convert.ToBoolean(objAcntMast.ServTax_Exmpt); txtcontPrsn.Text = Convert.ToString(objAcntMast.Cont_Person); txtContMob.Text = Convert.ToString(objAcntMast.Cont_Mobile); txtPinCode.Text = (Convert.ToString(objAcntMast.Pin_Code) == "0")? "" : Convert.ToString(objAcntMast.Pin_Code); txtFax.Text = Convert.ToString(objAcntMast.Fax_No); chkStatus.Checked = Convert.ToBoolean(objAcntMast.Status); ddlCompany.SelectedValue = Convert.ToString(objAcntMast.PetrolComp_Idno); ddlPrincComp.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objAcntMast.PComp_Idno)) ? "0" : Convert.ToString(objAcntMast.PComp_Idno); txtPanNo.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Pan_No)) ? "" : Convert.ToString(objAcntMast.Pan_No); txtLSTNo.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Lst_No)) ? "" : Convert.ToString(objAcntMast.Lst_No); txtcstNo.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Cst_No)) ? "" : Convert.ToString(objAcntMast.Cst_No); hidid.Value = Convert.ToString(objAcntMast.Acnt_Idno); txtGST.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.LdgrGSTIN_No)) ? "" : Convert.ToString(objAcntMast.LdgrGSTIN_No); txtShortName.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Short_Name)) ? "" : Convert.ToString(objAcntMast.Short_Name); if (objDocHolder != null && objDocHolder.Count > 0) { dtTemp = CreateDt(); for (int counter = 0; counter < objDocHolder.Count; counter++) { string strDocName = Convert.ToString(DataBinder.Eval(objDocHolder[counter], "DocName")); string strRemark = Convert.ToString(DataBinder.Eval(objDocHolder[counter], "DocRemark")); string strImage = Convert.ToString(DataBinder.Eval(objDocHolder[counter], "DocImage")); ApplicationFunction.DatatableAddRow(dtTemp, counter + 1, strDocName, strRemark, strImage); } ViewState["DocumentHolderTable"] = dtTemp; this.BindDocumentDataGrid(); } ddlTitle.Focus(); } }
public void FillGridValue() { string filename = String.Empty, filePath = String.Empty, VirtualBinaryImage = ""; decimal size = Math.Round(((decimal)fuPicture.PostedFile.ContentLength / (decimal)1024), 2); if (size > 600) { lblimgError.Visible = true; lblimgError.Text = "File size must not exceed 600 KB."; ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "ShowDocumentHolder()", true); } else { try { lblimgError.Visible = false; string[] validFileTypes = { "bmp", "gif", "png", "jpg", "jpeg" }; HttpPostedFile File1 = fuPicture.PostedFile; string ext = System.IO.Path.GetExtension(fuPicture.PostedFile.FileName); bool isValidFile = false; for (int i = 0; i < validFileTypes.Length; i++) { if (ext == "." + validFileTypes[i]) { isValidFile = true; break; } } if (!isValidFile) { string strMsg = "Invalid File. Please upload a File with extension " + string.Join(",", validFileTypes); ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true); imgEmp.ImageUrl = ""; } else { if (fuPicture.HasFile) { if (fuPicture.PostedFile.ContentLength < 5024000) { string subPath = "C:\\tmpImg"; // your code goes here bool exists = System.IO.Directory.Exists(subPath); if (!exists) { System.IO.Directory.CreateDirectory(subPath); } filename = Path.GetFileName(fuPicture.FileName); filePath = subPath + "\\" + filename; fuPicture.SaveAs(filePath); byte[] byteArray = null; HttpPostedFile file = (HttpPostedFile)fuPicture.PostedFile; using (FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read)) { byteArray = new byte[fs.Length]; int iBytesRead = fs.Read(byteArray, 0, (int)fs.Length); if (byteArray != null && byteArray.Length > 0) { // Convert the byte into image string base64String = Convert.ToBase64String(byteArray, 0, byteArray.Length); VirtualBinaryImage = "data:image/png;base64," + base64String; } } } } } } catch (Exception ex) { } dtTemp = CreateDt(); dtTemp = (DataTable)ViewState["DocumentHolderTable"]; Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1; int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1; ApplicationFunction.DatatableAddRow(dtTemp, id, txtDocName.Text.Trim(), txtDocRemark.Text.Trim(), VirtualBinaryImage); ViewState["DocumentHolderTable"] = dtTemp; this.BindDocumentDataGrid(); txtDocName.Text = string.Empty; txtDocRemark.Text = string.Empty; ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "ShowDocumentHolder()", true); } }
protected void lnkbtnSave_Click(object sender, EventArgs e) { string msg = ""; DateTime?ClaimDate = null; ClaimDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text)); ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL(); DateTime CurrentDate = System.DateTime.Now; Int64 intAgainst = 0; if (RDbSaleBill.Checked == true) { intAgainst = 0; } else { intAgainst = 1; } if (grdMain.Rows.Count > 0) { DTMain = CreateDt(); foreach (GridViewRow row in grdMain.Rows) { HiddenField hidSerialIdno = (HiddenField)row.FindControl("hidSerialIdno"); HiddenField hidSbillIdno = (HiddenField)row.FindControl("hidSbillIdno"); TextBox txtDefRemark = (TextBox)row.FindControl("txtDefRemark"); TextBox txtVchAppDetl = (TextBox)row.FindControl("txtVchAppDetl"); ApplicationFunction.DatatableAddRow(DTMain, row.RowIndex + 1, hidSerialIdno.Value, hidSbillIdno.Value, txtDefRemark.Text, txtVchAppDetl.Text); } tblClaimHead objClaimHead = new tblClaimHead(); if (txtClaimDate.Text == "") { objClaimHead.ClaimHead_Date = null; } else { objClaimHead.ClaimHead_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text)); } objClaimHead.Claim_No = string.IsNullOrEmpty(Convert.ToString(txtClaimNo.Text.Trim())) ? 0 : Convert.ToInt64(txtClaimNo.Text.Trim()); objClaimHead.Prefix_No = string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim()); objClaimHead.FromLoc_Idno = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue); objClaimHead.Year_Idno = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue); objClaimHead.Prty_Idno = string.IsNullOrEmpty(Convert.ToString(ddlParty.SelectedValue)) ? 0 : Convert.ToInt64(ddlParty.SelectedValue); objClaimHead.Claim_Against = intAgainst; objClaimHead.Comp_Idno = string.IsNullOrEmpty(Convert.ToString(ddlCompanyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlCompanyName.SelectedValue); Int64 value = 0; using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) { if (ViewState["ClaimHeadIdno"] != null) { objClaimHead.Date_Modified = System.DateTime.Now; lnkbtnNew.Visible = false; value = objClaimFrmDAL.Update(objClaimHead, Convert.ToInt32(ViewState["ClaimHeadIdno"].ToString()), DTMain); objClaimFrmDAL = null; } else { objClaimHead.Date_Added = System.DateTime.Now; value = objClaimFrmDAL.Insert(objClaimHead, DTMain); objClaimFrmDAL = null; } if (ViewState["ClaimHeadIdno"] != null) { if (value > 0 && (ViewState["ClaimHeadIdno"] != null)) { ShowMessage("Record Update successfully"); Clear(); tScope.Complete(); } else if (value == -1) { ShowMessageErr("Claim Number Already Exist"); tScope.Dispose(); } else { ShowMessageErr("Record Not Update"); tScope.Dispose(); } } else { if (value > 0 && (ViewState["ClaimHeadIdno"] == null)) { ShowMessage("Record saved Successfully "); Clear(); tScope.Complete(); } else if (value == -1) { ShowMessageErr("Claim Number Already Exist"); tScope.Dispose(); } else { ShowMessageErr("Record Not saved Successfully "); tScope.Dispose(); } } } } else { ShowMessageErr("Please Search and Select Serial Number."); return; } }
private void BindGrid() { try { DateTime?dtDateFrom = null; DateTime?dtDateTo = null; if (string.IsNullOrEmpty(txtDateFrom.Text.Trim()) == false) { dtDateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text.Trim())); } if (string.IsNullOrEmpty(txtDateTo.Text.Trim()) == false) { dtDateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text.Trim())); } TruckwiseRepDAL obj = new TruckwiseRepDAL(); DataTable DsGrdetail = new DataTable(); var detail = obj.SearchLorry(txtLorryNo.Text, dtDateFrom, dtDateTo, Convert.ToInt32(ddllorryType.SelectedValue), Convert.ToInt32(ddlReptype.SelectedValue)); if (detail != null && detail.Count > 0) { DsGrdetail = CreateDt(); ViewState["dt"] = DsGrdetail; if (ViewState["dt"] != null) { for (int i = 0; i < detail.Count; i++) { ApplicationFunction.DatatableAddRow(DsGrdetail, Convert.ToString(DataBinder.Eval(detail[i], "Lorry_No")), Convert.ToDateTime(DataBinder.Eval(detail[i], "LicDate")).ToString("dd-MM-yyyy"), Convert.ToDateTime(DataBinder.Eval(detail[i], "RC")).ToString("dd-MM-yyyy"), Convert.ToDateTime(DataBinder.Eval(detail[i], "FitDate")).ToString("dd-MM-yyyy"), Convert.ToDateTime(DataBinder.Eval(detail[i], "Insurance")).ToString("dd-MM-yyyy") ); } } if (detail != null && detail.Count > 0) { ViewState["dt"] = DsGrdetail; rows = detail.Count; grdMain.DataSource = detail; grdMain.DataBind(); imgBtnExcel.Visible = true; lblTotalRecord.Text = string.Empty; if (Convert.ToInt32(ddlReptype.SelectedValue) == 1) { grdMain.Columns[0].Visible = true; grdMain.Columns[1].Visible = true; grdMain.Columns[2].Visible = true; grdMain.Columns[3].Visible = true; grdMain.Columns[4].Visible = true; grdMain.Columns[5].Visible = true; } else if (Convert.ToInt32(ddlReptype.SelectedValue) == 2) { grdMain.Columns[0].Visible = true; grdMain.Columns[1].Visible = true; grdMain.Columns[2].Visible = true; grdMain.Columns[3].Visible = false; grdMain.Columns[4].Visible = false; grdMain.Columns[5].Visible = false; } else if (Convert.ToInt32(ddlReptype.SelectedValue) == 3) { grdMain.Columns[0].Visible = true; grdMain.Columns[1].Visible = true; grdMain.Columns[2].Visible = false; grdMain.Columns[3].Visible = true; grdMain.Columns[4].Visible = false; grdMain.Columns[5].Visible = false; } else if (Convert.ToInt32(ddlReptype.SelectedValue) == 4) { grdMain.Columns[0].Visible = true; grdMain.Columns[1].Visible = true; grdMain.Columns[2].Visible = false; grdMain.Columns[3].Visible = false; grdMain.Columns[4].Visible = true; grdMain.Columns[5].Visible = false; } else if (Convert.ToInt32(ddlReptype.SelectedValue) == 5) { grdMain.Columns[0].Visible = true; grdMain.Columns[1].Visible = true; grdMain.Columns[2].Visible = false; grdMain.Columns[3].Visible = false; grdMain.Columns[4].Visible = false; grdMain.Columns[5].Visible = true; } if (detail.Count <= 0) { lblTotalRecord.Text = "T. Record(s): 0"; imgBtnExcel.Visible = false; } else { lblTotalRecord.Text = "T. Record(s): " + rows; imgBtnExcel.Visible = true; } } else { lblTotalRecord.Text = "T. Record(s): 0"; grdMain.DataSource = null; grdMain.DataBind(); imgBtnExcel.Visible = false; } } else { lblTotalRecord.Text = "T. Record(s): 0"; grdMain.DataSource = null; grdMain.DataBind(); imgBtnExcel.Visible = false; } } catch (Exception Ex) { throw (Ex); } }
protected void lnkbtnSubmit_OnClick(object sender, EventArgs e) { if (ddlItemName.SelectedIndex == 0) { ShowMessageErr("Please select Item."); ddlItemName.Focus(); return; } if (ddlLocation.SelectedIndex == 0) { ShowMessageErr("Please select Location."); ddlLocation.Focus(); return; } if (txtQty.Text == "") { ShowMessageErr("Enter Qty"); txtQty.Focus(); return; } if (txtOpenRate.Text == "") { ShowMessageErr("Enter Qty"); txtQty.Focus(); return; } string TotalAmount = string.Empty; dtTemp = (DataTable)ViewState["dt"]; if (ViewState["ID"] != null) { foreach (DataRow dtrow in dtTemp.Rows) { if (Convert.ToString(dtrow["id"]) == Convert.ToString(ViewState["ID"].ToString())) { dtrow["YearIdno"] = ddlDateRange.SelectedValue; dtrow["LocName"] = ddlLocation.SelectedItem.Text; dtrow["LocIdno"] = ddlLocation.SelectedValue; dtrow["ItemName"] = ddlItemName.SelectedItem.Text; dtrow["ItemIdno"] = ddlItemName.SelectedValue; dtrow["Qty"] = txtQty.Text.Trim(); dtrow["Rate"] = txtOpenRate.Text.Trim(); } } ViewState["ID"] = null; } else { dtTemp = (DataTable)ViewState["dt"]; if ((dtTemp != null) && (dtTemp.Rows.Count > 0)) { foreach (DataRow row in dtTemp.Rows) { if (Convert.ToString(row["ItemIdno"]) == Convert.ToString(ddlItemName.SelectedValue) && Convert.ToString(row["LocIdno"]) == Convert.ToString(ddlLocation.SelectedValue)) { string msg = "Item Already Entered for same location"; ddlItemName.Focus(); ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "PassMessage('" + msg + "')", true); return; } } } Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1; int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1; string strYearIdno = string.IsNullOrEmpty(ddlDateRange.SelectedValue) ? "0" : (ddlDateRange.SelectedValue); string strItemName = ddlItemName.SelectedItem.Text.Trim(); string strItemIdno = string.IsNullOrEmpty(ddlItemName.SelectedValue) ? "0" : (ddlItemName.SelectedValue); string strLocName = ddlLocation.SelectedItem.Text.Trim(); string strLocIdno = string.IsNullOrEmpty(ddlLocation.SelectedValue) ? "0" : (ddlLocation.SelectedValue); string strQty = txtQty.Text.Trim(); string strRate = txtOpenRate.Text.Trim(); ApplicationFunction.DatatableAddRow(dtTemp, id, strYearIdno, strLocIdno, strLocName, strItemIdno, strItemName, strQty, strRate); } ViewState["dt"] = dtTemp; this.BindGridT(); txtQty.Text = ""; txtOpenRate.Text = ""; ddlItemName.SelectedValue = "0"; ddlLocation.SelectedValue = "0"; }