private void LoadData() { ImportHaulageEntity oImportHaulage = (ImportHaulageEntity)ImportHaulageBLL.GetImportHaulage(Convert.ToInt32(hdnHaulageChrgID.Value)); //ddlFromLocation.SelectedIndex = Convert.ToInt32(ddlFromLocation.Items.IndexOf(ddlFromLocation.Items.FindByValue(oImportHaulage.LocationFrom))); hdnFromLocation.Value = oImportHaulage.LocationFrom.Substring(oImportHaulage.LocationFrom.IndexOf('|') + 1); txtFromLocation.Text = oImportHaulage.LocationFrom.Substring(0, oImportHaulage.LocationFrom.IndexOf('|')); //ddlToLocation.SelectedIndex = Convert.ToInt32(ddlToLocation.Items.IndexOf(ddlToLocation.Items.FindByValue(oImportHaulage.LocationTo))); hdnToLocation.Value = oImportHaulage.LocationTo.Substring(oImportHaulage.LocationTo.IndexOf('|') + 1); txtToLocation.Text = oImportHaulage.LocationTo.Substring(0, oImportHaulage.LocationTo.IndexOf('|')); ddlLine.SelectedValue = oImportHaulage.LinerID.ToString(); ddlContainerSize.SelectedIndex = Convert.ToInt32(ddlContainerSize.Items.IndexOf(ddlContainerSize.Items.FindByText(oImportHaulage.ContainerSize))); txtWFrom.Text = Convert.ToString(oImportHaulage.WeightFrom); txtWTo.Text = Convert.ToString(oImportHaulage.WeightTo); txtRate.Text = Convert.ToString(oImportHaulage.HaulageRate); if (oImportHaulage.EffectDate >= Convert.ToDateTime("01/01/1950")) { txtEffectDate.Text = oImportHaulage.EffectDate.ToString("dd/MM/yyyy"); } }
public static List <IImportHaulage> GetImportHaulage(SearchCriteria searchCriteria, int ID) { string strExecution = "[mst].[spGetImportHaulageCharge]"; List <IImportHaulage> lstImportHAulage = new List <IImportHaulage>(); using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddIntegerParam("@HaulageChgID", ID); oDq.AddVarcharParam("@SchLocFrom", 100, searchCriteria.LocationFrom); oDq.AddVarcharParam("@SchLocTo", 100, searchCriteria.LocationTo); oDq.AddVarcharParam("@SchLine", 100, searchCriteria.LineName); oDq.AddVarcharParam("@SchContSize", 2, searchCriteria.ContainerSize); oDq.AddVarcharParam("@SortExpression", 50, searchCriteria.SortExpression); oDq.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { IImportHaulage oIH = new ImportHaulageEntity(reader); lstImportHAulage.Add(oIH); } reader.Close(); } return(lstImportHAulage); }
public static IImportHaulage GetImportHaulage(int ID) { string strExecution = "[mst].[spGetImportHaulageCharge]"; IImportHaulage oIH = null; using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddIntegerParam("@HaulageChgID", ID); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { oIH = new ImportHaulageEntity(reader); } reader.Close(); } return(oIH); }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { if (Convert.ToDecimal(txtWFrom.Text) > Convert.ToDecimal(txtWTo.Text)) { ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('" + ResourceManager.GetStringWithoutName("ERR00077") + "');</script>", false); return; } oImportHaulageBll = new ImportHaulageBLL(); oImportHaulageEntity = new ImportHaulageEntity(); //oUserEntity = (UserEntity)Session[Constants.SESSION_USER_INFO]; // This section has been commented temporarily oImportHaulageEntity.ContainerSize = ddlContainerSize.SelectedItem.Text; oImportHaulageEntity.HaulageRate = Convert.ToDecimal(txtRate.Text); oImportHaulageEntity.LocationFrom = hdnFromLocation.Value; oImportHaulageEntity.LocationTo = hdnToLocation.Value; oImportHaulageEntity.LinerID = ddlLine.SelectedValue.ToInt(); oImportHaulageEntity.WeightFrom = Convert.ToDecimal(txtWFrom.Text.Trim()); oImportHaulageEntity.WeightTo = Convert.ToDecimal(txtWTo.Text.Trim()); oImportHaulageEntity.HaulageStatus = true; oImportHaulageEntity.EffectDate = Convert.ToDateTime(txtEffectDate.Text); if (hdnHaulageChrgID.Value == "0") // Insert { oImportHaulageEntity.CreatedBy = _userId; // oUserEntity.Id; oImportHaulageEntity.CreatedOn = DateTime.Today.Date; oImportHaulageEntity.ModifiedBy = _userId; // oUserEntity.Id; oImportHaulageEntity.ModifiedOn = DateTime.Today.Date; switch (oImportHaulageBll.AddEditImportHAulageChrg(oImportHaulageEntity)) { case -1: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00076"); break; case 0: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00011"); ClearAll(); break; case 1: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00009"); ClearAll(); break; } } else // Update { oImportHaulageEntity.HaulageChgID = Convert.ToInt32(hdnHaulageChrgID.Value); oImportHaulageEntity.ModifiedBy = _userId;// oUserEntity.Id; oImportHaulageEntity.ModifiedOn = DateTime.Today.Date; // switch (oImportHaulageBll.AddEditImportHAulageChrg(oImportHaulageEntity)) { case -1: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00076"); break; case 0: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00011"); break; case 1: Response.Redirect("~/MasterModule/ImportHaulage-list.aspx"); break; } } } }