protected void grdMain_RowCommand1(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "cmdedit") { Populate(Convert.ToInt64(e.CommandArgument)); hidSaveType.Value = Convert.ToString(e.CommandArgument); } else if (e.CommandName == "cmddelete") { RateMasterRetailerDAL RM = new RateMasterRetailerDAL(); 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); Int64 TranType_Idno = Convert.ToInt64(ddlTranType.SelectedValue); RateMasterRetailerDAL obj = new RateMasterRetailerDAL(); dtGrid = obj.SelectPartyItemRateList(Party_Id, Loc_id, Item_id, TranType_Idno, 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() { RateMasterRetailerDAL objGrprepDAL = new RateMasterRetailerDAL(); tblUserPref userpref = objGrprepDAL.selectuserpref(); iFromCity = Convert.ToInt32(userpref.BaseCity_Idno); //IsWeight = Convert.ToBoolean(userpref.WeightWise_Rate); }
public void BindItems() { RateMasterRetailerDAL obj = new RateMasterRetailerDAL(); 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() { RateMasterRetailerDAL obj = new RateMasterRetailerDAL(); 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) { RateMasterRetailerDAL obj = new RateMasterRetailerDAL(); 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"]); ddlTranType.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["TranType_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()); tblPartyRateRetailerMast obj = new tblPartyRateRetailerMast(); 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); obj.TranType_Idno = Convert.ToInt64(ddlTranType.SelectedValue); obj.Tran_Type = Convert.ToString(ddlTranType.SelectedItem.Text); RateMasterRetailerDAL RM = new RateMasterRetailerDAL(); 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))); 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); 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!"); } } }