protected void btnAddSubmit_Click(object sender, EventArgs e) { try { DataSet ds = (DataSet)ViewState["DataRateCalc"]; if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { int iSucc = 0, iErr = 0, iRtn = 0; foreach (DataRow dr in ds.Tables[0].Rows) { iRtn = PH_RateCalc.PH_RateCalc_TransporationCalc(AppCode.strConnDB, dr, ddlDateWeek.SelectedItem.Text); if (iRtn > 0) { iSucc++; } else { iErr++; } } lblErr.Text = iSucc + "/" + ds.Tables[0].Rows.Count + " Haulier , Calculate Completed"; DataBindHaulier(); } else { lblErr.Text = "No Data Calculate."; } } catch (Exception ex) { PH_ExceptionManager.WriteError("btnAddSubmit_Click>> " + ex.Message); lblErr.Text = ex.Message; } }
protected void gvData_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { TextBox txtOldnoQty = (TextBox)gvData.Rows[e.RowIndex].FindControl("txtOldNoQty"); TextBox txtNewnoQty = (TextBox)gvData.Rows[e.RowIndex].FindControl("txtNewNoQty"); int rtn = 0; if (txtNewnoQty.Text != "" && txtOldnoQty.Text != "") { //int.Parse(Request["id"]) rtn = PH_RateCalc.PH_RateCaclAdj_TransportInsert(AppCode.strConnDB, gvData.DataKeys[e.RowIndex].Value.ToString(), int.Parse(Request["id"]), int.Parse(txtOldnoQty.Text)); if (rtn > 0) { rtn = PH_RateCalc.PH_RateCaclAdj_TransportInsert(AppCode.strConnDB, gvData.DataKeys[e.RowIndex].Value.ToString(), int.Parse(Request["id"]), int.Parse(txtNewnoQty.Text)); } } string message = rtn > 0 ? "Save Data Successfull" : "Save Data Not Successfull"; ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alertmsg", "alert('" + message + "');", true); gvData.EditIndex = -1; DataBindTrans(true); } catch (Exception ex) { lblErr.Text = ex.Message; PH_ExceptionManager.WriteError(ex.Message); } }
private void DataBindDDl() { try { DataSet ds = PH_RateCalc.PH_RateCalc_DateWeekSelAll(AppCode.strConnDB); ddlDateWeek.DataTextField = "dateweek"; ddlDateWeek.DataValueField = "dateweek"; ddlDateWeek.DataSource = ds; ddlDateWeek.DataBind(); /*DataTable dt = PH_UserVendor.PH_UserVendor_SelectAll(AppCode.strConnDB); * ddlVendorCode.DataTextField = "vendor_code"; * ddlVendorCode.DataValueField = "vendor_code"; * ddlVendorCode.DataSource = dt; * ddlVendorCode.DataBind();*/ DataTable dt = PH_HaulierInfo.PH_Haulier_SelAll(AppCode.strConnDB); ddlHaluier.DataTextField = "haulier_abbr"; ddlHaluier.DataValueField = "haulier_abbr"; ddlHaluier.DataSource = dt; ddlHaluier.DataBind(); } catch (Exception ex) { lblErr.Text = ex.Message; PH_ExceptionManager.WriteError(ex.Message); } }
protected void gvData_RowDeleting(object sender, GridViewDeleteEventArgs e) { string strAbbr = gvData.Rows[e.RowIndex].Cells[2].Text; PH_RateCalc.PH_RateCacl_TransportDelete(AppCode.strConnDB, strAbbr, ddlDateWeek.SelectedValue); DataBindHaulier(); }
protected void btnCalc_Click(object sender, EventArgs e) { try { int rtn = PH_RateCalc.PH_RateCaclAdj_TransportUpdate(AppCode.strConnDB, ddlHaluier.SelectedValue, ddlDateWeek.SelectedValue, txtVendorCode.Text); string message = rtn > 0 ? "Calculate Completed" : "Calculate Not Completed"; ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alertmsg", "alert('" + message + "');", true); } catch (Exception ex) { lblErr.Text = ex.Message; PH_ExceptionManager.WriteError(ex.Message); } }
private void DataBindDateWeek() { try { DataSet ds = PH_RateCalc.PH_RateCalc_DateWeekSelAll(AppCode.strConnDB); //PH_ExceptionManager.WriteError("DataBindDateWeek >>" + ds.Tables[0].Rows.Count); ddlDateWeek.DataValueField = "dateweek"; ddlDateWeek.DataTextField = "dateweek"; ddlDateWeek.DataSource = ds.Tables[0]; ddlDateWeek.DataBind(); if (ddlDateWeek.Items.Count > 0) { ddlDateWeek.ClearSelection(); ddlDateWeek.Items[0].Selected = true; } } catch (Exception ex) { PH_ExceptionManager.WriteError("DataBindDateWeek >>" + ex.Message); } }
private void DataBindHaulier() { try { DataSet dsHaulier = PH_RateCalc.PH_ReateCalc_HaulierSelByDateWeek(AppCode.strConnDB, ddlDateWeek.SelectedItem.Text); ViewState["DataRateCalc"] = dsHaulier; if (dsHaulier.Tables[0].Rows.Count > 0) { gvData.Visible = true; gvData.DataSource = dsHaulier; gvData.DataBind(); } else { lblErr.Text = "data not found."; gvData.Visible = false; } } catch (Exception ex) { PH_ExceptionManager.WriteError("DataBindHaulier >>" + ex.Message); } }
private void DataBindTrans(bool isNew) { try { DataSet ds; if (isNew) { ds = PH_RateCalc.PH_RateCalcAdj_TransportSel(AppCode.strConnDB, ddlHaluier.SelectedValue, txtVendorCode.Text, ddlDateWeek.SelectedValue); } else { ds = (DataSet)ViewState["RateCalcAdj"]; } ViewState["RateCalcAdj"] = ds; gvData.DataSource = ds; gvData.DataBind(); } catch (Exception ex) { lblErr.Text = ex.Message; PH_ExceptionManager.WriteError(ex.Message); } }