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);
}
}
