private void BindGrid() { Int64 Loc_id = Convert.ToInt64(drpBaseCity.SelectedValue); Int64 Item_id = Convert.ToInt64(ddlItemName.SelectedValue); Int64 Party_Id = Convert.ToInt64(ddlPartyName.SelectedValue); RateMasterDAL obj = new RateMasterDAL(); dtGrid = obj.SelectPartyItemRateListReport("SelectRateRep", Convert.ToInt32(ddlDateRange.SelectedValue), Convert.ToString(txtDateFrom.Text.Trim()), Convert.ToString(txtDateTo.Text), Convert.ToInt32(ddlPartyName.SelectedValue), Loc_id, Item_id, ApplicationFunction.ConnectionString()); if (dtGrid != null) { lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(dtGrid.Rows.Count); //GridDiv.Visible = true; grdMain.DataSource = dtGrid; grdMain.DataBind(); imgBtnExcel.Visible = true; } else { lblTotalRecord.Text = "0"; grdMain.DataSource = null; grdMain.DataBind(); imgBtnExcel.Visible = false; } }
//protected void ddlDateRange_SelectedIndexChanged(object sender, EventArgs e) //{ // SetDate(); // drpBaseCity.Focus(); //} //protected void drpBaseCity_SelectedIndexChanged(object sender, EventArgs e) //{ // if (drpBaseCity.SelectedIndex > 0) // { // ClearAll(); // grdMain.DataSource = null; // grdMain.DataBind(); // drpBaseCity.SelectedValue = HidFrmCityIdno.Value; // ddlItemratetYP.SelectedValue = HiItemRateType.Value; // BindGridDB(); // } // else if (drpBaseCity.SelectedIndex <= 0) // { // ddlItemName.SelectedIndex = 0; // } // ddlItemName.Focus(); //} //protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e) //{ // if (ddlItemName.SelectedIndex > 0 && drpBaseCity.SelectedIndex > 0) // { // BindGridDB(); // DtTemp = (DataTable)ViewState["dt"]; // if (DtTemp != null && DtTemp.Rows.Count > 0) // { // foreach (DataRow row in DtTemp.Rows) // { // if ((Convert.ToInt32(row["ToCity_Idno"]) == Convert.ToInt32(ddlCity.SelectedValue)) && (Convert.ToDateTime(row["Rate_Date"]).ToString("dd-MM-yyyy") == Convert.ToString(txtDateRate.Text))) // { // string msg = "Same city and date can not be selected!"; // ddlCity.SelectedIndex = 0; // ddlCity.Focus(); // this.ShowMessage(msg); // return; // } // } // } // txtItemWighRate.Focus(); // RateMasterDAL obj = new RateMasterDAL(); // txtKMS.Text = Convert.ToString(obj.Kms(Convert.ToInt32(drpBaseCity.SelectedValue), Convert.ToInt32(ddlCityVia.SelectedValue), Convert.ToInt32(ddlCity.SelectedValue))); // } // else // { // grdMain.DataSource = null; // grdMain.DataBind(); // ShowMessage("Please Select From City And Product Name"); // } //} #endregion #region Grid Events... protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "cmdedit") { Populate(Convert.ToInt64(e.CommandArgument)); hidSaveType.Value = Convert.ToString(e.CommandArgument); } else if (e.CommandName == "cmddelete") { RateMasterDAL RM = new RateMasterDAL(); int value = RM.DeletePartyItemRate(Convert.ToInt64(e.CommandArgument)); if (value == 1) { BindGrid(); Clear(); ShowMessage("Record Deleted Successfully"); } else { Clear(); BindGrid(); ShowMessage("Record Not Deleted!"); } } }
private void BindGrid() { Int64 Loc_id = Convert.ToInt64(drpBaseCity.SelectedValue); Int64 Item_id = Convert.ToInt64(ddlItemName.SelectedValue); Int64 Party_Id = Convert.ToInt64(ddlPartyName.SelectedValue); RateMasterDAL obj = new RateMasterDAL(); dtGrid = obj.SelectPartyItemRateList(Party_Id, Loc_id, Item_id, ApplicationFunction.ConnectionString()); if (dtGrid != null) { GridDiv.Visible = true; grdMain.DataSource = dtGrid; grdMain.DataBind(); if (IsWeight == false) { //grdMain.HeaderRow.Cells[5].Visible = false; grdMain.Columns[5].Visible = false; } else { //grdMain.HeaderRow.Cells[5].Visible = true; grdMain.Columns[5].Visible = true; } //hidSaveType.Value = "0"; } }
private void userpref() { RateMasterDAL objGrprepDAL = new RateMasterDAL(); tblUserPref userpref = objGrprepDAL.selectuserpref(); iFromCity = Convert.ToInt32(userpref.BaseCity_Idno); IsWeight = Convert.ToBoolean(userpref.WeightWise_Rate); }
public void BindItems() { RateMasterDAL obj = new RateMasterDAL(); var lst = obj.GetItems(); ddlItemName.DataSource = lst; ddlItemName.DataTextField = "Item_Name"; ddlItemName.DataValueField = "Item_Idno"; ddlItemName.DataBind(); ddlItemName.Items.Insert(0, new ListItem("--Select--", "0")); }
private void BindViaCity() { RateMasterDAL obj = new RateMasterDAL(); var lst = obj.SelectCityCombo(); obj = null; ddlCityVia.DataSource = lst; ddlCityVia.DataTextField = "City_Name"; ddlCityVia.DataValueField = "City_Idno"; ddlCityVia.DataBind(); ddlCityVia.Items.Insert(0, new ListItem("--Select--", "0")); }
private void Populate(Int64 PRateID) { RateMasterDAL obj = new RateMasterDAL(); DataSet dt = obj.SelectPartyItemRate(PRateID, ApplicationFunction.ConnectionString()); try { lnkbtnNew.Visible = true; if (dt != null && dt.Tables[0].Rows.Count > 0) { ddlCity.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["ToCity_Idno"]); ddlCityVia.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["FromCityId"]); drpBaseCity.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["Loc_Idno"]); txtItemRate.Text = Convert.ToString(dt.Tables[0].Rows[0]["Item_Rate"]); txtDateRate.Text = Convert.ToDateTime(dt.Tables[0].Rows[0]["Rate_Date"]).ToString("dd-MM-yyyy"); ddlPartyName.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["Party_Idno"]); ddlItemName.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["Item_Idno"]); txt_Weight.Text = Convert.ToString(dt.Tables[0].Rows[0]["Item_Weight"]); bool Is_Weight = Convert.ToBoolean(dt.Tables[0].Rows[0]["IsWeight"]); ddlDateRange.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["Year_Idno"]); if (Is_Weight == true) { txt_Weight.Visible = true; rfv_Weight.Enabled = true; lblWeight.Visible = true; } else { txt_Weight.Visible = false; lblWeight.Visible = false; rfv_Weight.Enabled = false; } } } catch (Exception e) { } }
protected void lnkbtnSave_Click(object sender, EventArgs e) { if (drpBaseCity.SelectedValue == "0") { ShowMessageErr("Please Select Location!"); return; } if (ddlPartyName.SelectedValue == "0") { ShowMessageErr("Please Select Party!"); return; } if (ddlItemName.SelectedValue == "0") { ShowMessageErr("Please Select Item!"); return; } if (ddlCityVia.SelectedValue == "0") { ShowMessageErr("Please Select To Via City!"); return; } if (ddlCity.SelectedValue == "0") { ShowMessageErr("Please Select To City!"); return; } if (Convert.ToDouble(txt_Weight.Text) <= 0.00 && IsWeight == true) { ShowMessageErr("Please Enter Weight More than 0!"); return; } Int64 empIdno = Convert.ToInt64((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString()); tblPartyRateMast obj = new tblPartyRateMast(); obj.Loc_Idno = Convert.ToInt64(drpBaseCity.SelectedValue); obj.Party_Idno = Convert.ToInt64(ddlPartyName.SelectedValue); obj.Item_Idno = Convert.ToInt64(ddlItemName.SelectedValue); obj.Rate_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateRate.Text.Trim()).ToString()); obj.FrmCity_Idno = Convert.ToInt64(ddlCityVia.SelectedValue); obj.ToCity_Idno = Convert.ToInt64(ddlCity.SelectedValue); obj.Item_Rate = Convert.ToDecimal(txtItemRate.Text.Trim()); obj.Emp_Idno = empIdno; obj.Date_Added = Convert.ToDateTime(DateTime.Now); obj.Date_Modified = Convert.ToDateTime(DateTime.Now); obj.Status = true; obj.Year_idno = Convert.ToInt32(ddlDateRange.SelectedValue); RateMasterDAL RM = new RateMasterDAL(); if (IsWeight == false) {// For Without Weight Wise obj.Item_Weight = 0; obj.IsWeight = false; } else { obj.Item_Weight = Convert.ToDecimal(txt_Weight.Text); obj.IsWeight = true; } if ((hidSaveType.Value != "") && (Convert.ToInt64(hidSaveType.Value)) > 0) { int value = RM.UpdatePartyItemRate(obj, Convert.ToInt64(Convert.ToInt64(hidSaveType.Value)), IsWeight); if (value == 1) { BindGrid(); Clear(); ShowMessage("Record Updated Successfully"); } else if (value == 2) { BindGrid(); ShowMessageErr("Record Already Exists!"); } else { BindGrid(); ShowMessageErr("Record Not Updated!"); } } else { int value = RM.InsertPartyItemRate(obj, IsWeight); if (value == 1) { BindGrid(); Clear(); ShowMessage("Record Inserted Successfully"); } else if (value == 2) { BindGrid(); Clear(); ShowMessageErr("Record Already Exists!"); } else { BindGrid(); Clear(); ShowMessageErr("Record Not Inserted!"); } } }